Outlook Contacts Exporter: CSV, PST, and vCard Export Explained

Export Outlook Contacts Easily: Top Tips & Troubleshooting

Exporting your Outlook contacts lets you back up important information, migrate to another account, or share contacts with colleagues. This article gives concise, practical steps for the most common export methods, top tips to avoid problems, and quick troubleshooting for issues that commonly arise.

Which export method to choose

• CSV (recommended) — Best for importing into other email services, spreadsheets, or CRM tools. Simple, widely supported.
• vCard (VCF) — Ideal for individual contact transfers to phones or macOS. Exports one contact per vCard (or multiple in a single VCF depending on method).
• PST (Outlook Data File) — Use when preserving complete Outlook structure (folders, notes, categories) and moving between Outlook profiles or PCs.

How to export contacts (Outlook for Windows)

1. File → Open & Export → Import/Export.
2. Choose Export to a file → Next.
3. Select Comma Separated Values (CSV) or Outlook Data File (.pst) → Next.
4. Pick your Contacts folder (expand your mailbox if needed) → Next.
5. Browse to choose a save location and filename → Finish.
6. For CSV: map custom fields if you want specific columns → OK. For PST: you can set an optional password (usually unnecessary for backups).

How to export contacts (Outlook for Mac)

1. Open Outlook → People.
2. Select the contacts you want (or Cmd+A for all).
3. File → Export.
4. Choose Contacts to a list (TXT) or Contacts to a vCard file → Continue.
5. Save to a location. For TXT, open in Excel and save as CSV if needed.

How to export contacts (Outlook.com / web)

1. Go to Outlook.com → People.
2. Click Manage → Export contacts.
3. Choose the contacts set (e.g., All contacts) → Export to download a CSV.

Top tips before exporting

• Backup first: Export a PST or CSV as a snapshot before making bulk edits or imports.
• Clean duplicates: Run Outlook’s duplicate cleanup or use a contact-cleaning tool to avoid multiple entries.
• Standardize fields: Ensure names, phone numbers, and emails use consistent formats to make importing smoother.
• Map fields on import: When importing CSV into another system, match column headers to destination fields.
• Keep encoding in mind: Use UTF-8 when exporting CSV if you have non-English characters.

Common troubleshooting

• Problem: CSV imports show fields in wrong columns.
  Fix: Open the CSV in Excel, check column headers, and during import to the destination choose “first row contains headers” and map fields manually.

• Problem: Exported vCard contains only one contact or misses fields.
  Fix: Export multiple vCards by selecting multiple contacts first; for missing fields, check whether the data exists in Outlook’s contact fields or in custom fields that vCard doesn’t support.

• Problem: PST export fails or hangs.
  Fix: Compact your mailbox (File → Account Settings → Data Files → Settings → Compact) and retry. Ensure Outlook isn’t syncing or running large add-ins during export.

• Problem: Non-English characters appear garbled in CSV.
  Fix: Save/export CSV with UTF-8 encoding. If Outlook doesn’t offer encoding options, open the TXT/CSV in Excel and re-save using “UTF-8” from the Save As → Tools/Options (or use a text editor that supports UTF-8).

• Problem: Contacts missing after import.
  Fix: Verify the target folder and view filters (e.g., “All contacts” vs. a specific folder). Check for hidden or archived folders and ensure the import completed without errors.

Quick steps to import exported CSV into another Outlook profile

1. File → Open & Export → Import/Export → Import from another program or file → Comma Separated Values.
2. Choose the CSV file, pick how to handle duplicates, and map custom fields if necessary.
3. Finish and verify in the Contacts/People view.

Fast-check checklist (before and after)

• Before: Backup current contacts, clean duplicates, standardize formats.
• After: Confirm import location, spot-check 10–20 contacts, fix mismatched fields, and re-run dedupe if needed.

If you want, I can provide: a ready-to-use CSV header template for Outlook contacts, step-by-step screenshots for your Outlook version, or commands for bulk-cleansing duplicates—tell me which one.