Thursday, November 7, 2013

Exporting Outlook Contacts Into CSV Files

Did you know that you could move your Outlook contacts? That’s right; in Outlook 2007 and 2010 you can export contacts from your Outlook address book and copy them into another address book, spreadsheet, web mail application or databases. Exporting these into a file and saving that in a format which is understood by most standard email programs, helps with the process.

Comma Separated Values are the most preferred file format, however if you wish to access the same contacts in another copy of Outlook, it is better to use .pst as export format. For other services use CSV files.

Exporting contacts from Outlook address book to CSV file in Outlook 2010
  • Open your MS Outlook application.
  • Click on the File tab on the top left corner of the Outlook window.
  • Click on the Options button then select the Advanced tab.
  • In the Export section click on Export.
  • When the Import and Export Wizard opens click on Export to a file and then click on Next.
  • In the section Create a file of type, select the type of export you want to carry out and click Next. Comma Separated values or CSV file is the most preferred way. Select this.
  • In Select Folder to export from option select the contact folder which you would like to export, and click Next.
  • Click on the Browse option under Save exported file as and then choose a destination folder. Type a name for the file in the File name box.
  • Click on Next in the Export to a File dialog box.
  • Click on the Finish button. All your contacts have been transferred into another file as Comma Separated Values.
  • Exporting contacts from Outlook address book to CSV file in Outlook 2007
  • Open your Outlook 2007 application and choose the Import and Export option in the File menu.
  • Ensure that you highlight Export to a file and select the Next option.
  • Choose the file format in which you wish to save the Outlook contacts. Select CSV as your file format and click on Next.
  • Using browse button select a memory location for your CSV file, and give it an appropriate name. All your exported contacts will appear in this location, in the CSV file format.
  • Click on Next and then click Finish to complete the process.
Now your Outlook contacts have been saved in a CSV file on your computer. You can access this file or copy it and access them on a different computer’s Outlook. If you have any issues contact Outlook help desk for further assistance with your problems.

No comments:

Post a Comment