How to Open a CSV in Excel Without Breaking It

Updated July 2026 · By the CSVUndo team · 7 min read

The quick answer: don’t double-click the file. Double-clicking makes Excel guess the type of every cell, and its guesses quietly destroy data — a 12-digit barcode collapses to 8.85909E+11, 00501 loses its zeros, a part number like MAR1 flips to 1-Mar, and accented text turns to é garbage. The safe route is to open a blank workbook and pull the file in through Data → From Text/CSV, declaring every identifier column as Text before the data loads. If a file is already damaged, the table below routes you to the exact fix.

Already opened it? Find your damage below

If you already double-clicked and something looks wrong, most of these problems have a clean fix — and some, honestly, do not. Match the symptom to the row below. The rule that decides recoverability: if Excel only reformatted a value the digits are still there, but if it truncated or overwrote them on save, they must come from the original export.

Why double-clicking a CSV breaks your data

Double-clicking hands the file to Excel with zero instructions, so Excel guesses the data type of every single cell — and those guesses are tuned for spreadsheets, not for your identifiers. A CSV is plain text; it has no way to say “this column is codes, not quantities,” so Excel applies four damaging assumptions in one pass:

• Long numbers → scientific notation. Anything past 12 digits, like a UPC or account number, is shown as 8.85909E+11, and because Excel stores numbers with only about 15 significant digits, values longer than that are rounded and lose their tail permanently.
• Leading zeros deleted. A ZIP code 00501 becomes 501 because, read as a number, the zeros have no meaning.
• Text that looks like a date → a date. MAR1 becomes 1-Mar and the fraction 1/2 becomes 2-Jan; the original text is gone the instant Excel parses it.
• Wrong encoding → broken characters. A UTF-8 file read as Windows-1252 turns café into café.

All four share one root cause — Excel guessing instead of being told — which is why the single import method below prevents every one of them at once.

The safe way: import with column types declared

Open a blank workbook first — never the file itself — then import through Data → From Text/CSV and tell Excel which columns are text. This is the only path where you override Excel’s guesses before they happen rather than trying to undo them afterwards.

1. Start Excel and open a blank workbook. Do not double-click the CSV.
2. Go to Data → From Text/CSV and pick your file.
3. If the data has accents, set File Origin to “65001: Unicode (UTF-8)” so characters load correctly.
4. Click Transform Data. In the editor, select each identifier column — barcodes, SKUs, ZIP codes, phone numbers, IDs — and set its Data Type = Text.
5. Click Close & Load. The data lands in the sheet with every code intact.

Older Excel: the Text Import Wizard

If your version has no From Text/CSV button, use the legacy path: Data → Get External Data → From Text, which opens the classic Text Import Wizard. It reaches the same result through a slightly different route. In Step 1 choose Delimited; in Step 2 tick the correct delimiter (usually comma); and in Step 3, click each identifier column in the preview and set its Column data format to Text before finishing. Microsoft documents both the modern and legacy paths in its import and export text files reference.

Stop the silent conversions for good (Microsoft 365)

On Microsoft 365 you can disable the worst conversions globally so even a careless open does less harm. Go to File → Options → Data → Automatic Data Conversion and switch off converting long numbers to scientific notation and removing leading zeros. Be honest about its limits, though: Excel 2019 and earlier do not have these switches at all, and even on 365 the setting protects only future opens — it cannot undo damage already saved into a file. For anything that matters, the import method above is still the reliable choice.

Habits that keep CSVs safe

The single best habit is to treat the CSV as a delivery format, not a working file. A few small routines prevent almost every disaster before it starts:

1. Keep an untouched copy of the original export. If an import goes wrong you can always start again from clean data.
2. Do your editing in .xlsx, where column types are stored, and generate the CSV only as the very last step.
3. Avoid re-saving the CSV from Excel unless you have to — every save bakes Excel’s current display into the file, notation and all.
4. Import, never double-click when the file holds codes, long numbers, dates or accents.

When damage has already been written to disk, don’t fight it inside Excel — repair the raw file first. Our free browser tools handle the three most common cases: expanding scientific notation back to full digits, re-padding leading zeros to a fixed width, and reversing broken characters. Each guide for a specific symptom is collected in the full guides index.

Frequently asked questions

Source: Microsoft’s Import or export text (.txt or .csv) files documents the From Text/CSV import and the legacy Text Import Wizard. The 15-significant-digit limit is a property of IEEE 754 double-precision floating point used by Excel.