How to save your Outlook 2016 contacts to an Excel or personal folder (PST) file?

Once a year, i consolidate a full list of my contact people – both business and personal into a spreadsheet which i keep in a network storage at home.

In today’s quick tip, i will describe a very simple process that will allow you to save your Outlook 2016 contact persons into an comma separated values (CSV) file, which you can edit with Excel and into a personal outlook data file (PST). Both are pretty similar but serve a bit different purposes.

Export into a CSV file:

This method is useful for you to export your contacts into an Excel file, so you can edit and backup them as needed. You can then go ahead and import them into your Iphone or Android phones and into third party services like GMail, Yahoo Mail or even your MAC Icloud. Business users might also import their CSV files to other Outlook mailboxes served by Microsoft Exchange.

  1. Hit File.
  2. Select Open & Export.
  3. Select Import/Export.
  4. Select Export to a file.
  5. Hit Next.
  6. Select Comma Separated Values
  7. Hit Next again.
  8. Select your Contacts folder.
  9. Select Next.
  10. Provide a meaningful name to your contacts .csv file.
  11. Hit Next and you are done.

 Export to an Outlook data file (.pst file):

Special Bonus: Download the Free PDF version of our Outlook 2016 Tips and Tricks guide.

Use this method if you want to migrate your contact between different versions of Microsoft Outlook, or want to import contacts from Outlook to

The process is similar to the one described below, in step 6 – you’ll need to pick Outlook data file to create a contacts .pst file.



Leave a Comment:

Add Your Reply