How To Export or Import Outlook 2007, 2010 or 2013 Contacts into CSV Format

You can export your Outlook contacts to a CSV file that can then be imported into other applications or online services such as Web mail clients, Excel spreadsheets, or CRM database applications.

Transferring your Outlook contacts is basically a two-step process:

  • Export contacts to a .CSV (“comma-separated values”) file.
  • Import the contacts into the new program

Keep in mind that when Outlook exports contacts to a CSV file, it omits attachments, distribution lists, contact photos, and other data. If you are exporting contacts for use in another copy of Outlook, we recommend that you export contacts to a .PST file format.

Here’s how to export and import your contacts for Outlook 2007, 2010, and 2013.

Export your contacts: Outlook 2007

    • From the File menu, click Import and Export.

1

  • The Import and Export Wizard will open, select Export to a file, and click the Next button.
    1
  • Click Comma Separated Values (Windows), and then click Next.
    1
  • From the folder list, select the Contacts folder, and then click Next.
  • Select your desktop or some other easily accessible location to save your .CSV file.
    1
  • Type in “Contacts” for the export file name, and then click OK.
  • Click the Finish button.
    1

Export your contacts: Outlook 2010

    • From the File tab, select Options.
    • Click Advanced, scroll down to Export and click the Export button.

1

    • Under Export, click Export.

1

  • In the Import and Export Wizard, click Export to a file, and then click Next.
  • Click Comma Separated Values (Windows), and then click Next.
    1
  • Under Select folder to export from, select the contact folder that you want to export, and then click Next.
  • From the folder list, select the Contacts folder, and then click Next.
  • Select your desktop or some other easily accessible location to save your .CSV file.1
  • Type in “Contacts” for the export file name, and then click OK.
  • Click the Finish button.

Export your contacts: Outlook 2013

    • Click File, select Open & Export

1

  • Then click the Import/Export button
  • In the Import and Export Wizard, click Export to a file, and click Next.
    1
  • Click Comma Separated Values (Windows), and then click Next
  • Under Select folder to export from, select the contact folder that you want to export, click Next.
    1
  • From the folder list, select the Contacts folder, and then click Next.
  • Select your desktop or some other easily accessible location to save your .CSV file.
  • Type in “Contacts” for the export file name, and then click OK.
  • Click the Finish button.

Import you contacts: Outlook 2007

    • From the File menu, click Import and Export.

1

  • The Import and Export Wizard will open, select Import from another program or file and click the Next button.
    1
  • Select Comma Separated Values (Windows) and click Next.
    1
  • Browse to the location where you saved the exported .CSV file.There are three check boxes beneath the Browse button, what you select here will be based on your needs. If your contacts list is currently empty it does not matter which check box you select.Click the Next button to continue.1
  • Select the Contacts folder as the destination and click Next.1
  • Click the Finish button to complete the import.

Import your contacts: Outlook 2010

    • Click the File Tab, select Open from the left menu.

1

    • Click on Import
    • The Import and Export Wizard will open, select Import from another file or program and click the Next button.
      1
    • Select Comma Separated Values (Windows) and click Next.
    • Browse to the location where you saved the exported .CSV file.

There are three check boxes beneath the browse button, what you select here will be based on your needs. If your contacts list is currently empty it does not matter which check box you select.

Click the Next button to continue.

  • Select the Contacts folder as the destination and click the Next button.
  • Click the Finish button to complete the import.

Import your contacts: Outlook 2013

    • Click File, select Open   Export

1

  • Then click the Import/Export button
  • In the Import and Export Wizard, select Import from another file or program and click the Next button.
    1
  • Select Comma Separated Values (Windows) and click Next.
  • Browse to the location where you saved the exported .CSV file.There are three check boxes beneath the Browse button, what you select here will be based on your needs. If your contacts list is currently empty it does not matter which check box you select.Click the Next button to continue.1
  • Select the Contacts folder as the destination and click the Next button.
  • Click the Finish button to complete the import.

1

Scrubly sign-up.