5 Easy Steps to Export Outlook Contacts to CSV

“Hi, I use the Outlook email app on my MacBook pro. I am trying to export email contacts as a .csv file but the default download does it as .olm only? How can i download the .csv file?” (From Apple Community)

If you want to know export Outlook contacts to CSV, you should read this article. This article is about two practical methods to download the contacts list from Outlook to a .csv file.

Method 1. The Best Way to Export Outlook Contacts to a CSV File

One of the good ways to export Outlook contacts to CSV is to use Cisdem ContactsMate. This app is a contacts management tool for Mac and Windows. It can be used to export Outlook contacts to common formats, for example, CSV, vCard, Excel, etc.

It is easy to use this app to export contacts from Outlook to a CSV file. You only need a few steps to do the export process.

Export Outlook Contacts to CSV on Mac

(Windows users can scroll down to find the steps.)

Step 1. Download and run the application on your Mac. 

Free Download 

Step 2. Click “Add Account” at the top left, select Exchange and sign in.

In the Internet Accounts list, choose Exchange and sign in using your Outlook account.

Step 3. Check the box next to Contacts. 

Select the Apps that you want to use with Outlook account, tick the Contacts box and click Done.

Step 4. Click the  button next to the Updated contacts detected message.

Quit and reopen this App, your Outlook contacts are uploaded to this contacts manager.

Step 5. Export contacts to CSV (Outlook) format.

Choose the Outlook group. Right-click and select Export. In the pop-up window, select “CSV(Outlook)” as the target format. Click Save.

After these five simple steps, your Outlook contacts are exported to a CSV file.

 

Export Outlook Contacts to CSV on Windows PC

Step 1. Download and install Cisdem ContactsMate.

Free Download Windows 10 or later

Step 2. When you open it, you will be prompted to add your email account. Add your Outlook account.

Step 3. Now your Outlook contacts sync with ContactsMate. Click Manage contacts in the top right corner and choose Export contacts.

Step 4. In the Export contacts dialog, click the Export as dropdown menu and choose CSV.

Step 5. Click the Export CSV platform dropdown menu. Choose the option you need. For example, if you are going to import the CSV file to Shutterfly, choose Shutterfly CSV.

 

Method 2. Export Outlook contacts to CSV manually

Things You Need to Know Before Exporting Outlook Contacts to CSV Manually

Comparing with using a contacts tool, exporting Outlook contacts to CSV manually is complicated. To save your time, we collect some key points that you need to know at first. 

1. Different versions of Outlook need different steps.

In this article, the steps to copy Outlook contacts to CSV for the Outlook versions below are introduced:

• Outlook 2010
• Outlook 2013, Outlook 2016, Outlook 2019
• The web platform, Outlook.com

If you make a mistake on your Outlook version, you will not export Outlook contacts to CSV successfully.

2. By taking manual steps, you won’t get a nicely-formatted CSV file as you expected.

Exporting Outlook contacts to CSV manually is not an easy thing. One of the biggest disadvantage is that, the exported CSV file is totally a big mess. 

There are a lot of empty cells. Every line has dozens of items and you have to move your mouse to right to see the whole data. It takes you hours to adjust the CSV file. 

3. You may export incomplete data by manual method.

Some users who manually export Outlook contacts to CSV said that the exported data is incomplete. In the exported CSV file, some information is missing.

4. Repeating the export process leads to duplicate contacts.

The reason why most of people export Outlook contacts to CSV is that they want to upload contacts to other programs, like Gmail, Yahoo.

As long as new contacts are added to your Outlook account, you may repeat the export process all the time to migrate the new contacts to your preferred email platforms.

By doing so, duplicate contacts are definitely generated. Duplicate contacts are always annoying and intolerable, especially for these who want to keep their contacts organized.

Export Outlook 2010 Contacts to CSV Manually

1. Open Outlook 2010. Go to File menu.

2. Go to options.

3. In the new window, click Advanced tab.

4. Under the Export section, click Export.

5. In “Import and Export Wizard”, select “Export to a file” option, and click Next.

6. Choose Comma Separated Values (Windows) in the list and then click Next.

7. Select a folder that you plan to export from. To export all contacts, just click on “Contacts”, and then click Next.

8. Click Browse and find a destination folder to store the CSV file. Type a name for the file. Then click OK.

9. In the Export to a File window, click Next.

10. Click Finish.

Export Outlook Contacts of Newer Versions to CSV manually (including Outlook 2013, Outlook 2016, and Outlook 2019)

1. In Outlook 2013, Outlook 2016, Outlook 2019, click the File tab.

2. Select Open & Export and go to Import/Export.

3. Select Export to a file. Click Next.

4. Choose Comma Separated Values as target format. Click Next. 

5. Select Contacts option and click Next.

6. Name the file. Click OK.

7. Click Browse to find a location on your computer to save the file.

8. Check the box to confirm your operation. Click Finish to start the exporting process.

How to Export Contacts List to CSV from Outlook.com

1. Go to Outlook.com

2. Sign in to access your Outlook.

3. Click the application icon at the top left corner.

4. Select People in the menu list.

5. Select the contacts you need one by one or directly select All contacts.

6. Click Manage in the right corner of the page. And go to Export contacts option.

7. In the pop-up window, click Export.

FAQs

Can I export an Outlook contact group to CSV?

Yes, with Cisdem ContactsMate, you can export an Outlook contact group to CSV easily. Simply right-click on the contact group you wish to export. Click Export. Choose CSV as the export format.

What are the benefits of using ContactsMate to export Outlook contacts?

1. With it, you can export Outlook contacts to CSV directly, without conversion or manually adjustment.

2. It let you export Outlook contacts to CSV without duplicate contacts.

3. It also helps find problematic contacts, such as incomplete name, invalid email address.

4. Let you export Outlook contacts to 8 different formats, such as CSV, Excel, vCard, and more.

5. This app is compatible with both Windows and Mac.

Summary

Comparing with downloading CSV file manually, it is more efficient to use Cisdem ContactsMate to export Outlook contacts to .csv file. The export process can be finished with only 5 easy steps. The CSV(Outlook) export format is unique. What’s more, it has many awesome and fantastic features, including backup contacts with 1 click, directly migrate Outlook contacts to other Apps.