Outlook Export Contacts: CSV Steps and Common Fixes

To export Outlook contacts, open People and choose Manage contacts > Export contacts in new Outlook or Outlook on the web. In classic Outlook for Windows, use File > Open & Export > Import/Export, then export the Contacts folder as a CSV file. The CSV option is useful for spreadsheets and many other apps, while a full Outlook backup may need a different format.

Choose the right Outlook export method

Outlook has several interfaces, and their export tools are not identical. First identify whether you use classic Outlook for Windows, new Outlook for Windows, Outlook on the web, or Outlook for Mac. In classic Outlook, the export wizard creates a comma-separated values file. In new Outlook and Outlook on the web, the People area provides a direct contacts export. These CSV files are convenient for moving contact details between services or reviewing them in a spreadsheet.

Also consider where your contacts are stored. A work or school account may keep them in a Microsoft Exchange or Microsoft 365 mailbox; a personal Outlook.com account stores them online. Classic Outlook can also show contacts in a local data file or another mailbox. Exporting one folder does not automatically collect contacts from every account displayed in Outlook, so choose the source folder deliberately.

Need a portable list or spreadsheet? Export to CSV.
Moving between Outlook installations on Mac? An Outlook archive may be more suitable than CSV, depending on the Outlook for Mac version.
Want a copy of everything in a mailbox? A contacts CSV is not a full mailbox backup; use an appropriate mailbox archive or account backup method.

Export contacts in classic Outlook for Windows

These steps apply to classic Outlook for Microsoft 365 on Windows. If you do not see the File tab and the traditional ribbon, you may be using new Outlook, whose export steps are different.

Open Outlook and select File > Open & Export > Import/Export.
In the Import and Export Wizard, select Export to a file, then select Next.
Select Comma Separated Values and select Next. If Outlook asks which account or data file to use, choose the one that contains the contacts you need.
Select the Contacts folder under the correct mailbox or data file. If you have multiple contact folders, select the specific one you want. Select Next.
Choose a destination and filename for the exported file. Use a location you can find again, such as Documents, and select Next.
Review the export settings and select Finish. If the wizard offers a field-mapping option, use it when you need to control which Outlook fields appear in the CSV and how they are labeled.

Outlook may ask whether to replace, allow duplicate entries, or avoid exporting duplicates if you repeat an earlier export to the same destination. Read the prompt before continuing. The CSV will not normally update itself when you later change a contact in Outlook; export again to create an updated copy.

Export from new Outlook or Outlook on the web

In new Outlook for Windows, select the People icon to open contacts. Choose Manage contacts > Export contacts, select the contacts folder or scope offered in the dialog, and choose Export. Outlook creates a CSV download. If you use Outlook on the web, open People and look for the same Manage contacts > Export contacts command. The precise layout can vary as Microsoft updates its interface, but the export is performed from People rather than from the Mail view.

When the download finishes, check your browser’s downloads list or the Downloads folder. If the export dialog lets you choose a folder, make sure it is the one associated with the account you intend to copy. A user with personal and work accounts open in the same browser should verify the profile before exporting; otherwise, it is easy to save the wrong set of contacts.

If you do not see the export command, confirm that you are in People and signed in to the account that owns the contacts. Work or school administrators can also restrict account features. In that situation, ask the organization’s Microsoft 365 administrator about the permitted way to export contacts rather than trying to bypass a policy.

Choose the correct folder and check what is included

Outlook can display more than one Contacts folder: for example, a personal mailbox, a shared mailbox, and a local Outlook data file. In classic Outlook, the wizard asks you to select a folder within a particular account or data file. Expand the list if necessary and check the folder name before proceeding. The People view in the newer interfaces likewise lets you select an available contact folder or export scope.

Do not assume that exporting the main Contacts folder includes every address you have ever encountered. Addresses in the message autocomplete list are not necessarily saved as contacts, and email messages in the Inbox are not a contact list. If someone is missing, open a message or search People and save that person as a contact first, then run the export again.

Contact groups and distribution lists are another special case. A group is not the same thing as a set of individual contact records, and a CSV export may not reproduce the group’s membership and behavior as a working Outlook group. If preserving a group matters, check the destination app’s import capabilities and consider recording the group members separately before relying on a CSV transfer.

What a CSV export preserves—and what it does not

CSV stands for comma-separated values. It is a text-based table: rows generally represent contacts, while columns represent fields such as name, email address, phone number, company, or address. Excel can open a CSV for inspection, and many contact services provide a CSV import option. The exact columns depend on Outlook’s export process and the contact fields populated in the source.

A CSV is an interchange format, not a complete copy of Outlook’s contact experience. It may not preserve every Outlook-specific property, formatting detail, photo, category, linked record, or group relationship in a form another program can use. Some fields may appear under unfamiliar column names, and a receiving service may ignore fields it does not support. For an important transfer, export a small sample first and test its import before moving a large address book.

It is usually safer to treat the CSV as a data file rather than a finished spreadsheet. If you open it in Excel and save changes, check that names, phone numbers, postal codes, and other values remain intact. Spreadsheet programs can interpret values such as leading-zero postal codes as numbers, changing their appearance or contents. Keep an untouched copy of the original export before editing.

Common export problems and practical fixes

The Contacts folder looks empty: Check other accounts and data files in Outlook, and confirm you selected the right folder in the wizard. Contacts stored in another mailbox are not necessarily included.
Some people are missing: They may exist only in an email or autocomplete suggestion, not as saved contact records. Save them as contacts and export again.
Names or characters look wrong: Open the file in a compatible application and verify its character encoding. If a receiving service offers a CSV encoding choice, follow that service’s instructions. Avoid resaving the only copy until you have checked the result.
Fields are in unexpected columns: Use the classic wizard’s field-mapping option when available, or inspect the column headings and map them during import. Different programs use different field names.
The file opens as one column: The spreadsheet may be using a different regional list separator. Use the spreadsheet import process and select the delimiter that matches the file, rather than assuming the file is corrupt.
The export command is missing: Confirm which Outlook version you have and open People. If the account is managed by an employer or school, an administrator may control export availability.

Import the file carefully and keep a backup

Before importing the CSV into another service, check the destination’s instructions and whether it can recognize Outlook-style fields. Many contact managers provide an import screen where you can match CSV columns to fields such as first name, last name, and email. Review that mapping instead of accepting defaults automatically, particularly if the file contains separate home, business, and mobile phone columns.

A duplicate check is important when the destination already has contacts. If possible, import a small test file or a small selection first. Compare the resulting names and email addresses, then proceed with the full list. A duplicate created during import can be harder to clean up than a missed field, especially when multiple records share a name.

Keep the original export in a private, secure location until you have confirmed the destination contains the contacts you need. A CSV may expose names, email addresses, phone numbers, and business or home details to anyone who can access the file. Avoid leaving it in a public or shared folder, and delete temporary copies when they are no longer needed. For a recurring backup, set a reminder to export again; a saved CSV is a snapshot, not a live sync.

Outlook for Mac and other alternatives

Outlook for Mac has different export options from classic Outlook for Windows. In versions that provide the Outlook archive workflow, use File > Export and select the categories to include, such as Contacts, to create an Outlook archive file. An OLM archive is designed for Outlook for Mac and is not the same as a CSV that can be opened as a contact table in many apps. Menu availability and archive options can differ between legacy and newer Outlook for Mac releases, so check the commands available in your installed version.

If you specifically need a CSV, use an Outlook interface that offers contact CSV export, such as Outlook on the web, if your account and organization allow it. Another option is to use a destination contact app’s supported export route after syncing the account, but verify which fields and records it will include before relying on that method. Do not assume a Mac archive can be renamed to .csv; changing a filename does not convert the data format.

Frequently Asked Questions

Can I export Outlook contacts to Excel?
Yes. Export the contacts as a CSV file, then open that file in Excel. CSV is a plain-text table rather than an Excel workbook, so use Save As if you need an .xlsx copy, and keep the original CSV in case you need to import it elsewhere.

Where does Outlook save exported contacts?
In classic Outlook for Windows, you choose the file path and name in the export wizard. In new Outlook or Outlook on the web, the CSV is typically downloaded by your browser, so check its downloads list or Downloads folder.

Does exporting contacts delete them from Outlook?
No. Exporting creates a separate file and does not remove the source contacts. Deleting or editing the CSV also does not change the Outlook contact records.

Can I export only selected contacts?
The available scope depends on the Outlook interface and export dialog. If the dialog offers only a folder, you can make a temporary folder containing the records you need, or use a method supported by the destination app. Check the selection before exporting so you do not share the entire address book unintentionally.

Why are my Outlook contacts missing from the CSV?
Common causes are selecting the wrong account or Contacts folder, expecting email autocomplete entries to count as saved contacts, or exporting a group that is not represented as individual records. Find the missing person in People, confirm that the person is saved as a contact in the intended account, and export that folder again.

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.