How To Export Outlook Contacts

Export CSV from Outlook - Outlook to CSV icon2There are many cases where you need to move your contacts out of Outlook and into another Outlook address book, web mail system, spreadsheet or database. Exporting your contacts into a format that most other email programs and services recognize is fairly straightforward.

The most common export file format is a comma separated value (CSV) file. If you are exporting your contacts for use in another copy of Outlook, we recommend that you choose an Outlook Data File (.pst) as the export format. Otherwise, CSV is the format you want to select.

Click To Download These Step By Step Instructions

Export Outlook 2010 Contacts to a CSV File

Follow these steps to save your contacts from Outlook 2010 to a CSV file:

1. Click the File tab
2. Click Options Export CSV from Outlook - File Options 3. Click Advanced 4. Under Export, click Export Export CSV from Outlook - Advanced Export 5. In the Import and Export Wizard, click Export to a file, and then click Next Export CSV from Outlook - Export to a file 6. Under Create a file of type, click the type of export that you want, and then click Next.

The most common is Comma Separated Values (Windows), also known as a CSV file. Export CSV from Outlook - Comma Separated Values Windows 7. Under Select folder to export from, select the contact folder that you want to export, and then click Next. Note: Unless you chose to export to an Outlook Data File (.pst), you can only export one folder at a time. 8. Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file. Export CSV from Outlook - Save Exported File As 9. In the Export to a File dialog box, click Next. Export CSV from Outlook - Export to a file finish 10. Click Finish.

Export Outlook 2007 Contacts to a CSV File

  • Select File | Import and Export from the menu
  • Make sure Export to a file is highlighted and click Next
  • Select Comma Separated Values (Windows) as the file format and click Next
  • Highlight the Contacts folder and click Next
  • Use the Browse button to select a location and file name for your exported contacts and click Next
  • Click Finish

You can now import your Outlook contacts into other email programs such as Mac Address Book, Gmail Contacts or Google Apps Contacts for example. 1

Scrubly sign-up.