Your Outlook address book contains every contact you’ve saved, and exporting it creates a portable backup. Learning how to export outlook address book is essential for migrating contacts to a new email service or just keeping a safe copy. This guide walks you through every method step by step.
Whether you use Outlook 2016, 2019, 2021, or Microsoft 365, the process is similar. We’ll cover exporting to CSV, PST, and even directly to Google Contacts. You don’t need to be a tech expert to follow along.
Why Export Your Outlook Address Book
Your contacts are valuable. They represent clients, friends, family, and colleagues. Losing them due to a crash or migration is frustrating. Exporting gives you a backup you can restore anytime.
You might also need to share contacts with a team member or move them to a CRM system. A CSV file is universal and works with almost any software. The steps for how to export outlook address book are straightforward once you know where to click.
How To Export Outlook Address Book
This section covers the primary method using Outlook’s built-in Import/Export wizard. It works for all desktop versions of Outlook. Follow these steps carefully.
Step 1: Open The Import And Export Wizard
First, open Outlook on your computer. Click the File tab in the top-left corner. In the left sidebar, select Open & Export. Then click Import/Export. This launches the wizard.
If you don’t see “Import/Export,” look for “Import” or “Export” directly under Open & Export. The exact wording varies slightly between Outlook versions.
Step 2: Choose Export To A File
In the wizard, you’ll see several options. Select Export to a file and click Next. This is the most common choice for creating a backup of your address book.
Do not select “Import from another program or file” unless you are restoring contacts. Export is what you need here.
Step 3: Select Comma Separated Values (CSV)
Now choose the file type. Select Comma Separated Values (CSV) from the list. CSV files are readable by Excel, Google Contacts, and most email platforms. Click Next to continue.
You could also choose “Outlook Data File (.pst)” if you prefer a format only Outlook can read. But CSV is more flexible for sharing and migration.
Step 4: Pick The Contacts Folder
You’ll see a list of folders in your Outlook profile. Find and select the Contacts folder. If you have multiple contact folders (like “Business Contacts” or “Personal Contacts”), choose the one you want to export.
Make sure the checkbox for “Include subfolders” is checked if you want to export all nested contact groups. Then click Next.
Step 5: Save The File
Click Browse to choose where to save your exported file. Pick a location you’ll remember, like your Desktop or Documents folder. Give the file a clear name, such as “Outlook_Contacts_Backup.csv.”
Click Finish to start the export. Outlook will process your contacts and create the file. The time depends on how many contacts you have.
Step 6: Map Custom Fields (Optional)
Before finishing, Outlook may show a “Map Custom Fields” screen. This lets you match your contact fields (like “First Name” or “Email”) to the CSV columns. Usually, the default mapping works fine.
If you have custom fields, you can drag them to match. Click OK when done, then Finish.
Exporting To Outlook Data File (PST)
Sometimes you want a complete backup including all contact details, notes, and categories. A PST file is perfect for this. Here’s how to do it.
Steps For PST Export
Follow steps 1 and 2 from above. In step 3, instead of CSV, choose Outlook Data File (.pst). Then select your Contacts folder and save location.
You can also add a password to protect the PST file. This is useful if the file contains sensitive contact information. Click Finish to complete the export.
PST files can only be imported back into Outlook. They are not readable by other programs like Excel or Gmail. Use PST for personal backups only.
Exporting From Outlook Web App (OWA)
If you use Outlook on the web (like with a work or school account), the process is different. You cannot use the desktop wizard. Instead, you export directly from the browser.
Steps For OWA Export
Log in to your Outlook web account. Click the People icon (or Contacts) in the navigation pane. On the toolbar, click Manage and then Export contacts.
Outlook will download a CSV file containing all your contacts. The file is automatically saved to your default download folder. This method is quick and requires no extra software.
Note that OWA exports only the contacts in your default contacts folder. Subfolders are not included. For full backup, use the desktop version.
Exporting To Google Contacts
Many people switch from Outlook to Gmail. You can export your Outlook address book and import it into Google Contacts. This is a two-step process.
Step 1: Export From Outlook As CSV
Follow the CSV export method described earlier. Save the file to your computer. Make sure it’s in CSV format, not PST.
Step 2: Import Into Google Contacts
Open Google Contacts in your browser. Click Import on the left sidebar. Choose the CSV file you exported from Outlook. Google will map the fields automatically.
Check for any missing data after import. Sometimes custom fields don’t transfer perfectly. You can edit contacts manually if needed.
Exporting From Outlook For Mac
Outlook for Mac has a slightly different interface. The steps are still simple. Here’s how to export your address book on a Mac.
Steps For Mac Export
Open Outlook for Mac. Go to the File menu and select Export. Choose Contacts to a list (CSV) or Outlook for Mac Data File (.olm).
CSV is best for sharing. OLM is for backup only. Select the contacts you want to export or choose “All Contacts.” Click Export and save the file.
Note that Mac exports do not include all custom fields sometimes. Test the file by opening it in Excel to verify data.
Common Issues And Fixes
Exporting is usually smooth, but problems can occur. Here are common issues and how to solve them.
Export Option Grayed Out
If the Import/Export option is grayed out, your Outlook profile might be corrupted. Try restarting Outlook or creating a new profile. Also check if you have the correct permissions on a work account.
CSV File Not Opening In Excel
CSV files sometimes open with garbled text. This is often a encoding issue. Open Excel first, then use Data > From Text/CSV and choose UTF-8 encoding. This fixes most formatting problems.
Missing Contacts After Export
If some contacts are missing, you may have multiple contact folders. Repeat the export for each folder. Also check if contacts are in a subfolder that wasn’t included.
Alternative Methods For Exporting
Besides the built-in wizard, there are other ways to export your address book. These can be faster for specific needs.
Using PowerShell
For advanced users, PowerShell scripts can export contacts automatically. This is useful for IT admins managing many mailboxes. The script exports to CSV or XML format.
You need Exchange Online or local Exchange access. This method is not recommended for casual users.
Using Third-Party Tools
Several third-party tools can export Outlook contacts. They often support more formats like VCF (vCard) or direct transfer to cloud services. Examples include SysTools and Stellar.
Be cautious with free tools. Some may contain malware or steal your data. Always download from reputable sources.
Best Practices For Contact Backup
Exporting once is good, but regular backups are better. Here are some tips to keep your contacts safe.
- Export your address book every month if you add contacts frequently.
- Store the CSV file in a secure cloud location like OneDrive or Google Drive.
- Keep a local copy on an external hard drive for offline access.
- Use a password-protected PST file for sensitive contacts.
- Test your backup by importing it into a dummy account.
Frequently Asked Questions
Can I Export Only Selected Contacts From Outlook?
Yes. Before starting the export, create a new folder and copy the contacts you want. Then export only that folder. Alternatively, use the “Filter” option in the Map Custom Fields step.
What Is The Difference Between CSV And PST Export?
CSV is a plain text format readable by many programs. PST is a proprietary Outlook format that preserves all details but can only be used in Outlook. Choose CSV for sharing, PST for backup.
How Do I Export Outlook Contacts To An IPhone?
Export your contacts as CSV, then import them into iCloud or Google Contacts. Sync your iPhone with that service. You can also use the Outlook app for iOS which syncs directly.
Why Does My Exported CSV File Show Numbers As Dates?
Excel sometimes misinterprets long numbers (like phone numbers) as dates. To fix this, open the CSV in a text editor first, or format the column as text in Excel before importing.
Can I Export Contacts From Outlook Without Using The Wizard?
Yes. You can copy contacts directly from the Contacts folder and paste them into Excel. However, this method may lose formatting and is not recommended for large lists.
Final Thoughts
Now you know how to export outlook address book using multiple methods. Whether you need a quick CSV backup or a full PST archive, the steps are clear. Regular exports protect your valuable contact data.
Start by exporting your contacts today. It takes only a few minutes and gives you peace of mind. If you run into issues, refer back to this guide for troubleshooting tips.
Remember to test your exported file by opening it in Excel or importing it into another service. This ensures your data is complete and accurate. Happy exporting!