How can I export contact from Outlook 2010 to csv
At the top of your Outlook 2010 ribbon, choose the File tab.
If your ribbon doesn’t have a File option in the top left corner, you’re not using Outlook 2010. to get to the import instructions for your version of Outlook.
- Choose Options.
- In the Outlook Options box, choose Advanced.
- Under the Export section, choose Export.
- In the Import and Export Wizard, select Export to a file, and then choose Next.
- Under Create a file of type, choose the type of export that you want. The most common is Comma Separated Values (Windows), also known as a .csv file. Then click Next.
If you are exporting contacts for use in another copy of Outlook, choose an Outlook Data File (.pst).
- Under Select folder to export from, you may need to scroll up, and then select the contact folder that you want to export. Choose Next when you’re done.
Note: Unless you chose to export to an Outlook Data File (.pst), you can only export one folder at a time.
- Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file.
- Click OK.
- In the Export to a File dialog box, click 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.
- When the export is finished, choose OK to exit the Outlook Options box.
- Go to the location on your computer where you saved your contacts, for example, in the Documents folder.
- If you exported your contacts as a .csv file, you can use Excel to see what was exported from Outlook. 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.