Excel turns barcodes and long IDs into 8.71E+12 — how to keep them intact

Why EAN codes, order numbers and IBAN-like values break in Excel and how to prevent it.

The message you see
Numbers show as 8.71E+12 in Excel
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Convert CSV to Excel safely →

Why this happens

How to fix it

  1. 1Import via Data → From Text/CSV and set the column type to Text.
  2. 2Never save the CSV again after Excel converted it — digits lost after 15 can't be recovered.
  3. 3Convert the CSV to XLSX with text preserved, then work in that file.

Related guides

Still stuck? Ask SheetFix Support