To export contacts from Outlook on the web, open People, choose Manage contacts > Export contacts, select the contacts or folder to export, and click Export. Outlook downloads a CSV file that you can keep as a backup or import into another contacts app.
Where Outlook Web Stores Contacts
Outlook’s People area is the web interface for contacts. Depending on your account and the current layout, you may find it in the left navigation or under the app launcher. Once there, look for Manage contacts and its export option. The labels can vary slightly as Microsoft updates the interface, but the export is performed from People rather than from an email message or the general Outlook settings.
The contacts you can export are the personal contacts saved to the account you are signed in to. This is different from names in your organization’s address list, such as coworkers shown by your company’s global address list. Those directory entries are managed by the organization and are not necessarily stored as your personal contacts, so they may not appear in the export. If you have more than one Microsoft account, check the account profile before starting; exporting from a personal Outlook.com account will not export contacts belonging to a separate work or school account.
Step-by-Step Export Instructions
- Sign in to Outlook on the web with the account that contains the contacts.
- Open People. If the navigation is collapsed, expand it or use the app launcher to locate People.
- Choose Manage contacts, then select Export contacts.
- In the export dialog, choose All contacts or select the contact folder you want. The available choices depend on the folders in the account.
- Click Export. When the browser prompts you or completes the download, find the CSV file in your usual Downloads location.
The downloaded file is usually named something like contacts.csv, though the exact name can vary. If nothing seems to happen, check the browser’s downloads indicator and its download history before repeating the export. A browser setting may be asking where to save the file, or may block downloads from the page. Exporting copies the contact information into a file; it does not remove the contacts from Outlook.
Choosing All Contacts or a Folder
Choose All contacts when you want a broad backup or are moving your address book to another service. Choose an individual folder when you only need a subset—for example, a project folder you plan to share with an approved work system, or a group of personal contacts you are moving to a separate account. If the export window offers folders, check the selection carefully before clicking Export; an export of one folder is not the same as an export of every contact.
Folders help organize contacts, but they do not necessarily represent separate accounts. Before relying on a folder-only export as a complete backup, compare its contents with the full People view. For a migration, exporting all contacts is often the safer starting point, followed by reviewing the CSV and removing records you do not want to transfer. Avoid exporting more personal information than the destination actually needs.
What the CSV File Contains
CSV means comma-separated values. It is a plain-text table format, not a Microsoft Excel workbook. Outlook writes contact fields into rows and columns; depending on the records, these can include names, email addresses, phone numbers, addresses, company details, and other contact properties. A field that is blank for a person may appear as an empty cell. The exact columns can differ as contact records and export formats change.
A CSV export is useful for moving basic contact data, but it is not a complete archive of everything in Outlook. It does not contain email messages or calendar items, and it should not be treated as a backup of an entire mailbox. Some Outlook-specific organization or information may not map neatly to another service. For example, a destination app may interpret custom fields differently or may not preserve the same folder structure. If a particular field or contact group is important, inspect the exported file and check the destination’s import documentation rather than assuming it will transfer unchanged.
Opening the File Without Damaging Contact Data
You can inspect a CSV in Excel, but opening it by double-clicking may cause Excel to interpret some values automatically. Phone numbers with leading zeroes, long numeric strings, and date-like text are common trouble spots: software may reformat them even though the original CSV contains the intended value. Keep an untouched copy of the downloaded file before making edits.
In Excel for Microsoft 365 on Windows, a more controlled way to inspect it is to open Excel and choose Data > From Text/CSV, then select the downloaded file. Review the preview and the data types before loading it. If you only need a quick look, open the CSV in a plain-text editor instead. On a Mac, Excel also supports importing text or CSV files through its Data import tools, though the exact menu labels can differ by version. For a simple transfer, it is usually best not to edit the CSV at all: give the original file to the destination service’s import feature.
Common Export Problems and Fixes
- People or Export contacts is missing: Confirm that you are in Outlook’s People area and signed in to the account that owns the contacts. A company directory is not the same as your saved personal contacts. Your organization may also limit some account features.
- The download does not appear: Check the browser’s downloads list, the default Downloads folder, and any prompt asking you to choose a location. If downloads are blocked, allow the download for Outlook and try again.
- The CSV looks empty or incomplete: Reopen the export dialog and confirm that you chose the intended folder or all contacts. Also check whether the missing entries are actually personal contacts in this account, rather than directory results or contacts in another account.
- Names or characters look wrong: Try importing the CSV through a spreadsheet program’s text/CSV import option rather than opening it directly. This can help preserve character encoding and lets you inspect how the columns are interpreted.
- There are duplicates after importing: The destination may have matched records imperfectly or may have imported contacts that were already there. Review its duplicate-handling options and, where possible, test with a small sample before importing the full file.
If the export option is available but produces an error, refresh Outlook and try again in a supported, up-to-date browser. For a work or school account, contact your organization’s IT support if access appears restricted; an administrator may control account capabilities or policies.
Privacy, Backups, and Safe Handling
A contact CSV can contain personal details about you and other people. Store it somewhere access-controlled, especially if it includes home addresses or private phone numbers. Avoid placing it in a public folder or sending it as an unprotected attachment when a more secure transfer method is available. If you use a shared computer, remove the downloaded file when you no longer need it and empty the recycle bin or trash if appropriate.
For backup purposes, keep the original export separate from any edited copy. A CSV is convenient because many services can read it, but it is not a live connection: changes you make later in Outlook will not update a previously exported file. If you want a current backup, export again periodically and label files with the date, such as outlook-contacts-2026-11-03.csv. Treat the file as sensitive even if it is easy to open in a spreadsheet.
Exporting Compared with Other Options
Exporting to CSV is generally the simplest choice when you need a portable copy or want to move contacts between services. It is readable by many contact managers and spreadsheet programs, but it may require field mapping during import. If you only need one person’s details, opening that contact and copying the relevant information may be more practical than exporting an entire folder. If you need to move contacts to another Microsoft account, CSV is still a common route, but verify the destination account before importing so you do not add the records to the wrong profile.
Export is also different from syncing. A synced account can keep contacts updated between supported apps, whereas a CSV is a snapshot taken at the time of download. Choose export when you need a file, a one-time migration, or a dated backup. Choose a supported account connection when you specifically need ongoing synchronization, and review the permissions before granting another service access to your contacts.
Frequently Asked Questions
Can I export Outlook contacts to Excel?
Outlook Web exports contacts as a CSV file, not as an Excel workbook. Excel can open or import the CSV, and you can save a separate copy as an Excel workbook if you need spreadsheet features.
Can I export only selected contacts?
The export dialog may let you choose all contacts or a contact folder. If it does not offer a way to select individual records, create or use a folder containing the contacts you need, or export the available set and remove unwanted rows from a copy.
Does exporting delete contacts from Outlook?
No. Export creates a downloadable copy and leaves the contacts in the account. Deleting the downloaded file also does not delete the online contacts.
Can I export contacts from Outlook on my phone?
The most direct method is to use Outlook in a web browser and open People. Mobile layouts and apps may not show the same export controls, so use a desktop browser if you cannot find Manage contacts or Export contacts.
Can I import the CSV into another email service?
Many contact services accept CSV files, but their required columns and field mapping differ. Use the destination’s contacts import tool, review its preview, and test with a small file or a copy before importing a large address book.
Related
- Excel Time Difference Between Two Dates and Times Explained
- Power Query Get Current Year: M Code and Refresh Tips
- Power Query Data Types: Choosing, Changing, and Fixing Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Protect Sheet: Allow Filtering and Sorting SafelyYes. In Excel for Microsoft 365 on Windows, turn on the filter for your data before protecting the…
- Google Sheets Project Tracker: Setup and Best PracticesA Google Sheets project tracker is a shared spreadsheet for organizing tasks, owners, deadlines, priorities, and progress in…
- How to Insert a Line in Word Under Text: Easy MethodsTo put a line under text in Word, select the text and press Ctrl+U on Windows or Command+U…
- Excel Insert Page Breaks: Steps, Options, and FixesTo insert a page break in Excel for Microsoft 365 on Windows, select the row below or column…
- SUMIF Checkbox in Google Sheets: Sum Checked RowsIf your checkboxes are in A2:A20 and the values to add are in B2:B20, use =SUMIF(A2:A20,TRUE,B2:B20) to total…
- Excel Select From a Dropdown List: Steps and Helpful TipsTo select an option from an Excel dropdown list, click the cell, click the small arrow that appears…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.