On the right side, under Shortcuts to other things you can do, select Import your contacts from an existing e-mail account.In Outlook Web App, on the Options menu, select See All Options.Step 4 - Import the contacts to Outlook Web App This workbook contains features that will not work or may be removed if you save it in the selected file format. On the Format pop-up menu, select MS-DOS Comma Separated (.csv), and then select Save.Ī dialog box appears that contains the following message:
In the Save As box, type a name for the file. In Excel 2011 for Mac, on the File menu, select Save As. Under Column data format, select General, and then select Finish. Under Delimiter, select the Tab check box, and then select Next. Select Delimited as the file type, and then select Next. Be aware that in these next three steps, the default settings are used.
Export office 365 contacts to excel for mac#
Step 2 - Open the contacts by using Excel 2011 for Mac Contacts that are already associated with a Microsoft Exchange Server account or a directory services account aren't exported.In the Export Assistant, select Contacts to a list (tab-delimited text), and then select the right arrow button. In Outlook 2011 for Mac, on the File menu, select Export. Step 1 - Export the contacts from Outlook 2011 for Mac To export contacts from Outlook 2011 for Mac to Exchange Online by using Outlook Web App, follow these steps. However, the existing method to export contacts from Outlook 2011 for Mac is to use a text-delimited file, and this file type isn't supported in Microsoft 365. This occurs because external contacts must be exported from Outlook 2011 for Mac and then imported to Outlook Web App. However, external contacts aren't synced with Exchange Online. SymptomsĪ user sets up a profile in Outlook 2011 for Mac to connect to their Exchange Online mailbox in Microsoft 365.
Export office 365 contacts to excel how to#
This step-by-step article describes how to export contacts from Microsoft Outlook 2011 for Mac to Microsoft Exchange Online by using Microsoft Outlook Web App in a Microsoft 365 environment.