Open a CSV in Excel Without Breaking It
Accents look garbled or phone numbers turned into 4.47E+11? Learn how to open a CSV in Excel properly, keep phone numbers intact, or just download Excel instead.
4 min read
Want to open a CSV in Excel without accents turning into gibberish or phone numbers turning into 4.47E+11? The file itself is fine. Spreadsheet apps just guess wrong sometimes. This guide shows the quickest fix, the proper way to import a CSV, and how to keep phone numbers exactly as they are.
The Easy Fix: Download Excel Instead
Every list in Lists & Exports can be downloaded as CSV or Excel. If you plan to work in Excel, pick Excel. You skip the import step entirely, and it's the simplest way to avoid encoding problems. If you use the API, add format=xlsx when you download a list.
A CSV is still the better choice when you're uploading to a CRM or an email tool, because most of those read CSV directly. The rest of this guide is for when you need the CSV.
Why a CSV Can Look Wrong
Our CSVs use UTF-8, the standard that handles accented letters, other alphabets and symbols. Names like Müller, François or Søren are stored correctly. When you double-click a CSV, some versions of Excel assume an older encoding, and accented letters show up as strange characters.
Excel also tries to be helpful with anything that looks like a number. A long phone number can become scientific notation, and a leading zero or plus sign can disappear. These changes happen in Excel, not in the file, until you save over the original.
Tip: Keep the original download untouched. If something goes wrong while editing, you can download a fresh copy from Lists & Exports for 180 days.
How to Open a CSV in Excel Properly
Instead of double-clicking, import the file. In recent Excel for Windows and Mac:
- Open a blank workbook.
- Go to the Data tab and choose From Text/CSV.
- Pick your downloaded file.
- In the preview, set File Origin to 65001: Unicode (UTF-8).
- Check the delimiter is Comma.
- Look at the preview. Accented names should now read correctly.
- Click Transform Data to set column types (see the next section), or Load if everything looks right.
Older Excel versions show the Text Import Wizard instead. Choose Delimited, set the file origin to UTF-8, tick Comma, and on the last step set the columns you want to protect to Text.
Keep Phone Numbers Intact
The Phone Number column causes the most trouble. Excel sees a long run of digits and may switch it to scientific notation, drop a leading zero, or remove the plus sign. Tell Excel the column is text before it loads:
- From Text/CSV: click Transform Data, select
Phone Number, change its type to Text, then click Close & Load. - Text Import Wizard: on the last step, select the phone column and choose Text.
Do the same for any phone columns added by Enrich Contacts. Once Excel has converted a number and you've saved the file, the lost digits can't be recovered from that copy, so import again from the original.
Google Sheets and Apple Numbers
Google Sheets reads UTF-8 properly, so it's often the easiest choice.
- Open a new spreadsheet.
- Go to File, then Import, then Upload, and pick your CSV.
- Set the separator to Comma.
- Untick Convert text to numbers, dates, and formulas to keep phone numbers as they are.
- Click Import data.
Sheets has a limit on cells per spreadsheet, so a very large list may be better in Excel. Apple Numbers usually handles UTF-8 fine through File, then Open. Check the phone column and set it to Text if it changed.
Other Things That Look Odd
- Long cells.
Opening Hours,ServicesandAddresscan be long. If one looks cut off, the column is just narrow. Double-click the column edge to widen it. - Commas inside values. A name like "Smith, Jones & Co" is wrapped in quotes in the CSV so it stays in one cell. Importing with the comma delimiter handles this.
- Latitude and Longitude. Excel may show fewer decimal places than the file holds. Widen the column or increase the decimals to see them all.
- Empty cells. A blank means Google Maps didn't show that detail for the business. It's not a display problem. Google Maps Export Fields Explained covers every column.
Saving and Importing Elsewhere
If you need to save a CSV again from Excel, choose CSV UTF-8 so accents survive. When you upload to a CRM, use the original file rather than one you've re-saved from a spreadsheet. Because the columns are the same every time, you can save your field mapping once and reuse it.
More on finding and re-downloading files is in Download Your List as CSV or Excel. If a file still looks wrong after this, contact support with the order number and we'll take a look.
Ready to try it?
Start your export with MapsDaddy. No browser extension, Google account or API key needed.
Related Guides
Still stuck?
Our team usually replies the same day.