Contact Problems

How to Export Exchange Online Contacts to Salesforce as CSV

Phi Hung VoPhi Hung Vo Nov 13, 2026 869 views

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.

How to Export Exchange Online Contacts to Salesforce as CSV
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Outlook Import/Export wizard

In Outlook, click File, select Open & Export, and then choose Import/Export.

2
Choose export to CSV

Select Export to a file, click Next, choose Comma Separated Values, and click Next.

3
Select the Contacts folder

Pick the Outlook Contacts or People folder that contains the external contacts, then click Next.

4
Save the CSV file

Choose a save location, enter a file name, click Finish, and check the exported CSV file.

Export external contacts from Outlook as a CSV file
Ready for Salesforce import: The exported CSV can be uploaded in Salesforce after you map the columns to the appropriate contact fields.
Free Microsoft Office alternative

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.

Open and clean the exported Exchange Online contacts CSV before Salesforce importFull compatibility with .csv and Excel XLSX files created by Microsoft 365Free, lightweight Office suite with a familiar ribbon interfaceEasy formatting and column mapping checks without extra costs
microsoft office alternative - wps office

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.