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.
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 version | Where to click | What you get |
|---|---|---|
| Classic Outlook for Windows | File > Open & Export > Import/Export > Export to a file > Comma Separated Values > select the Contacts folder > Finish | One .csv file for the folder you chose |
| New Outlook for Windows, Outlook.com, Outlook on the web | People icon on the left > Manage contacts > Export contacts > All contacts or one folder > Export | A .csv file in your Downloads folder |
| Outlook for Mac | No CSV export. Its Export option only makes an .olm archive, which Excel can't read | Sign 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 exported | What Excel shows after a double-click | Why |
|---|---|---|
| ZIP code 02134 | 2134 | Leading zero dropped, because a number can't start with 0 |
| ZIP code 07030 | 7030 | Same. This hits most of New England and New Jersey |
| Phone +447700900123 | 4.47701E+11 | The + is read as a plus sign, and anything over 11 digits shows in scientific notation |
| Account or ID number with 16+ digits | Last digits become 0 | Excel 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.
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.
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
More on leaving the tool stack
All-in-One Business Management Software Runs Your Clients, Not Your Books
For a small business, "all-in-one" means one system for the client side: inquiries, booking, quotes, contracts
LEAVING THE TOOL STACKWhat an All-in-One Business Platform Really Costs You in Reais
Most all-in-one business platforms bill in US dollars. That means a Brazilian business pays the converted pric
LEAVING THE TOOL STACKGoHighLevel Pricing Starts at $97, but That Is Rarely What a Small Business Pays
GoHighLevel (HighLevel) lists three plans: $97, $297 and $497 a month. Most small businesses pay something els
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