Getting your Outlook contacts out of the application requires knowing exactly which export format works best for your needs. If you have ever wondered how to export contacts from outlook, you are in the right place. This guide covers every method, from the classic desktop version to the web app and even the new Outlook for Windows. You will learn step-by-step instructions, common pitfalls, and the best file types for different situations. Whether you are moving to a new email service, backing up your address book, or sharing contacts with a colleague, this article has you covered.
Exporting contacts from Outlook might sound technical, but it is actually quite simple once you know the steps. The process varies slightly depending on which version of Outlook you use. We will break down each method clearly so you can follow along without any confusion. Let us start with the most common scenario: the classic Outlook desktop application.
Exporting Contacts From Outlook Desktop (Classic Version)
The classic Outlook desktop app (part of Microsoft Office) offers the most control over your export. You can choose exactly which fields to include and what format to use. This method works for Outlook 2010, 2013, 2016, 2019, and Microsoft 365 versions.
Step 1: Open The Import And Export Wizard
First, open Outlook and click on “File” in the top-left corner. Then select “Open & Export” from the menu. Finally, click on “Import/Export” to launch the wizard. This tool handles both importing and exporting data.
Step 2: Choose Export To A File
In the wizard, you will see several options. Select “Export to a file” and click “Next”. This option allows you to save your contacts as a file you can use elsewhere.
Step 3: Select The File Type
Now you need to choose the format. The most common options are:
- Comma Separated Values (CSV): Best for importing into other email services like Gmail or Yahoo. Works with Excel too.
- Outlook Data File (.pst): Ideal for backups or moving to another Outlook installation. Preserves all details including categories and notes.
- Microsoft Excel (.xlsx): Good if you want to edit contacts in a spreadsheet.
For most users, CSV is the safest choice. Select it and click “Next”.
Step 4: Choose The Contacts Folder
You will see a list of folders in your Outlook profile. Select the “Contacts” folder (or whichever folder contains the contacts you want to export). Make sure you pick the right one if you have multiple contact folders. Then click “Next”.
Step 5: Save The File
Click “Browse” to choose where to save the exported file. Give it a descriptive name like “MyOutlookContacts.csv”. Then click “Finish”. Outlook will export your contacts to that location.
That is it for the classic desktop version. But what if you use the new Outlook for Windows? Let us look at that next.
How To Export Contacts From Outlook (New Outlook For Windows)
Microsoft recently released a new version of Outlook for Windows. It looks different and works differently. The export process is simpler but has fewer options. Here is how to do it.
Step 1: Open The Settings Menu
In the new Outlook, click on the gear icon in the top-right corner to open Settings. Then scroll down and click on “General”. Finally, select “Import and Export”.
Step 2: Choose Export Contacts
In the Import and Export section, you will see two options: “Import” and “Export”. Click on “Export”. A new window will appear asking what you want to export.
Step 3: Select Contacts Only
You can choose to export everything (mail, calendar, contacts) or just contacts. Select “Contacts” and click “Export”. The new Outlook will automatically create a CSV file and download it to your computer.
Step 4: Locate The File
Check your Downloads folder. The file will be named something like “contacts.csv”. You can rename it if you want. That is all there is to it. The new Outlook does not let you choose other formats like PST or Excel. You only get CSV.
This method is fast but limited. If you need a PST file, you will have to use the classic Outlook or the web version. Speaking of which, let us cover Outlook on the web.
Exporting Contacts From Outlook On The Web
Outlook on the web (also called Outlook Web App or OWA) is the browser-based version. It is common for work or school accounts. Exporting contacts from here is straightforward.
Step 1: Go To The People Section
Log into your Outlook web account. In the left sidebar, click on the “People” icon (it looks like two silhouettes). This opens your contact list.
Step 2: Open Manage Options
At the top of the contact list, you will see a toolbar. Look for the “Manage” dropdown menu. Click on it and select “Export contacts”.
Step 3: Choose Export All Or A Specific Folder
A dialog box will appear. You can choose to export all contacts or just a specific folder. Select your preference. Then click “Export”.
Step 4: Save The CSV File
The web version exports contacts as a CSV file. Your browser will download it automatically. The file name will be something like “contacts.csv”. You can open it with Excel or import it into another service.
One thing to note: Outlook on the web does not support PST export. If you need a PST file, you must use the desktop version. Now let us talk about a special case: exporting contacts from Outlook.com (the free version).
Exporting Contacts From Outlook.com (Free Email)
Outlook.com is Microsoft’s free email service. It is different from the Office versions. The export process is similar to the web version but with a few extra steps.
Step 1: Go To The People Page
Sign into your Outlook.com account. Click on the grid icon in the top-left corner (the “app launcher”). Then select “People” from the list.
Step 2: Use The Manage Menu
On the People page, look for the “Manage” button near the top. Click it and choose “Export contacts”.
Step 3: Choose Your Export Options
You can export all contacts or a specific folder. Also, you can choose between CSV and vCard formats. CSV is best for importing into other services. vCard is good for individual contacts but not for bulk transfers. Select CSV and click “Export”.
Step 4: Download The File
The file will download to your computer. It will be named “contacts.csv”. You can now use it anywhere.
That covers the free version. But what if you need to export contacts from Outlook to a specific destination like an iPhone or Android phone? Let us cover that next.
Exporting Outlook Contacts To A Mobile Device
If you want your Outlook contacts on your phone, you do not always need to export a file. Syncing is often easier. But if you need a file, here is how to do it.
Option 1: Sync Via Microsoft Account
If you use the same Microsoft account on your phone and Outlook, contacts sync automatically. Just add your account to your phone’s settings. No export needed.
Option 2: Export To CSV And Import To Phone
If syncing is not an option, export your contacts as CSV using one of the methods above. Then transfer the file to your phone. On Android, you can import CSV into the Contacts app. On iPhone, you can use iCloud or a third-party app to import.
Option 3: Use A Third-Party Tool
Some apps specialize in transferring contacts between platforms. Tools like “CopyTrans” or “MobileTrans” can help. They often support direct transfer without intermediate files.
Now let us talk about common problems people face when exporting contacts from Outlook.
Common Export Problems And Solutions
Even with clear steps, things can go wrong. Here are the most frequent issues and how to fix them.
Problem 1: The Export Wizard Does Not Open
Sometimes the Import/Export wizard does not appear. This usually happens because of a corrupted Outlook profile. Try repairing your Office installation or creating a new Outlook profile.
Problem 2: Exported CSV File Is Empty
If your CSV file has no data, you probably selected the wrong folder. Make sure you choose the “Contacts” folder, not “Calendar” or “Tasks”. Also check that your contacts folder actually contains contacts.
Problem 3: Duplicate Contacts In The Export
Outlook sometimes exports duplicate contacts if you have multiple contact folders. Before exporting, use the “Clean Up Duplicates” feature in Outlook. Or manually remove duplicates from the CSV file later.
Problem 4: The Export Takes Too Long
If you have thousands of contacts, the export can take a while. Be patient. If it seems stuck, try exporting in smaller batches. You can create separate contact folders and export each one.
Problem 5: Special Characters Get Corrupted
If your contacts have accented characters or symbols, they might not display correctly in the CSV. To fix this, open the CSV file in a text editor and save it with UTF-8 encoding. This preserves special characters.
These solutions should cover most issues. But if you are still stuck, the FAQ section below might help.
Best Practices For Exporting Outlook Contacts
To make your export smooth and useful, follow these tips.
- Clean your contacts first: Remove duplicates, update outdated information, and delete contacts you no longer need. This makes the exported file cleaner.
- Choose the right format: CSV is the most universal. PST is best for backups. vCard works for individual contacts.
- Test the export: Before deleting your Outlook contacts, import the exported file into a test account to make sure everything transferred correctly.
- Keep a backup: Always keep a copy of your exported file in a safe place. Cloud storage or an external drive works well.
- Check field mapping: When importing into another service, some fields might not map correctly. Review the mapping settings in the destination service.
Following these practices will save you time and headaches later. Now let us look at alternative methods for exporting contacts.
Alternative Methods: Using Third-Party Tools
Sometimes the built-in export options are not enough. Maybe you need to export contacts from multiple accounts at once. Or you want to convert to a specific format. Third-party tools can help.
Tool 1: SysTools Outlook Contact Export
This tool exports contacts from Outlook to various formats including CSV, vCard, and even PDF. It works with all Outlook versions. It is a paid tool but offers a free trial.
Tool 2: Kernel For Outlook Contact Export
Another reliable option. It can export contacts from corrupted PST files too. Supports multiple formats and batch processing.
Tool 3: Free Outlook Contact Exporter
If you need a free solution, this one works. It exports contacts to CSV and vCard. It is simple but effective. Just be careful with free tools from unknown sources.
These tools are useful if you have complex needs. But for most users, the built-in methods are sufficient. Now let us answer some frequently asked questions.
Frequently Asked Questions
Can I export contacts from Outlook to Gmail?
Yes. Export your Outlook contacts as a CSV file. Then log into Gmail, go to Contacts, click “Import”, and upload the CSV file. Gmail will map the fields automatically.
What is the best format to export Outlook contacts?
CSV is the best format for most situations. It works with almost every email service and spreadsheet program. PST is better for backups within the Outlook ecosystem.
How do I export contacts from Outlook to Excel?
Use the Export Wizard in the classic Outlook. Choose “Export to a file”, then select “Microsoft Excel (.xlsx)”. Follow the prompts to save your contacts as an Excel file.
Why is my exported CSV file not opening correctly?
This often happens due to encoding issues. Open the CSV file in a text editor like Notepad. Save it with UTF-8 encoding. Then open it in Excel. This should fix the problem.
Can I export contacts from Outlook without using the wizard?
Yes. You can copy and paste contacts from Outlook to Excel manually. But this is time-consuming for large lists. The wizard is faster and more accurate.
These answers cover the most common questions. If you have a specific issue, leave a comment below.
Conclusion
Exporting contacts from Outlook is a straightforward process once you know which method fits your situation. The classic desktop version offers the most options, including PST and CSV. The new Outlook for Windows and the web version are simpler but limited to CSV. Outlook.com users can export to CSV or vCard. For mobile devices, syncing is usually easier than exporting files. Remember to clean your contacts before exporting and test the file afterward. If you run into problems, the solutions above should help. Now you have all the knowledge you need to export your Outlook contacts successfully. Go ahead and try it yourself.