Runs in your browser

CSV Scientific Notation Tool

Expand identifier-like values and warn when precision is already gone.

Your files never leave your device.

Drop a CSV with scientific notation

CSV, TSV, or text. Processed locally — the file is never uploaded.

Try a sample:

What Excel does to long identifiers

Excel stores numbers as IEEE-754 doubles, about 15 significant digits. A 16-digit order ID or barcode is rounded on entry. When the sheet is saved as CSV, you may get 1.23457E+15 instead of the identifier.

What this tool will and will not do

It scans identifier-like columns and cells that match scientific notation. When the mantissa still has enough digits, it writes the expanded integer. When the mantissa is short relative to the exponent — typical of Excel\u2019s display form — it still expands, then warns that exact recovery is impossible.

Example

order_id
1.25E+3
1.23E+15

Output:

order_id
1250
1230000000000000

The second row is flagged: those trailing zeros are not the original ID.

Limitations

This is not cryptography and not interpolation. If precision is gone, the honest result is a warning, not a guessed barcode. Amounts that legitimately use scientific notation in scientific datasets should be excluded from the column list.

FAQ

Can you recover a 16-digit ID from 1.23E+15?

No. Only three significant digits remain. Any expansion adds zeros and is flagged as precision lost. Restore the ID from a system that still has it.

What about 1.25000E+03?

That expands to 1250 with no warning, because the mantissa still contains the integer.

Why quote the download?

So spreadsheet apps do not convert the expanded integer back into scientific notation on the next open.

Related tools