Export Outlook Contacts: Steps, Formats, and Tips

To export Microsoft Outlook contacts, open the People or Contacts area and use its export command to save a CSV file; in classic Outlook for Windows, go to File > Open & Export > Import/Export and choose Export to a file. The exact steps depend on which Outlook version you use, but the result is usually a copy of your contact details that you can open in Excel or import into another service.

What an Outlook contacts export contains

An export creates a file containing contact information such as names, email addresses, phone numbers, company details, and addresses. The fields included depend on the export method and the information stored in the contacts. A CSV file (comma-separated values) is a table of text fields, not an Outlook mailbox or a live connection to your account.

That distinction matters: exporting is useful for transferring or reviewing contacts, but it does not keep two address books synchronized. If you edit a contact in Outlook after exporting, the saved file will not update automatically. Similarly, changes made to a CSV or to contacts in another service will not flow back into Outlook unless you import them separately.

Outlook may show contacts from more than one place, including a Microsoft 365 or Exchange account, an Outlook.com account, or a contacts folder stored locally. Before exporting, check that you are working in the account and folder that contain the people you need. An export from one folder is not necessarily a complete copy of every contact visible in Outlook.

Choose the right export method

Start by identifying the Outlook app you have open. Microsoft offers classic Outlook for Windows, the newer Outlook for Windows, Outlook on the web, and Outlook for Mac. Their menus are not identical, so instructions for one version may not match another. The app name or a switch for trying the new Outlook can help distinguish the Windows versions.

Classic Outlook for Windows: Use the Import/Export wizard to create a CSV file. This is a familiar option for moving contacts into spreadsheets or other services.
New Outlook for Windows or Outlook on the web: Use the People area and its contact-management export option, where available, to download contacts as a CSV file.
Outlook for Mac: In Legacy Outlook, the export command creates an Outlook for Mac data file (.olm), rather than the same CSV workflow used by classic Outlook for Windows.

If the directions below do not match your menus, check the app version before assuming that a feature is missing. Work or school accounts can also be affected by administrator settings, and Microsoft sometimes changes or rolls out interface options over time.

Export contacts from classic Outlook for Windows

In classic Outlook for Microsoft 365 on Windows, the Import/Export wizard is the standard route to a CSV file. Follow these steps:

Open Outlook and select File > Open & Export > Import/Export.
In the wizard, select Export to a file, then choose Next.
Select Comma Separated Values and choose Next.
Choose the Contacts folder you want to export. If several accounts or contact folders appear, select the one that holds the contacts you need.
Choose a destination and filename for the CSV file, then continue through the wizard and select Finish.

The wizard can offer a field-mapping step. Use it if you need to check which Outlook fields correspond to the columns in the output, or if you want to include a particular field. Field names may not match the labels used by the service receiving the file, so review the mapping rather than assuming that every custom field will transfer exactly as displayed.

If your goal is to export only a subset, one practical approach is to put those contacts in a dedicated contact folder first, then select that folder in the wizard. Take care not to move contacts if you only intend to make a copy; confirm that your selection and folder changes are appropriate before exporting.

Export from new Outlook or Outlook on the web

In new Outlook for Windows or Outlook on the web, open People (the contacts area). Look for Manage contacts, then choose Export contacts. If prompted, select the contacts folder or group of contacts to export and start the download. Outlook saves the result as a CSV file, usually in the browser or Windows download location.

The labels and placement of these controls can vary with the interface and account. If you do not see an export option, confirm that you are in People rather than Mail, check that you have opened the intended account, and look for the same function in the contact-management menu. For a managed work or school account, your organization may limit available features; ask its Microsoft 365 administrator if the option remains unavailable.

After the download, use your browser’s download list or File Explorer to locate the CSV. Avoid repeatedly exporting without checking the destination: a browser may save a second file with a changed name, such as a number added to the filename, rather than replacing the first one.

CSV, Excel, and other file formats

CSV is useful because many programs accept it, and Excel can open it as a table. It is still plain text: it does not preserve Outlook’s full interface, contact-card layout, or all account behavior. Contact photos, for example, are image files rather than ordinary text fields, so a CSV should not be treated as a photo archive. Some specialized details or custom fields may also need checking after transfer.

To inspect the file, open Excel and use File > Open to select the CSV, or open it from File Explorer if Excel is the default application. Review columns such as phone numbers, postal codes, and email addresses. Spreadsheet programs can interpret values when opening a text file, and a number that begins with zero may not display as expected if it is treated as numeric data. If you need to preserve the original export unchanged, keep a copy of the downloaded CSV before editing it.

Saving a separate working copy as an Excel workbook can be helpful for sorting or reviewing, but an .xlsx file is not a universal contact-import format. For a transfer, keep the CSV if the receiving service requests CSV, and follow that service’s import instructions. Apple-oriented address books often use vCard files, while Outlook for Mac’s Legacy export produces an .olm archive intended for Outlook for Mac data—not a general-purpose spreadsheet.

Check the export before importing it elsewhere

Do not assume a successful download means that every intended contact is present and usable. Open the file and compare it with the source folder. Check the number of rows, a few names from different parts of the list, and important fields such as email addresses and phone numbers. A quick review can reveal that you exported the wrong account or selected a smaller folder than intended.

For example, imagine exporting 250 work contacts to move them into a customer-management service. Before importing, check that the CSV has the expected contact rows and that the columns for first name, last name, and email are distinct and populated. If the destination’s importer asks you to match fields, map each column deliberately. A column called “E-mail Address” may need to be assigned to the destination’s “Email” field.

If you are importing into another application, use a small test when the service allows it. Import a few records or use a duplicate-detection preview, then confirm the names and fields before bringing in the full list. Importing the same CSV more than once can create duplicate contacts, depending on the destination’s matching rules.

Common export problems and practical fixes

The Contacts folder is missing: Check whether you opened the correct account and whether its contact folder is visible in People. A different account may hold the contacts you are looking for.
The CSV is empty or has fewer contacts than expected: Verify the selected folder, then check whether some entries are stored in another account, folder, or contact list. Exporting a folder does not automatically combine every address book.
Names or characters look wrong: Try opening the CSV through Excel’s import workflow rather than editing the original file immediately. Confirm the file’s text encoding and inspect how the receiving application reads it.
Phone numbers or postal codes change: These values can be interpreted as numbers by spreadsheet software. Keep the raw CSV as a backup, and use text handling when importing or reviewing values that need to retain leading zeros or punctuation.
Custom fields are absent or misplaced: Review field mapping in classic Outlook and check the destination’s supported fields. Not every application accepts every Outlook-specific field.
A distribution list does not appear as expected: A mailing list or group is not necessarily represented in a CSV as a set of ordinary individual contact rows. Check the list separately and confirm whether the destination supports importing groups.

When a mismatch is important, do not delete the original Outlook contacts just because a file was created. Correct the export or import first, and verify the destination. That is especially worthwhile for a work address book that would be difficult to rebuild manually.

Privacy, security, and backup limits

A contacts file can contain personal information, including private email addresses, phone numbers, and home or business addresses. Store it somewhere access-controlled, avoid sending it through an untrusted channel, and remove extra copies when they are no longer needed. A CSV is readable as plain text, so it is not protected merely because it came from Outlook.

An export can serve as a useful snapshot, but it is not a complete Outlook backup. It does not preserve the full mailbox, messages, calendar, or necessarily every contact detail and relationship. For a migration or record-keeping task, decide whether you need only a portable list of contacts or a broader Outlook data archive, then choose the appropriate method. Keep the original account available until you have verified the copy and can access it in the destination.

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 text-table format, not an Excel workbook, so save a separate .xlsx copy if you need Excel features. Check phone numbers and postal codes for changes after opening.

Can I export only selected Outlook contacts?
The available selection options depend on the Outlook version. Some export screens let you choose a folder or contact group rather than individual records. In classic Outlook, selecting a dedicated Contacts folder in the export wizard is one way to export a subset; avoid changing your main folder unintentionally.

Does exporting contacts delete them from Outlook?
No. Exporting creates a separate file and does not, by itself, remove the contacts from Outlook. Keep in mind that the exported file is a snapshot, so later edits in Outlook are not automatically reflected in it.

Can I export Outlook contacts on a Mac?
Outlook for Mac differs from Outlook for Windows. Legacy Outlook for Mac has a Tools > Export option for an Outlook for Mac data file (.olm), which is not the same as a Windows CSV export. If you specifically need CSV, check the export options in the web version or use a supported contact service or workflow for your account.

Why are some Outlook contacts missing from my export?
First check that you selected the right account and Contacts folder. Contacts can be split across accounts or folders, and a folder export may not include other locations. Also review whether the missing item is a distribution list or group rather than an individual contact record.

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.