CSV to Excel Fixer: Open CSV Files Correctly
Open a CSV file and get one Excel opens right with a double click: umlauts and accents intact, one value per column, zip codes with their zero, long numbers in full, dates as dates. Free, in your browser, nothing uploaded.
Your CSV File
The fixer needs JavaScript. How to import a CSV into Excel by hand is explained below.
Why Excel Breaks Your CSV
A CSV file has no settings inside it. Excel guesses the encoding, the separator and every value’s type from your computer’s language, and on a double click you can’t correct the guess.
That is why “Müller” turns into “Müller”, a whole row lands in column A, 01067 becomes 1067 and an account number ends as 4.00638E+12. The fixer makes those choices for Excel before it opens the file.
What the fixer repairs
- Encoding: UTF-8, UTF-8 BOM or Windows-1252 found, saved as UTF-8 with BOM
- Accents: Zoë becomes Zoë again
- Separator: comma for English Excel, semicolon for German
- Zeros and long numbers: 02134 and 4006381333931 stay as they are
- Dates and decimals: the way your Excel reads them
Try a Broken File
Each loads a typical broken export into the fixer. Download the result and open it with a double click.
- Example
Accents Read the Wrong Way
A UTF-8 export opened as Windows text: every accent became two odd characters. The bytes are all still there, so the fixer can put them back.
- 2bytes per accent in UTF-8
- 1character after the repair
- 0files uploaded
- Separator
Semicolons in English Excel
A file from a German system: every row ends up in column A.
- Leading zeros
Zip Codes Lost Their Zero
Excel reads 02134 as the number 2134. The fixer keeps it as text.
- Long numbers
4.00638E+12 Instead of an ID
Excel keeps 15 digits and shows long numbers in scientific notation.
- Dates
Day and Month Swapped
14/03/2026 can only be day first. The fixer reads the whole column that way.
Three Ways to Open a CSV in Excel
What each way does with the problems above.
| Double click | Data › From Text/CSV | This fixer, then double click | |
|---|---|---|---|
| Umlauts and accents | Excel guesses the encoding | You pick File Origin 65001: UTF-8 | Repaired, saved as UTF-8 with BOM |
| Separator | Your system’s list separator | You pick the delimiter | Set for your Excel |
| Leading zeros, long numbers | Lost | Kept if you set the column to Text | Kept |
| Dates | Guessed per cell | Guessed by type detection | Rewritten for your Excel |
| Effort each time | None | Six to eight clicks | Download, double click |
Data › Get Data › From File › From Text/CSV is the import in Excel for Microsoft 365 and Excel 2016 or later. Excel for Microsoft 365 can also switch off some automatic conversions: File › Options › Data › Automatic data conversion.
Import a CSV the Manual Way
When you have to do it inside Excel, for example with a file you can’t download again.
- 1
Open an Empty Workbook
Don’t double-click the CSV. Start Excel with a blank workbook.
- 2
Data › From Text/CSV
Under Data › Get Data › From File, pick the CSV file.
- 3
Set Origin and Delimiter
File Origin 65001: Unicode (UTF-8), the delimiter your file uses, and Data Type Detection: Do not detect data types.
- 4
Load
Excel loads every column as text. Change only the columns you need as numbers or dates.
CSV Files for Salesforce and Pardot
The file Excel shows well and the file an import reads well aren’t always the same.
- 15Digits Excel keeps of any number
- 50,000Records per Data Import Wizard run
- 18Characters in a case-safe Salesforce ID
- Keep the original for imports. The fixed file is for reading in Excel. For an import into Salesforce or Account Engagement (Pardot), start from the export itself or save from Excel as CSV UTF-8, so the ="…" text cells don’t go along.
- Data Import Wizard. Imports up to 50,000 records at a time, per Salesforce Trailhead; above that Salesforce points to Data Loader.
- Salesforce IDs in Excel. Excel’s lookups ignore case, so 15-character IDs can clash. Convert them to 18 characters before you match lists.
- Pardot imports. Pardot matches imported prospects by email or by CRM ID. Check both columns survived Excel before you upload.
CSV to Excel FAQ
Short answers to what people ask about opening CSV files in Excel.
Why does Excel show strange characters instead of umlauts?
The file is UTF-8 and Excel read it as Windows text, so each umlaut or accent shows as two characters, such as ü for ü. Save the file as UTF-8 with a byte order mark, which this fixer does, or import it with File Origin 65001: UTF-8.
Why is everything in one column?
The file uses a different separator than your Excel expects: German Excel expects semicolons, English Excel commas. The fixer writes the one your Excel uses.
How do I keep leading zeros in Excel?
Excel turns 01067 into the number 1067. The fixer writes such cells as ="01067", which Excel shows as the text 01067. In Excel itself, import the column as Text.
Why does Excel turn long numbers into 4.00638E+12?
Excel stores numbers with 15 significant digits and shows long ones in scientific notation. Digits after the 15th become zeros. The fixer keeps numbers of 12 digits or more as text, so every digit stays.
Can I import the fixed file into Salesforce or Pardot?
Use it for reading in Excel. For an import, use the original export or save from Excel as CSV UTF-8, so no ="…" cells go into your data.
Is my file uploaded?
No. The file is read and fixed in your browser and the new file is made there too. Nothing is sent or stored, and nothing from the file reaches analytics.
More Free Tools
We Make Salesforce Marketing Work for You
Talk to a certified consultant, not a salesperson, and leave the first call knowing your next step.