Keep leading zeros when converting CSV to Excel
A CSV file stores text separated by delimiters. It does not store Excel cell types. When a spreadsheet application opens it, the application may interpret 00123 as the number 123. That is a problem when the value is a postcode, product code or account identifier rather than a quantity.
Use text for identifiers
In Excel, import a CSV through its data import workflow and set identifier columns to Text before loading them. Simply double-clicking a CSV may allow automatic type conversion.
Tech Tycoon’s CSV-to-Excel export writes values as text cells. A source value such as 00123 remains text in the generated XLSX worksheet. Numbers intended for calculations may need to be converted to numeric cells in Excel afterward.
What cannot be recovered
If an earlier application already changed 00123 into 123 and saved the file, the original width may be lost. Adding zeros without knowing the intended format can create incorrect identifiers. The tool does not guess missing zeros.
Check before using an import
- Keep the original source file.
- Check several identifiers in the downloaded result.
- Confirm that the receiving application interprets identifiers as text.
- Test a small import before replacing a full dataset.