Export Contacts from Outlook to a CSV File

There may be instances when you need to export your email contacts to other applications or databases. You may also use more than one email service, for example Gmail and Outlook, and want to sync Gmail with your Outlook contacts. Whatever be the reason, one cool way to export your contacts from Outlook 2010 is to export them to a CSV file. In this Outlook tutorial, you will learn how to export contacts from Outlook 2010 to a CSV file.

How to Export Contacts from Outlook 2010 to CSV File

1. Open Outlook 2010.

2. Select the File tab and choose Options.

3. In the Options dialog box, select Advanced.

4. In the right pane, scroll down to the Export section and click Export to display the Import and Export Wizard.

5. In the wizard, select Export to a file and click Next.

6. In the Create a file of type page, select Comma separated values (Windows) and click Next.

7. In the Select folder to export from page, select the Contacts folder you want to export from and click Next.

8. In the Save exported file as page, click Browse, choose a filename and a save location and click Next.

9. Confirm that you are exporting the correct folder (checkbox is checked) click Finish.

10. Close the Outlook Options dialog box.

Your file is now ready to be imported into other applications. Did you know that you can promote your Facebook fan page using email lists and a quick and easy way to import email lists is to export contacts from Outlook as a CSV file.

How to Export Contacts from Outlook 2013 to a CSV File

1. Open Outlook 2013 and select the File tab and click Options.

2. In the Outlook Options dialog box, select Advanced.

3. In the Export section, click Export.

4. In the Import and Export wizard, choose Export to a file and then click Next.

5. Select Outlook Data File (.pst) if you plan to use the names in Outlook on another computer. Else, select Comma Seperated Values if you are going to import them to another program.

6. In the Select folder to export from section, select the contact folder you want to export and then click Next.

7. In the Save exported file as section, click Browse, navigate to the location where you want to save the file, enter a file name and click OK. Then click Next.

8. If you are exporting a PST file, you have the option of setting a password. If you are exporting a CSV file, click Map Custom fields to map the fields for the contacts in the relevant boxes.

9. If necessary, click Ok and then click Finish.

10. Close the Outlook Options dialog box.

While this is the method to normally export contacts from Outlook 2013, there are cumbersome issues that you will face due to the fact that the wizard does not allow you to export all the fields and you will need to map the fields in the correct order,which involves additional work. Instead of following the above procedure, you can copy and paste the info into an Excel sheet. Here’s how.

Copy and Paste Approach to Export Contacts from Outlook 2013

1. Navigate to the Contacts folder.

2. On the Home tab, in the Current View group, click Phone to display the contacts in a table-like format.

3. Select the View tab. In the Arrangement group, click Add Column.

4. In the Show columns dialog box, you can view all the columns in the various orders and add or remove fields as you see fit. Click OK.

5. Now select all your contacts on the screen by pressing Ctrl+A.

6. Now press Crtl+C to copy the selected contacts.

7. Open up Excel and paste them by pressing Ctrl+V and save the worksheet.

You now have all your contacts copied in a more convenient format in Excel, in the XLSX format, which would not be possible to do in the Import and Export wizard.

Now that you know two different ways to export contacts from Outlook 2013, you can export your contacts in a matter of minutes, just like a pro.