Best Way to Export Outlook Contacts as CSV or PST

For most people, the best way to export Outlook contacts is to save them as a CSV file: it is easy to open in Excel and can be imported into many other contact apps. In classic Outlook for Windows, use the Export wizard; in new Outlook or Outlook on the web, use the People export command. Choose a PST instead if you need an Outlook-specific archive rather than a portable list.

What to Look For

Start with where the contacts need to go. A CSV is generally the most useful format for moving contacts to another email provider, cleaning up a list in Excel, or keeping a readable backup. A PST is better for preserving Outlook data in a format intended to be opened in Outlook. A vCard is handy when you need to share one or a few contact cards, but it is not the simplest choice for a large list.

Compatibility: Check the destination’s supported formats before exporting. Many services accept CSV or vCard, but their required column names and import steps differ.
Completeness: Decide whether you need names and email addresses only, or also phone numbers, addresses, notes, custom fields, and multiple contact folders. Test a small export if important details must survive.
Correct source folder: Outlook may show personal folders, shared folders, and address lists. The export wizard usually exports a selected Contacts folder, not every name you can look up in the company directory.
Portability versus Outlook fidelity: CSV is easy to reuse but can flatten or omit Outlook-specific details. PST keeps Outlook data in Outlook’s own file format, but other apps usually cannot use it directly.
Scale and repeatability: For a one-time export, the built-in command is usually enough. If you expect to move contacts regularly, syncing the same Microsoft account may be simpler than repeatedly exporting files.
Privacy and safety: A contacts file can contain personal phone numbers and addresses. Save it somewhere access-controlled, and remove extra columns you do not need before sharing it.

Keep the original contacts in Outlook until you have checked the exported file and, if appropriate, imported it successfully. Exporting normally creates a copy; it does not remove contacts from Outlook. Still, check the destination for duplicates before importing, especially if it already contains some of the same people.

Option 1: Export a CSV from Classic Outlook for Windows

Best for: A general-purpose contacts file for Excel, another email service, or a backup you can inspect. This is the top pick when classic Outlook for Windows is where the contacts are stored and broad compatibility matters.

In classic Outlook for Microsoft 365 on Windows, go to File > Open & Export > Import/Export. Select Export to a file, choose Comma Separated Values, then select the Contacts folder you want to export. Choose where to save the file and finish the wizard. If Outlook offers a field-mapping screen, review it when you rely on less-common fields or custom contact data.

Do not assume that selecting one Contacts folder includes every other folder. If you have separate folders for clients, family, or an older account, export each one separately and label the resulting files clearly. The wizard may also let you include subfolders; use that only if you intend to include them. Afterward, open the CSV in Excel and check a few records, including one with several phone numbers or a non-English name.

Strengths: CSV is simple to inspect, filter, and edit. It is accepted by many contact services and avoids tying the backup to Outlook’s archive format. The wizard also gives you a chance to map fields, which can help when a destination expects particular columns.

Trade-offs: A CSV is a table, not a full Outlook contact card. Some custom fields, formatting, photos, categories, or relationships between records may not transfer as you expect. Opening and resaving a CSV in a spreadsheet can also change how dates, leading zeros, or special characters are interpreted. Keep an untouched copy of the original export, and use the destination’s import preview if it has one.

Classic Outlook’s Import/Export wizard is not the same as a file command in new Outlook. If your Windows app has the newer interface, use the next option instead.

Option 2: Export contacts from New Outlook or Outlook on the web

Best for: People whose contacts are available in a Microsoft account and who use new Outlook for Windows, Outlook on the web, or Outlook.com. This is usually the simplest route when the classic desktop wizard is not present.

Open People, then choose Manage contacts > Export contacts. Select the contacts or folder offered by the page, and choose Export. Outlook downloads a CSV file. The precise labels and available folder choices can vary with the account and interface, but the export is performed from People rather than the Mail view.

Before exporting, make sure you are signed in to the account that actually holds the contacts. A work or school account may show its own contacts, while a personal Outlook.com account has a separate contact list. If you use more than one account, verify the account name and open People to check that the expected names appear before you download anything.

Strengths: It is quick, needs no desktop export wizard, and produces a CSV that is easy to move or review. It is also a practical option from a Mac browser when the contacts are cloud-based: sign in to Outlook on the web and use the same People export command.

Trade-offs: This exports contacts available in that account, not necessarily local-only contacts in a desktop data file, a shared mailbox, or every address shown in an organization’s directory. Check the downloaded file before relying on it. Outlook for Mac’s menus and capabilities depend on whether you use new Outlook or legacy Outlook, so do not expect the Windows Import/Export path to match; for cloud-synced contacts, the web route is often the clearest.

Option 3: Save a PST archive in Classic Outlook for Windows

Best for: Keeping contacts for later use in Outlook, or archiving them alongside other Outlook information. Choose PST when Outlook compatibility matters more than being able to edit the data in a generic spreadsheet.

In classic Outlook for Windows, go to File > Open & Export > Import/Export, choose Export to a file, and select Outlook Data File (.pst). Select the Contacts folder you want, choose a save location, and complete the wizard. Review the folder selection carefully; if you choose a higher-level folder and include subfolders, the PST can contain more than just contacts. Store the file somewhere secure and make a second copy if it is an important archive.

Strengths: PST is designed for Outlook data and can be a useful way to retain contact information for an Outlook-based move or archive. It can preserve more of Outlook’s structure than a flat CSV, depending on what you select.

Trade-offs: A PST is not a universal contacts file. Most non-Outlook apps cannot import it directly, and it is less convenient to inspect or edit. It is also not the same as a cloud backup: a file saved on one computer can be lost if that device or drive fails. If the goal is to move contacts to Gmail, Apple Contacts, or a spreadsheet, CSV or vCard is usually a better starting point.

On legacy Outlook for Mac, the comparable archive format is OLM, not PST. Outlook for Mac versions that offer it use File > Export and let you select items such as Contacts for an Outlook for Mac Data File (.olm). OLM is intended for Outlook for Mac use and is not a general-purpose replacement for CSV. The exact export choices depend on the Mac Outlook version.

Option 4: Save individual contacts as vCards

Best for: Sharing a contact with someone or moving a small number of contact cards to a phone or address book that accepts VCF files. A vCard, usually a .vcf file, is designed to represent a contact card rather than a whole spreadsheet of contacts.

In classic Outlook for Windows, open the contact and use File > Save As, then choose a vCard file type if it is offered. Save each contact as its own VCF file. Menu availability can differ by Outlook version, so if you do not see that file type, check the version’s contact-card options or use the destination service’s supported export route.

Strengths: VCF files are convenient to attach to a message or import into many phone and contacts apps. They are a good fit when a recipient needs a single person’s details, not your entire address book.

Trade-offs: Saving contacts one at a time is tedious for a large list, and support for particular fields can vary between apps. Before sending a vCard, inspect which details it contains and share it only with the intended recipient. For hundreds of contacts, use a bulk CSV export instead and convert formats only if the destination requires it.

Option 5: Sync the account instead of exporting a file

Best for: Moving to a new device or using the same Microsoft-hosted contacts in another Outlook installation. If the contacts are stored in Outlook.com, Microsoft 365, or Exchange and the new device can use that account, signing in and allowing contacts to sync may avoid a manual file transfer.

Add the same account to the destination app and enable its contacts sync option, if available. The exact setting is in the destination app or device, not a universal Outlook export menu. Then compare a few records on both sides and confirm that new contacts appear where you expect. Do not delete the source account until you have verified the destination.

Strengths: Sync can keep contacts current across devices and avoids juggling a file each time you make a change. It is often the most convenient choice for someone staying within Microsoft 365 or Outlook.com.

Trade-offs: Sync is not a standalone backup and may not give you a file you can hand to another service. It will not necessarily include contacts stored only in a local Outlook data file, and enabling sync in multiple apps can create duplicates or competing edits. If your goal is a one-time migration, export a separate CSV as a fallback.

How to Choose

For a no-cost, broadly usable file, choose CSV. Use classic Outlook’s wizard if you have classic Outlook for Windows; use People’s export command in new Outlook or on the web. CSV is the sensible default for importing into a different provider, reviewing in Excel, or keeping a list that is not locked to Outlook. Check the destination’s instructions first, since it may require particular columns or a specific encoding.

For an Outlook archive, choose PST on Windows or OLM on supported legacy Mac versions. These formats make sense when the next step is reopening the data in the corresponding Outlook environment. They are not the best choice for a contact list you need to share with a non-Outlook app.

For one person, choose vCard; for ongoing access, consider sync. VCF avoids sending an entire address book when you only need to share one contact. Account sync is convenient when the contacts are already stored in the cloud and you want them on another device, but it does not replace an offline backup.

Budget is rarely the deciding factor because the built-in export and sync options are generally part of the Outlook account or app you already use. The more important trade-off is portability versus preservation: CSV travels well but may lose specialized fields; PST or OLM is more Outlook-oriented; sync is convenient but depends on account access and network availability. When in doubt, export a CSV, retain the original, and test-import a few contacts before moving the complete list.

Frequently Asked Questions

Does exporting contacts delete them from Outlook?
No. The normal export commands create a separate file and leave the original contacts in place. Confirm that the file exists and contains the right records before making any changes to the source.

Should I choose CSV or PST?
Choose CSV for Excel or a different contacts service. Choose PST when you want an Outlook data archive for classic Outlook on Windows. PST is not generally accepted as an import format by other contact apps.

Can I export all Outlook contacts at once?
Usually, you can export the contacts in a selected folder or account in one operation. If your contacts are split across folders, you may need to export each folder separately. Directory entries, shared contacts, or local-only data may not be included in the same export.

Can I export Outlook contacts on a Mac?
For cloud contacts, sign in to Outlook on the web and use People > Manage contacts > Export contacts. Mac desktop export features vary by Outlook version; legacy Outlook for Mac may offer an OLM archive through File > Export, while the classic Windows CSV wizard is not the Mac menu path.

Why are some contact details missing from my exported CSV?
CSV does not preserve every Outlook-specific detail, and the selected folder or field mapping may affect what appears. Check the export’s columns, review any mapping screen, and compare a contact with several fields before importing the whole file.

Bottom Line

For the best balance of compatibility and ease, export Outlook contacts as CSV: use the Import/Export wizard in classic Outlook for Windows or the People export command in new Outlook and Outlook on the web. Choose PST or OLM only when you need an Outlook-oriented archive, use vCard for a small number of shareable contacts, and rely on sync when your aim is ongoing access across devices. Keep an untouched copy and verify the result before you depend on it.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.