Why Does Excel Remove Leading Zeros From CSV?

CSV cannot declare a text column

A CSV field contains characters and separators; it does not carry an Excel cell type or number format. When a .csv file is opened directly, Excel applies automatic data conversion. Microsoft documents that this can remove leading zeros, convert E-containing identifiers to scientific notation, interpret date-like strings, and retain only 15 significant digits in long numbers.

The conversion is reasonable for quantities but destructive for identifiers. 00123 and 123 can identify different products even though they are the same numeric value. Treat postal codes, account numbers, membership IDs, and similar digit strings as text at import time.

Use an import flow with explicit types

In current desktop Excel versions, use Data → From Text/CSV, choose Transform Data, select the identifier columns, and set their type to Text before loading. Microsoft also provides Automatic Data Conversions options in supported versions, including a setting that prevents removal of leading zeros.

For repeat work, Power Query records those type choices and can refresh the same export consistently. Opening the file by double-clicking gives you less control because default formats are applied immediately.

Use XLSX when types are part of the deliverable

An XLSX workbook can store a cell as text, so the type travels with the value. The CSV to Excel converter writes CSV values as text and avoids inventing formulas or date types. Verify identifiers, dates, and long numbers after conversion, then share the XLSX when the recipient needs spreadsheet types.

A custom number format such as 00000 only changes display and assumes a fixed length. It cannot know how many zeros were lost from previously converted values, and it does not solve identifiers with varying lengths.

Know what is recoverable

If 00123 became 123 but the untouched CSV still exists, the information is recoverable by importing correctly. If the converted workbook or CSV was saved over the source, the number of missing zeros is unknown unless an external rule defines the exact length.

Long numeric strings have an additional risk: Microsoft states that Excel numeric precision is limited to 15 significant digits. Digits beyond that can become zeros, which formatting cannot restore. Compare a few source identifiers character-for-character before trusting the result.

How to fix it safely

1. Return to the untouched CSV and confirm the zeros and all long digits are still present in a text preview.
2. Use Excel's From Text/CSV flow and set identifier columns to Text before loading, or open CSV to Excel Converter.
3. Save as XLSX when the recipient needs the text type preserved with the cells.
4. Compare representative postal codes, SKUs, E-containing IDs, dates, and 16-plus-digit values with the source.