Why Does Excel Remove Leading Zeros From CSV?
Excel removes leading zeros because CSV has no data types, so Excel guesses that a value such as 00123 is the number 123.
Import the column explicitly as text or convert the CSV to an XLSX workbook that stores those cells as text. Once a file has been saved after zeros were removed, return to the original export because the CSV no longer contains enough information to restore them reliably.
Open the CSV to Excel ConverterCSV stores text, not spreadsheet types
A CSV contains characters separated into fields. It does not label a column as text, date, currency, or identifier.
When Excel opens the file directly, it applies automatic type detection. That can remove leading zeros, shorten long numbers, or reinterpret date-like codes.
Identifiers are not quantities
Postal codes, SKU values, account references, and telephone fragments may contain only digits but are not numbers for calculation. Their formatting is part of the identifier.
Storing those cells as text in XLSX prevents automatic numeric conversion and keeps the original characters visible.
What cannot be recovered
If Excel turned 00123 into 123 and the file was then saved, the number of missing zeros is unknown without an external rule. Different rows may require different lengths.
Use the untouched CSV export or regenerate it from the source system rather than guessing.
How to fix it safely
- Start with the untouched CSV export.
- Preview the identifier column and confirm its zeros are present.
- Convert the CSV to XLSX with values stored as text.
- Open the XLSX and verify a few long IDs and zero-prefixed codes.