Export Outlook Contacts to Excel: Steps and Options

Yes. You can export Outlook contacts to a comma-separated values (CSV) file and open that file in Excel; in classic Outlook for Windows, use File > Open & Export > Import/Export, while the newer Outlook and Outlook on the web offer an export option in People. CSV is a data-transfer format, not an Excel workbook, so you can save the opened file as an .xlsx workbook if you want Excel features such as multiple sheets and formatting.

What Outlook exports and what Excel opens

Outlook’s contact export is usually a CSV file: a plain-text table in which fields such as name, email address, company, and phone number are separated by commas. Excel can display and edit that table, but the CSV itself does not preserve Excel formatting, formulas, multiple worksheets, or Outlook’s full contact-card experience. Think of CSV as a portable snapshot of contact fields rather than a complete Outlook backup.

One contact generally becomes one row, with different details in separate columns. For example, a row might contain a first name, last name, business email, mobile phone, and company. A contact with several email addresses or phone numbers may have multiple corresponding columns. The exact columns depend on the contact data and export method.

Exporting is useful for making a list, sorting or filtering contacts, preparing a mailing list, or moving data to another service. It does not automatically keep the spreadsheet synchronized with Outlook. If a contact changes after the export, the CSV and workbook will not update unless you export again.

Export contacts from classic Outlook for Windows

These steps apply to classic Outlook for Windows in Microsoft 365. The Import/Export wizard is not available in every Outlook version, so first check whether your app is labeled classic Outlook rather than new Outlook.

Open Outlook and select File > Open & Export > Import/Export.
Choose Export to a file, then select Next.
Choose Comma Separated Values, then select Next.
Select the Contacts folder for the account you want to export. If the relevant contacts are in a different contact folder, select that folder instead. Use Include subfolders if you also want subfolders included and the option is available.
Select Next, choose a file name and location, and continue through the wizard. If offered, Map Custom Fields lets you review which Outlook fields will be written to the CSV.
Select Finish to create the file. If Outlook asks about replacing an existing file, check that you chose the intended destination before confirming.

For example, if you have separate personal and work contact folders, exporting the work folder produces a file for that folder rather than automatically combining every contact in Outlook. Check the folder selection carefully: it is an easy way to avoid exporting the wrong set or overlooking a second folder.

Export from new Outlook or Outlook on the web

In new Outlook for Windows and Outlook on the web, open People, then look for Manage contacts > Export contacts. Choose the contact folder or scope offered in the export dialog, start the export, and locate the downloaded CSV file on your computer. Menu labels and available choices can vary slightly as Microsoft updates the interface.

This path is often convenient when your contacts belong to a Microsoft 365 or Outlook.com account and are available through the web service. If you use more than one account, confirm that you are viewing the account whose contacts you intend to export. A download containing no contacts can simply mean you opened People for a different account or chose an empty folder.

New Outlook and classic Outlook are different applications, and the classic Import/Export wizard instructions should not be assumed to apply to new Outlook. If you cannot find Manage contacts or Export contacts, check that you are in People and that the account supports contact export. You can also try Outlook on the web for that account. On Outlook for Mac, the desktop app’s File > Export is generally used for an Outlook data archive such as an .olm file; for a CSV, use Outlook on the web if the contacts are available there.

Open the CSV safely in Excel

For a quick look, open Excel and use File > Open to select the downloaded CSV. You can also open a CSV from File Explorer, but importing it gives you more control over how Excel interprets the columns. In Excel for Microsoft 365 on Windows, choose Data > From Text/CSV, select the file, inspect the preview, and choose Load. This route is especially helpful if some fields contain leading zeros or values that Excel might interpret as dates or numbers.

A phone number such as 01234 567890 is text, not a quantity to calculate. If Excel treats a phone field as a number, it may remove a leading zero; date-like text can also be interpreted as a date. In the import preview, check the relevant column’s data type and set it to Text when preserving the original characters matters. If you have already opened the file and Excel changed values, return to the original CSV and import it again with the appropriate data type rather than saving the altered version over your source.

After checking the rows and columns, save an Excel copy using File > Save As and select Excel Workbook (.xlsx). Keep the original CSV if you may need a clean source for another import. Excel for Mac also opens CSV files and can save a workbook as .xlsx, though the import controls and dialog layout can differ from Windows. Excel for the web can open uploaded CSV files, but for careful control over data types, use the desktop app when available.

Choose the right fields and check the result

Outlook contacts can contain much more than a name and email address: addresses, job titles, company names, websites, notes, and several phone numbers may all be present. A CSV export turns the selected fields into columns, which is useful for analysis but can make a wide worksheet. In classic Outlook, Map Custom Fields can help you inspect or adjust field mappings before completing the export. The newer export interface may provide fewer mapping controls.

Before using the spreadsheet for a mailing or sharing it with someone, review it for missing or unexpected data. Look for blank columns, unusual characters in names, duplicate-looking records, and contacts that did not appear. A sample check against a few contact cards is worthwhile when the list is important. Also check whether Outlook contact groups or distribution lists were represented as expected: a group is not always equivalent to a normal individual contact row, and its members may need separate handling.

If you only need a basic list, you may not need every field. You can remove unnecessary columns in the workbook after saving a copy of the original export. Keep any column headings that a receiving system requires, however; renaming or deleting them can affect a later import into a customer-management tool or another address book.

Common export problems and fixes

The export option is missing. Confirm whether you are using classic Outlook, new Outlook, or Outlook on the web. The classic wizard path is specific to classic Outlook for Windows; use People and its contact-management options in the newer interfaces.
The CSV is empty or incomplete. Check the selected account and contact folder, and consider whether contacts are stored in another folder. Contacts in a company directory or Global Address List are not necessarily personal contacts in your Contacts folder, and access or export options for directory entries can differ.
Phone numbers lose zeros or change appearance. Import the CSV through Data > From Text/CSV and set phone-number columns to Text. This preserves characters that should not be treated as numeric values.
Characters look wrong. Reopen the original CSV through Excel’s import route and review the file preview and text encoding options if shown. Avoid repeatedly saving a corrupted-looking copy, since that can make the original text harder to recover.
Some fields are absent. Review the export’s field mapping where available and check whether the data exists on the Outlook contact card. Not every contact property is guaranteed to transfer to every CSV-based destination.
There are unexpected duplicate rows. Check whether contacts exist in multiple folders or accounts, and whether you exported a folder plus subfolders. Do not delete records automatically until you have verified that the entries are genuinely duplicates.

Privacy, sharing, and keeping a backup

Contact files can contain personal information about other people, including work details, home addresses, and notes. Save the CSV or workbook somewhere appropriate, avoid placing it in a public or shared folder unintentionally, and share only the fields the recipient needs. If you use a work account, your organization may have policies governing exports and storage; follow those policies before moving contacts to a personal device or third-party service.

A CSV is readable as plain text and is not protected merely because it was created by Outlook. If the file contains sensitive information, use storage and sharing controls appropriate to that information. Consider deleting temporary downloads when they are no longer needed, especially on a shared computer. For a durable Excel copy, retain the .xlsx file in a controlled location and keep the CSV separately only if you need the original export for recovery or transfer.

CSV export compared with other options

CSV is usually the most straightforward choice when the goal is to work with contacts as rows and columns in Excel. It is widely supported and easy to inspect, but it is not a full-fidelity Outlook backup and does not keep the workbook synchronized. An Outlook data archive, such as an .olm file in Outlook for Mac, serves a different purpose: it is intended for Outlook data storage or migration, not as a ready-to-edit spreadsheet.

Copying and pasting contacts or using a third-party connector may suit a small, specialized task, but those methods can omit fields or introduce privacy and access concerns. For a one-time spreadsheet, use Outlook’s built-in CSV export where available. For ongoing updates, investigate an approved synchronization or contact-management solution rather than treating repeated manual exports as a live connection.

Frequently Asked Questions

Can I export Outlook contacts directly to an Excel file?
Outlook’s usual export creates a CSV, not an .xlsx workbook. Open the CSV in Excel, check the data, and use File > Save As to create an Excel Workbook (.xlsx).

Where is the export option in new Outlook?
Open People and look under Manage contacts for Export contacts. Choose the appropriate folder or scope in the dialog. If the option is not present, verify the account and try Outlook on the web.

Will the Excel file update when I change an Outlook contact?
No. A CSV export is a snapshot, not a live link. Export the contacts again when you need a newer copy, or use a separate, approved synchronization method for ongoing updates.

Why did Excel remove the first zero from a phone number?
Excel may interpret the value as a number and discard the leading zero. Import the CSV using Data > From Text/CSV and set the phone-number column to Text before loading it.

Can I export only one Outlook contact folder?
Yes. In classic Outlook, select the specific Contacts folder in the export wizard. In new Outlook or Outlook on the web, select the folder or export scope offered by the contact export dialog.

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.