How to Export Your Outlook Contacts to a CSV File

You can export your Outlook address book in CSV format, easily imported into many other applications and services.

If you move from one email program to the next, you do not want to leave your contacts behind. While Outlook stores everything including mail and contacts in a horrendously complicated file, exporting your contacts to a format that most other email programs and services can understand is pretty easy.

To save your contacts from Outlook to a CSV file use the following walkthrough.

1. In Outlook 2013 and later:
   1. Click File in Outlook.
   2. Go to the Open & Export category.
   3. Click Import/Export.
2. In Outlook 2003 and Outlook 2007:
   1. Select File | Import and Export... from the menu.
3. Make sure Export to a file is highlighted.
4. Click Next >.
5. Now make sure Comma Separated Values (or Comma Separated Values (Windows)) is selected.
6. Click Next > again.
7. Highlight the desired Contacts folder.
   • You have to export separate Contacts folders separately.
8. Click Next >.
9. Use the Browse... button to specify a location and file name for the exported contacts. Something like "Outlook.csv" or "ol-contacts.csv" on your Desktop should work fine.
10. Click Next > (once more).
11. Now click Finish.

You can now import your Outlook contacts into other email programs such as Mac OS X Mail, for example.

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

1. Select File | Export from the menu in Outlook for Mac.
2. Make sure 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. Now 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. Make sure Delimited is selected in the Text Import Wizard dialog.
13. Make sure "1" is entered under Start import at row:.
14. Also make sure Macintosh is selected under File origin:.
15. Click Next >.
16. Make sure Tab (and only Tab) is checked under Delimiters.
17. Make sure Treat consecutive delimiters as one is not checked.
18. Click Next >.
19. Make sure General is selected 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 where you want to save the CSV file under Where:.
24. Make sure MS-DOS Comma Separated is selected under File Format:.

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

(Updated June 2016, tested with Outlook 2007 and Outlook 2016)