Skip to content
ORDO

Leading zeros disappear in Excel

A reference code is not an amount. Automatic spreadsheet typing can drop zeros or round long values. ORDO keeps leading-zero and long identifiers as text during supported conversion.

Convert CSV with identifiers intact

Files stay on your device

Drop your file

CSV, JSON

Files stay on your device

Common import problems

8123456780812345678
Automatic number typing dropped the first zero.
1.05536E+110105536012345
An identifier was treated as a number instead of source text.
12345678901234501234567890123456
Values beyond 15 significant digits can lose precision.

Keep the source value

  • Leading-zero and long identifiers remain text in supported XLSX output.
  • Unambiguous amounts can remain numeric and be summed.
  • Inspect the preview before export; dates and separators may be ambiguous.

When digits were already lost

Return to the original source. A known fixed-width format can sometimes restore leading zeros, but ORDO does not infer the missing digits. A rounded long number cannot be recovered from that damaged copy.

Is my file uploaded?

No. This tool runs inside your browser on this device. ORDO's servers never receive the file, and the page's security policy blocks it from sending file data anywhere.

Privacy

Limits worth knowing

  • Conversion preserves values present in the input; it does not recreate lost data.
  • Text identifiers are deliberately not summable amounts.

Read next

Text looks garbled when I open a CSV