how to export contacts from outlook 2010 to excel

#HOW TO EXPORT CONTACTS FROM OUTLOOK 2010 TO EXCEL HOW TO#
#HOW TO EXPORT CONTACTS FROM OUTLOOK 2010 TO EXCEL SOFTWARE#

Click on the 'Clear Map' button to remove all the values on the right pane. Note: If you want to manually customize the map by yourself, click 'Map Custom Fields' button. Then it will return to the previous window which prompts you choose the path to save the exported Outlook contacts, then click 'Next'.

7, When save the exported Outlook contacts, there will have a pop-up dialog to reminds you writing the ' File name', type the name for your file and click 'OK' button.

6, When you need to select the save path of your exported contacts, you can click 'Browse' button to determine your destination folder.

5, The next step is to select folder to export from, select ' Contacts' from the showing list.

You can select ' Microsoft Excel 97-2003' which you needed, go 'Next' button.

4, Then it will pop up a dialog to choose the specific file format.

After finishing choosing, then click 'Next' button. Select 'Export to file' option of all items.

3, It will show you 'Import and Export Wizard' dialog next.

2, Then it will show a pop-up dialog which is named 'Outlook Options', click 'Advanced' of the left interface and click ' Export' on the right interface.

1, Launch the Outlook 2010, click 'File' tab and then choose 'Options'.

Part 1: Export contacts from outlook to Excel (Take Outlook 2010 for example) Then you don't need to type the contacts information over and over again.

#HOW TO EXPORT CONTACTS FROM OUTLOOK 2010 TO EXCEL HOW TO#

How to export Outlook contactsĮxport Outlook contacts to Excel and CSV profile is a way to keep or backup contacts, it is also easy to import it to other application for backup. The next article will show you the detailed steps to demonstrate how to export Outlook contacts easily. All these questions need to solve 'How to export outlook contacts'?Įxporting your contacts into Excel or a format that most other email programs and services recognize like CSV is fairly straightforward. Or if you are afraid of crash of your computer and losing your Outlook contacts, you may think to backup your Outlook contacts in another account. If you want to export your Outlook contacts as Excel file to save it on your computer.

#HOW TO EXPORT CONTACTS FROM OUTLOOK 2010 TO EXCEL SOFTWARE#

If that happens you can always run the export process again and create a new file.You may be accustomed to use Outlook software and store the most valuable asset in it such as contacts information. 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. csv file, you can use Excel to see what was exported from Outlook. Go to the location on your computer where you saved your contacts, for example, in the Documents folder. When the export is finished, choose OK to exit the Outlook Options box. Outlook doesn't display any message when the export process is complete but the Import and Export Progress box goes away. In the Export to a File dialog box, click Next.Ĭhoose Finish to start exporting your contacts immediately. Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file. NOTE Unless you chose to export to an Outlook Data File (.pst), you can only export one folder at a time. Under Select folder to export from, you may need to scroll up, and then select the contact folder that you want to export.

If you are exporting contacts for use in another copy of Outlook, choose an Outlook Data File (.pst). The most common is Comma Separated Values (Windows), also known as a. Under Create a file of type, choose the type of export that you want. In the Import and Export Wizard, select Export to a file, and then choose Next. In the Outlook Options box, choose Advanced. pst File To Outlook 2010)Īt the top of your Outlook ribbon, choose the File tab.

This article outlines the steps for exporting a contact list to a csv file when can be emailed to other individuals who can then import the list into their own email account.

How to export contacts from outlook 2010 to excel