How to open a CSV in Excel without changing anything

Most CSV damage happens in the first second: you double-click the file, Excel opens it, and it has already decided what every column means. Dates get reformatted, leading zeros disappear, long numbers become E+, and gene names like SEPT1 turn into dates. If you then save, the original text is gone.

Why double-clicking is the problem

A CSV has no formatting and no types. It is only text. When Excel opens it directly, it applies automatic type detection to each cell. That is convenient for a quick look and destructive for anything that is an identifier rather than a quantity.

Method 1: Excel, Data ▸ From Text/CSV

1. Open a blank workbook. Don't open the CSV itself.
2. Go to Data ▸ From Text/CSV and select the file.
3. In the preview, check File Origin (choose 65001: Unicode (UTF-8) if accented letters look wrong) and Delimiter.
4. Set Data Type Detection to Do not detect data types. All columns come in as text.
5. Click Load.

The result is a table where 00123, 03/04/2026 and 4006381333931 look exactly as they do in the file. If you only need one column kept as text, click its header in the preview and change its type to Text instead.

Older Excel versions use the wizard: Data ▸ Get External Data ▸ From Text. On step 3, select each column and set its format to Text. In newer versions that wizard is hidden by default but can be switched on under File ▸ Options ▸ Data ▸ Show legacy data import wizards.

Method 2: Google Sheets

Use File ▸ Import ▸ Upload, and untick Convert text to numbers, dates, and formulas. That keeps values as written.

Saving is a second trap

Even after a clean import, saving as CSV writes out the cells as they look, and double-clicking that CSV again re-triggers detection. A text-formatted column survives inside the workbook but not the next double-click on the CSV. If you plan to reopen the CSV in Excel, use the import route every time.

What a browser tool can and can't do here

CSV Fixer doesn't replace Excel and doesn't produce an Excel file. It reads your CSV as raw text, so it never converts anything, and its preview shows the values exactly as stored. That makes it a safe place to inspect a file, fix specific problems, and download a cleaned CSV. It can't change how Excel behaves when you open that CSV afterward; for that, use Method 1.

A quick check that nothing was converted

After loading, click a few cells that were at risk: an ID with leading zeros, a long barcode, a date. In text columns the values are left-aligned by default, while numbers are right-aligned. A column you expected to be text that sits against the right edge of its cells was converted to numbers. Another useful test is to compare the row count and a few random values against the file opened in Notepad.

If you need numbers for calculations afterward, convert only the columns that really are quantities: select the column, then use Data ▸ Text to Columns ▸ Finish, which re-evaluates the cells as numbers.

← Back to the CSV Fixer tool