How to Export Contacts from Outlook to CSV File?

Published By Jamie Kaler

Approved By Rollins Duke

Published On January 29th, 2025

Reading Time 9 Minutes Reading

Summary – Many Outlook users are searching for solutions to export contacts from Outlook to CSV files. If you are one of them, you need to search no further. In this post, we will discuss how to export Outlook address book to CSV format easily and securely.

Contacts are not just a set of numbers but an important part of our daily life. We connect with anyone in the world by just dialing a few digits. CSV is considered a valuable file format for saving information in tabular form. This is why users want to export Outlook contacts to CSV format.

Therefore, in this write-up, we will explain the top 5 most recommended solutions to export contacts from Outlook to CSV that you can use very easily. All these solutions are easy, fast, and accurate. We have mentioned complete information about all these methods in the article below. Let’s start the article.

How to Export Contacts from Outlook to CSV Format? Manually

In this article, we explain three methods to convert contacts from Outlook to CSV format. Here you will get three methods to export contacts first two methods are for Windows Outlook and rest two methods for Web and Mac Outlook. All the methods are given below one by one:

#1: Using Import/Export Wizard

1. Go to “File” > “Open & Export” > “Import/Export” in Outlook 2013 and later.
2. Choose “File” > “Options” > “Advanced” > “Export in Outlook” 2010.

   

3. In the dialog box, select “Export to a File” and click “Next”.

   

4. Click “Next” after selecting “Comma Separate Values”.

   

5. Click “Next” after choosing the “Contacts Folder” under the destination account. You may need to scroll up or down to locate the required account if you have several accounts.

   

6. Select the “Browse” option.

   

7. Give your .csv file whatever name you choose, such as Outlook_contacts, and save it to any folder on your computer.

   

8. Return to the “Export to a File” box and select the “Next” button, as seen in Step 5’s screenshot.

   

9. Click “Finish” to begin the contacts export process right now. Please be advised that this will transfer 92 fields of unnecessary information. Consequently, there will be a lot of blank cells and columns in your .csv file. Click “Map Custom Fields” and proceed with the following steps if you want to select the data to export yourself.

   

10. Perform the following actions in the “Map Custom Fields” window:
    • To get rid of the default map, use the “Clear Map” option.
    • Locate the details you wish to export in the left pane, then drag each one to the right pane individually.
    • You may drag the elements directly up and down on the right pane to reorganize the exported fields (columns in your future CSV file).
    • Drag a field that was inserted by error back to the left pane to delete it.
    • Once finished, press “OK”.

      

11. Click “Finish” when you’re back in the “Export to a File” window.

    

#2: Export Contacts from Outlook to CSV Using the Copy-Paste

1. Click the “People” symbol in the bottom “Menu” bar.
2. To convert to a table display, choose “Phone or List” in the “Change View” group on the Home page.

   

3. To export more fields than what is shown at this time, select “Add Columns” under the “3-Dot” icon > “Arrangement Group”.

   

4. Choose the required field in the left pane of the “Show Columns” dialogue box, then click the “Add” button to add it to the right pane.

   

5. Follow these steps to copy the contact information that is displayed:
   To pick every contact, use “CTRL + A”, and to copy the chosen contacts to the clipboard, use “CTRL + C”.

   

6. Open Excel or another spreadsheet application, and use the “CTRL + V” button on your keyboard to paste the contacts.

   

7. Save your Excel workbook as a .csv file if you want to import your contacts to any email service in the future.

#3: How to Export Mac Outlook Contacts to CSV?

1. Launch your Mac Outlook.
2. Click on the “Export” from the “Tools” tab.
3. Select the “Contacts” and “Continue” button.
4. Find the path to save the file locally.
5. Press on the “Save As” icon to export contacts from Outlook to CSV format.

#4: Download Address Book from Outlook.com as CSV

1. Login to your Outlook.com account.
2. Head to the “People (Contacts)” icon.
3. Select the contacts as needed.
4. Hit on the “Manage Contacts” option.
5. Then choose the “Export Contacts” option.
6. Choose the “All Contacts” and “Export” button.
7. Your contacts will be saved in .csv format in the “Download” folder.

How to Download Outlook Address Book to CSV File Quickly?

1. Firstly, launch and start the software on any operating machine like Windows or Mac.

   

2. The software will automatically detect your Outlook account from your system, which you can see on the software panel, and then press the “Next” button.

   

3. Now, choose the “Contacts” folder and then, click the “Next” button.

   

4. After that, pick the “CSV” option from the list of “File Saving Options”.

   

5. Thereafter, you can choose the “Encoding format” such as UTF-8 and UTF-16 as per your need.

   

6. Then, enter your desired location to export contacts from Outlook to CSV files.

   

7. After all, click on the “Convert” button. The conversion process is running.

   

FAQs

• Q 1. What data will be stored in the CSV file?

  Answer: The CSV file will normally contain information like your name, email address, phone number, and other contact information from your Outlook contacts.

• Q 2. Is it possible to export Outlook contacts with custom fields to CSV?

  Answer: Yes, when exporting contacts to CSV from Outlook, you may insert custom fields. Ensure that you appropriately map the custom fields throughout the export process; method 1 can be used for this.

• Q 3. Can I export Outlook contacts to CSV on a Mac?

  Answer:  Yes, the export process is the same on both the Windows and Mac versions of Outlook. Follow the same instructions as for Windows. If you face any kind of problem then you can also use automatic software. This software is also available for Mac systems.

• Q 4. Will contacts that I export be deleted from my Outlook account?

  Answer: No, when you export contacts, a copy of the contacts is stored in a CSV file. They remain on your Outlook account after this. Once exported, your contacts will still be in Outlook.

• Q 5. Is it possible to import contacts into a different email application using the generated CSV file?

  Answer: Indeed, a lot of platforms support the CSV file format. It may be used to import contacts into a variety of email clients and services that allow the import of CSV files. Verify the destination email platform’s particular import settings.

Conclusion

In this article, we have discussed three methods to export contacts from Outlook to CSV files, allowing you to choose the one that best fits your needs. We’ve aimed to cover all the essential details to guide you through the process. If you’re wondering which method is the easiest and safest, we recommend Method 5, the Automatic Solution. It’s not only 100% secure but also the simplest solution for this conversion.

You don’t need to install Outlook to use this software. A demo version is available for you to try before purchasing.  You’re just a step away from completing your task efficiently!