Exporting your Outlook address book creates a backup of your contacts or lets you move them to another email service, spreadsheet, or CRM. This guide covers the built-in export wizard in Outlook for Windows (Microsoft 365, 2021, 2019, and 2016) and shows you how to save your contacts as a CSV file that most programs can open. You’ll need access to Outlook on your computer—the steps differ slightly if you use Outlook on the web.
What You’ll Need
- Outlook for Windows (desktop app) installed and signed in.
- Your contacts already added to the People or Contacts folder.
- Enough disk space for the exported file (usually a few MB).
- Optional: a folder on your PC where you want to save the file.
Step-by-Step
- Open Outlook on your Windows computer.
- Click the File tab in the top-left corner.
- In the left sidebar, click Open & Export.
- Click Import/Export. This launches the Import and Export Wizard.
- Choose Export to a file and click Next.
- Select Comma Separated Values (Windows) as the file type. This creates a .csv file that works with Excel, Google Contacts, and most other apps. Click Next.
- In the folder list, select the Contacts folder (or the specific contact folder you want to export). Make sure the box next to it is checked, then click Next.
- Click Browse to choose where to save the file. Name it something like
OutlookContacts.csvand click OK. - If you want to export only certain fields (like name, email, phone), click Map Custom Fields. Otherwise, leave the default settings and click Finish.
- Outlook will create the file and show a progress bar. When it’s done, click OK.
Common Mistakes
- Choosing the wrong folder – If you have multiple contact folders (e.g., a subfolder under your main Contacts), you might export an empty or partial list. Double-check that the folder you select actually contains the contacts you want.
- Using “Export to a file” vs. “Export to Outlook file” – The wizard offers two export options. “Export to a file” gives you CSV; “Export to Outlook file” creates a .pst that only Outlook can read. Pick the first one unless you specifically need a .pst backup.
- Not checking the “Include subfolders” box – If you have contacts in subfolders, you’ll miss them unless you check that option when selecting the folder.
- Overwriting an existing file – If you save to a filename that already exists, Outlook will ask to replace it. Make sure you’re not accidentally deleting a previous backup.
Tips
- Use custom fields to keep the file clean – When you click “Map Custom Fields,” you can remove columns you don’t need. This makes the CSV easier to read and import elsewhere.
- Export regularly – Make it a habit to export your contacts every few months, especially before switching email providers.
- Check the CSV in Excel – After exporting, open the file in Excel to verify that all contacts are there and that columns look correct. This catches issues before you rely on the file.
- Use a .pst for a full backup – If you want to restore contacts back into Outlook later (including categories and notes), use “Export to Outlook file” (.pst) instead. CSV is better for portability, but it doesn’t preserve everything.
Troubleshooting
The export button is grayed out. This usually means you’re in Outlook on the web, not the desktop app. Open the desktop version, or use the web export method: click the gear icon, search for “export”, and follow the prompts.
The CSV file is empty or missing contacts. Check that you selected the correct folder. Also, if you have contacts stored in a different account (like a Gmail account added to Outlook), you need to export each account’s contact folder separately.
Outlook says “The file already exists” but you want to replace it. Click “Yes” to overwrite, or choose a different filename to keep both.
After importing the CSV into another program, phone numbers are missing. Outlook’s default export may only include the first phone number field. Use “Map Custom Fields” and add the “Home Phone”, “Business Phone”, and “Mobile Phone” fields explicitly.
The Import/Export wizard doesn’t appear. If you’re using a work or school account, your organization may have disabled this feature. Contact your IT admin, or try exporting from Outlook on the web.
Frequently Asked Questions
Can I export contacts from Outlook on the web? Yes. In Outlook on the web, click the gear icon (Settings), search for “Export”, and choose “Export contacts”. It downloads a CSV file automatically.
What if I only want to export a few contacts? You can select specific contacts in the People view, then use the “Export” option from the ribbon (if available) or copy them into a new folder and export that folder. A simpler way is to export all and then delete the extras in the CSV.
Will the CSV include contact photos? No. CSV files only store text data. Photos are not included. Use a .pst export if you need to keep photos.
Can I import the CSV into Google Contacts? Yes. In Google Contacts, go to Import, select the CSV file, and it will map most standard fields. You may need to adjust the mapping for custom fields.
Why does my CSV have a column called “E-mail Address” with a number? Outlook adds a number to duplicate fields (e.g., E-mail Address, E-mail Address 2). That’s normal. You can delete those extra columns if you don’t need them.
Is there a way to export contacts without using the wizard? Yes. In the People view, you can select all contacts (Ctrl+A) and drag them to a folder on your desktop, which creates a .vcf file for each contact. That’s useful for sending individual contacts, but not for a single file.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- How to Assign a Ringtone to a Specific Contact on Android
- How to Send Confetti on iPhone (iMessage Effect)
- Windows 10 New PC Settings Tweaks
- Flutter vs Android Studio: Key Differences
- VPN on Samsung Galaxy: App & Settings Setup
- iPad Location Not Available? Fix It Now