BRIEF

Exporting Outlook Contacts to Excel Takes Two Minutes, Then Excel Rewrites Your Phone Numbers

Outlook saves your contacts as a CSV file, and Excel opens that file. The export is the easy part. The real risk is double-clicking the CSV, because Excel can quietly strip leading zeros and turn long phone numbers into scientific notation.

WHAT THIS ADDSExcel causes more damage than Outlook does. Opening the export by double-click and then saving it permanently rewrites ZIP codes and international phone numbers, so the safe move is to import the CSV with the columns set to Text. Skip Excel entirely if the file is headed for a CRM.

The menu path depends on which Outlook you have

No version of Outlook exports straight to an .xlsx file. Every version gives you a CSV (comma-separated values) file, and Excel opens that. Older Outlook releases had an Excel option, but it was removed years ago. If a guide tells you to pick "Microsoft Excel" from the export list and you can't find it, the guide is out of date.

What you click depends on which Outlook you're running. Most people don't know which one they have, so here is the quick way to tell. If the app has a File tab at the top left, it's classic Outlook for Windows. If it looks like a web page, with icons down the left edge, it's the new Outlook or Outlook.com. If you're on a Mac, it's Outlook for Mac.

Outlook versionWhere to clickWhat you get
Classic Outlook for WindowsFile > Open & Export > Import/Export > Export to a file > Comma Separated Values > select the Contacts folder > FinishOne .csv file for the folder you chose
New Outlook for Windows, Outlook.com, Outlook on the webPeople icon on the left > Manage contacts > Export contacts > All contacts or one folder > ExportA .csv file in your Downloads folder
Outlook for MacNo CSV export. Its Export option only makes an .olm archive, which Excel can't readSign in to Outlook on the web with the same account and export from there

In classic Outlook, if you keep contacts in more than one folder ("Contacts" plus a "Suppliers" subfolder, say), you have to run the export once per folder. The export doesn't pick up subfolders.

The Mac workaround only works if your contacts sync to a Microsoft account, meaning Microsoft 365, Outlook.com, or Exchange. If they live only "On My Computer", they never reach the web, and the web export won't include them.

Why you should never double-click the CSV

Double-clicking the file opens it in Excel with every column set to "General". In that format, Excel decides for itself what looks like a number. It then changes those cells in ways that become permanent the moment you press Save.

What Outlook exportedWhat Excel shows after a double-clickWhy
ZIP code 021342134Leading zero dropped, because a number can't start with 0
ZIP code 070307030Same. This hits most of New England and New Jersey
Phone +4477009001234.47701E+11The + is read as a plus sign, and anything over 11 digits shows in scientific notation
Account or ID number with 16+ digitsLast digits become 0Excel only stores 15 significant digits
Name JoséJoséThe file is UTF-8 but Excel guessed a different text encoding

Phone numbers typed as "(555) 010-0199" usually come through fine, because the brackets and dash make Excel treat them as text. The ones at risk are numbers someone typed as bare digits, or with only a leading +. Those are often your overseas clients, the ones you can least afford to lose.

The fix is to import the file instead of opening it, and set every column to Text. Then Excel leaves the values exactly as Outlook wrote them. In current Microsoft 365 versions you can also switch the conversions off: File > Options > Data > Automatic Data Conversion, then untick the options for leading zeros and long numbers. That setting only affects files you open after you change it.

1Open a blankworkbookDon't double-clickthe CSV itself2Data > FromText/CSVSelect the fileOutlook exported3Set File Origin to65001: Unicode(UTF-8)Fixes names likeJosé in the preview4Transform Data,select allcolumns, set typeKeeps leading zerosand long numbersintact5Close & LoadSave as .xlsx, andkeep the originalCSV untouched
Opening an Outlook contacts CSV in Excel without losing digits

The clients who won't be in the file at all

The export only includes saved contacts. Many owners assume everyone they've emailed is in there, and they're wrong. In classic Outlook, the person whose name pops up when you start typing is usually in the autocomplete list, not in Contacts. Autocomplete isn't part of the export.

Here's a simple check. Pick five clients you emailed this month, then search the spreadsheet for them. If two are missing, you have a list problem, not an export problem. Before you export, open recent emails and add the missing senders as contacts (right-click their name > Add to Outlook contacts).

Contact groups are the other gap. A group you use to email "all current clients" won't come out as a tidy list of members. Before you rely on the export, confirm that each person in the group also exists as an individual contact.

Also expect a wide file. Classic Outlook writes dozens of columns (several phone fields, three addresses, spouse, birthday) and most of them will be empty. Delete the empty columns after importing, not before. Then you can still see which phone field each number actually landed in.

If the spreadsheet is a stop on the way to a CRM, skip Excel

Many people only want Excel because they're moving to something else, like a booking tool, an invoicing app, or a CRM. In that case, opening the file in Excel adds a step that can only damage it. Upload the original CSV straight into the new system's contact import, and map the columns there. Keep an untouched copy of the CSV as your backup.

Most CRMs, Fynl included, take a CSV import directly. So the Outlook export is the whole job, and you'll check the result in the new system rather than in a spreadsheet. Before you cancel anything, read what a contact export leaves behind. Notes, email history, and attachments don't travel in a CSV, from Outlook or from anywhere else.

If you're consolidating several tools at once, the contact file is usually the first thing to move, and the cleanest. If you're weighing whether one platform can replace the rest, what all-in-one business software actually covers sets out where those tools stop.

DO THISExport from the menu that matches your Outlook version, then import the CSV into Excel with every column set to Text instead of double-clicking it. If the file is going into a CRM, upload the untouched CSV there directly.

Questions people also ask

Can Outlook export contacts directly as an Excel .xlsx file?

No. Current versions of Outlook export contacts only as a CSV file. Excel opens CSV files, so you import the CSV into Excel and save it as .xlsx if you want a workbook.

Why did my ZIP codes lose their first zero after exporting from Outlook?

Outlook exported them correctly. Excel dropped the zero when you double-clicked the CSV, because it treated the column as numbers. Re-import the original CSV through Data > From Text/CSV and set the column to Text.

How do I export contacts from Outlook for Mac to Excel?

Outlook for Mac only exports to an .olm archive, which Excel can't read. If your contacts sync to Microsoft 365, Outlook.com, or Exchange, sign in to Outlook on the web and use Manage contacts > Export contacts to get a CSV.

Why are some of my clients missing from the export?

The export includes only saved contacts. People who appear when you type their name in classic Outlook are often in the autocomplete list, not Contacts, so add them as contacts before exporting.

Sources

One portal instead of five subscriptions

CRM, calendar, quotes, invoices, website and email — with the AI running on your own Claude or ChatGPT API key, so there is no markup on it.

See pricingMore posts