Mastering Outlook Contact Export: CSV, PST, and More!

Need to move your Outlook contacts to another email service or create a backup? This comprehensive guide shows you how to export your Outlook contacts to CSV or PST files—easily importable into Excel, Google Docs, Gmail, Yahoo, and more.

Methods Covered:

• Exporting to CSV using the wizard
• Manual CSV export (for granular control)
• Exporting to PST (for account transfers)
• Exporting contacts by category
• Exporting from Outlook Online/Outlook.com
• Exporting the Global Address List (GAL)

Exporting Outlook Contacts to CSV via the Wizard:

This method is quick but may include unwanted data.

1. Access Import/Export: In Outlook 2013 , go to File > Open & Export > Import/Export. In Outlook 2010, use File > Options > Advanced > Export.

   

2. Choose Export to File: Select this option and click Next.

   

3. Select Comma Separated Values (.csv): Click Next.

   

4. Select Contacts Folder: Choose your Contacts folder and click Next.

   

5. Browse and Save: Name your .csv file and choose a save location.

   

6. Review and Finish (or Customize): Click Next. For selective data export, choose Map Custom Fields to choose specific fields before clicking Finish.

   

Manual CSV Export (for Precise Control):

This method offers complete control over exported fields.

1. View Contacts: Open the People view and switch to Phone or List view.

   

2. Add Columns (Optional): Add or rearrange columns via View > Arrangement > Add Columns.

   

3. Copy and Paste: Select all contacts (Ctrl A), copy (Ctrl C), and paste (Ctrl V) into Excel. Save as .csv.

Exporting to PST:

Ideal for transferring contacts between Outlook accounts or computers.

1. Access Import/Export: Follow step 1 from the CSV wizard method.

2. Choose Export to File: Select this option and click Next.

3. Select Outlook Data File (.pst): Click Next.

   

4. Select Contacts Folder: Choose your Contacts folder, ensure Include subfolders is checked, and click Next.

   

5. Browse and Save: Name and save your .pst file. Set password options if desired. Click Finish.

   

Exporting by Category:

Export specific contact categories using either the manual copy/paste method (grouping or sorting by category) or the PST method (using the Filter option). Note that category colors are not preserved.

Exporting from Outlook Online/Outlook.com:

1. Sign in: Access your Outlook Online or Outlook.com account.
2. Go to People: Click People.
3. Export Contacts: Click Manage > Export contacts. Choose your export options and click Export.

Exporting the Global Address List (GAL):

Add GAL contacts to your personal Contacts folder, then export using your preferred method. For large GAL exports, consult your Exchange administrator.

This guide provides various methods to suit your needs. Choose the method that best fits your requirements and technical skills. Happy exporting!

The above is the detailed content of How to export Outlook contacts. For more information, please follow other related articles on the PHP Chinese website!