How to Export Your Outlook Contacts to a CSV File

Select "File | Import and Export..." from the menu
Heinz Tschabitscher

If you'd like to back up or use your Outlook contacts in another application or service, just export your Outlook address book in CSV format. Outlook makes the process fast and easy.

In Windows

  1. In Outlook 2013 and later, click File > Open & Export > Import/Export. In Outlook 2003 and 2007, select File > Import and Export from the menu.

  2. Choose Export to a file.

  3. Click Next.

  4. Select Comma Separated Values.

  5. Click Next.

    Highlight the desired Contacts folder. If you have more than one, you have to export them separately.

  6. Click Next.

  7. Browse to specify a location and file name for the exported contacts. Something like outlook.csv or ol-contacts.csv on your desktop would be appropriate.

  8. Click Next.

  9. Click Finish.

In MacOS

To save a copy of your Outlook for Mac 2011 or 2016 address book in a comma-separated CSV file:

  1. Select File > Export.

  2. Select Contacts to a list (tab-delimited text) is selected under What do you want to export?.

  3. Click the right arrow button.

  4. Choose the desired folder for the exported files under Where.

  5. Type Outlook for Mac Contacts under Save As.

  6. Click Save.

  7. Click Done.

  8. Open Excel for Mac.

  9. Select File > Open from the menu.

  10. Locate and highlight the Outlook for Mac Contacts.txt file you just saved.

  11. Click Open.

  12. Select Delimited in the Text Import Wizard dialog.

  13. Enter 1 under Start import at row.

  14. Select Macintosh under File origin.

  15. Click Next.

  16. Make sure Tab (and only Tab) is checked under Delimiters.

  17. Leave Treat consecutive delimiters as one unchecked.

  18. Click Next.

  19. Select General under Column data format.

  20. Click Finish.

  21. Select File > Save As from the menu.

  22. Type Outlook for Mac Contacts under Save As.

  23. Choose the folder in which you want to save the CSV file under Where.

  24. Select MS-DOS Comma Separated under File Format.

  25. Click Save.

  26. Click Continue.

Outlook for Mac 2016 will not let you export your address book to a tab-delimited file.