How to Export Exchange Online Contacts to Salesforce as CSV
Question details
The user needs to export external Exchange Online contacts as a CSV file for import into Salesforce but cannot locate an address-book export option in Outlook.

- Product
- Microsoft 365 Exchange Online and Outlook
- Device & OS
- not provided
- Scenario
- An organization using Microsoft 365 Enterprise E3 wants to move external Exchange Online contacts into Salesforce.
- Observed behavior
- Outlook does not show an address-book export option for these external contacts.
Verify that you have an admin role that can export Exchange Online recipient data, and check whether the external contacts appear in Outlook People or only as MailContact entries in the Exchange admin center.
Export external contacts from Outlook as a CSV file
Use this when the external contacts are already visible in Outlook People or a Contacts folder and you need a CSV file for Salesforce.
Outlook's Import/Export wizard creates a standard CSV that Salesforce can accept after column mapping.
If the contacts do not appear in Outlook, use the Exchange admin center method instead.
In Outlook, click File, select Open & Export, and then choose Import/Export.
Select Export to a file, click Next, choose Comma Separated Values, and click Next.
Pick the Outlook Contacts or People folder that contains the external contacts, then click Next.
Choose a save location, enter a file name, click Finish, and check the exported CSV file.

Export MailContact objects from the Exchange admin center
Use this when external contacts are stored as Exchange Online MailContact objects and do not appear in Outlook.
Prepare Contact CSVs for Salesforce with WPS Office
WPS Office is a free, lightweight Microsoft Office alternative that can open, edit, clean, and save the exported contacts CSV before you import it into Salesforce, with familiar tools and full format compatibility.

Frequently Asked Questions
Where is the address book export option in Outlook for Exchange Online contacts?
In classic Outlook, go to File > Open & Export > Import/Export > Export to a file > Comma Separated Values, then select the Contacts folder. If the external contacts do not appear there, use the Exchange admin center method.
Why are Exchange Online external contacts missing from Outlook People?
They may be stored only as MailContact objects in Exchange Online rather than in a personal Contacts folder. In the Exchange admin center, open Recipients > Contacts, search for MailContact, and export them to CSV.
What format should I use to import contacts into Salesforce?
Salesforce accepts CSV files. Export as CSV, open the file to verify column headers, and map them to Salesforce contact fields during the import.
Do I need admin permissions to export Exchange Online contacts?
Yes. To use the Exchange admin center export, you typically need Recipient Management or Global Administrator permissions. Outlook export only requires access to the contacts in Outlook.
Can WPS Office sync or export Exchange Online contacts directly?
No. WPS Office does not connect to Exchange Online to export contacts, but it can open and clean the CSV file after you export it from Outlook or the Exchange admin center.




