Export contacts from Outlook
When you export your contacts from Outlook, a copy of your contacts is saved to a CSV file, or other file type. You can then use this file to import your contacts to another email account.
In Outlook on a PC, choose File.
Choose Open & Export > Import/Export.
Choose Export to a file.
Choose Comma Separated Values.
In the Select folder to export from box, scroll to the top if needed and select the Contacts folder that's under your account. Choose Next.
Choose Browse, name your file, and choose OK.
Confirm where your new contacts file will be saved on your computer, and choose Next.
Choose Finish to start exporting your contacts immediately. Outlook doesn't display any message when the export process is complete but the Import and Export Progress box goes away.
Locate the new .csv file on your computer and open it with Excel to verify your contacts are there. You'll likely have a lot of empty cells. That's normal.
Generally we recommend closing the file without saving any changes; otherwise the file might get messed up and you won't be able to use it for importing. If that happens you can always run the export process again and create a new file.
Now that your contacts are copied to a .csv file, you can import them to another account. (see below)
You can export contact information from the following sources, and then import the contacts into your address book:
Address Book | Description |
Microsoft Outlook 2007 | Export your address book as a .CSV file. The system will automatically recognize the file type and import first name, last name, and E-mail address only. |
| Microsoft Outlook 2010 | Export your address book as a .CSV file. The system will automatically recognize the file type and import first name, last name, and E-mail address only. |
Comma Separated Value File | Export the contact information as a .CSV file, and then import it into your address book. If you do not use any of the E-mail systems describe in this help topic, you can create a custom file from your system. You can import first name, last name, and E-mail address only. Create a simple data file in Microsoft Excel (or other similar program) which lists the names in your address book, and save the file in .CSV. format. |
Yahoo! | Export your address book from your online Yahoo! account. The system will automatically recognize the file type and import first name, last name, and E-mail address only. |
Gmail | Export your address book from your online Gmail account. |
| Microsoft Outlook.com | Export your address book as a .CSV file. The system will automatically recognize the file type and import first name, last name, and E-mail address only. |
To learn how to export from any of the above E-mail systems, click on the name of address book type.
Exporting from Microsoft Outlook 2007
To export contact information from Microsoft Outlook to your participant headquarters address book, perform these steps:
Open Microsoft Outlook.
Select File > Open > Import and Export. The Import and Export Wizard screen appears.
Select Export to a File and click Next. The Export to a File screen appears.
Note: Outlook 98 users, perform step 4 first.
Select Comma Separated Values (Windows) and click Next.
Select Contacts and click Next. A screen appears where you can specify where to save the file.
Click Browse and go to where to save the file, and then enter a name for the .CSV file.
Click OK.
Click Next. A screen explains what action will be performed.
Verify the checkbox for Export “Contacts” from the Folder: Contacts is selected, and then click Finish to export the data as a .CSV file.
The Comma Separated Value (.CSV) file generated in the process above is readable by the participant headquarters address book.
Open the file in an application such as Microsoft Excel, and make any changes. For example, if there are duplicate records, you may want to clean them before importing the .CSV file into your address book.
Import the contacts into your address book as described in Address Book Importing.
Exporting from Microsoft Outlook 2010
Open Microsoft Outlook.
Select File > Options.
Click Advanced.
In the Export section, click Export. The Import and Export Wizard screen appears.
Select Export to a file and click Next.
Under Create a file of type, select the option to export as a Comma Separated Values (Windows) file and click Next.
Under Select folder to export from, select the contact folder to export and click Next. A screen appears where you can specify where to save the file.
Click Browse and go to where to save the file, and then enter a name for the .CSV file.
Click OK.
Click Next. A screen explains what action will be performed.
Verify the checkbox for Export “Contacts” from the Folder: Contacts is selected, and then click Finish to export the data as a .CSV file.
The Comma Separated Value (.CSV) file generated in the process above is readable by the participant headquarters address book.
Open the file in an application such as Microsoft Excel, and make any changes. For example, if there are duplicate records, you may want to clean them before importing the .CSV file into your address book.
Import the contacts into your address book as described in Address Book Importing.
Exporting from a .CSV file
To export contact information saved as a CSV file to your personal headquarters address book, perform these steps:
From your application, save the contacts file as Comma Separated Value (CSV).
Verify the CSV file does not contain duplicate records. Clean the date as necessary.
Import the CSV file into the personal headquarters address book as described in Address Book Importing.
Exporting from Yahoo!
To export contact information from Yahoo! to your personal headquarters address book, perform these steps:
Sign into your Yahoo! account.
Note: If the remaining steps are different from what you see on your screen, search Yahoo! help for the latest address book export instructions.
Go to your contacts.
From Contacts, select Tools > Export.
For Yahoo! CSV, click Export Now.
Follow the instructions on your screen to export your address book.
Import the contacts into your address book as described in Address Book Importing.
Exporting from Gmail
To export contact information from Gmail to your personal headquarters address book, perform these steps:
Sign into your Gmail account.
Note: If the remaining steps are different from what you see on your screen, search Gmail help for the latest address book export instructions.
From the list on the left side of the page, click Contacts.
Select More actions > Export.
Follow the instructions on your screen to export your address book.
After you export contacts, import them into your address book as described in Address Book Importing.
Exporting from Microsoft Outlook.com
To export contact information from Microsoft Outlook.com to your personal headquarters address book, perform these steps:
Sign into your Outlook.com account.
Note: If the remaining steps are different from what you see on your screen, search Microsoft Outlook.com help for the latest address book export instructions.
Go to your contacts.
From People, select Manage > Export.
Follow the instructions on your screen to export your address book.
After you export contacts, import them into your address book as described in Address Book Importing.