Shopify Barcodes Showing as 8.85909E+11? Fix Them Here

What this fixes, and what it can't: Turns 8.85909E+11 barcodes back into plain digits. A rebuilt barcode ending in zeros may have lost digits; export it again.

Excel collapsed the Variant Barcode column in your Shopify export. Drop the CSV below to get the column back as plain digits, and see every cell that changed. Some digits may already be gone, and this page tells you how to spot that.

Quick Answer: CSVUndo expands Shopify barcodes that Excel collapsed into scientific notation, so 8.85909E+11 becomes 885909000000 and imports as plain digits. It runs in your browser, so your catalogue is not uploaded. If Excel saved the file, digits it rounded away are gone, and those barcodes must be exported again from your source.

Free. No signup. Your file never leaves this tab. Prove it in 30 seconds →

Drop your Shopify product CSV here or click to choose a file
…or paste the data straight into the box below

Prefer a real file? Download a broken sample: collapsed barcodes. All samples.

Doing this every month? Pick one once. It is remembered on this device, so next month's export only needs dropping in.

Output options (optional)
Output options for the repaired file

🔒 Your file never leaves this browser. Try it: turn Wi-Fi off after this page loads, then repair a file. Prove it in 30 seconds →

How to fix it in four steps

  1. Drop or paste your file. Drop your CSV on the box above, or paste its text into the box. It stays in this tab.
  2. See the damage. Click the button under the box to see what Excel broke, then untick any repair you do not want.
  3. Repair and check. Click Repair & preview. Read the before and after table: each old value is struck through, with the new value beside it.
  4. Download the fixed file. Say where the file is going next, then click Download fixed file. Your original file is not changed.

A worked example

Your export has 8.85909E+11 in Variant Barcode. The tool rewrites that as 885909000000: the 12 digits a UPC needs, with no E+ notation left in the file. The before and after table shows both values, so you can check every cell.

Now look at the end of that number. If the real barcode was 885909457123, the last digits are zeros because Excel saved only six significant digits. The format is right, but the barcode is not the original one.

What this cannot fix

Prevent it next time

  1. Do not double-click the export. Open a blank Excel workbook first.
  2. Use Data → From Text/CSV and set Variant Barcode to Text before loading.
  3. Keep an untouched copy of each export, so a bad save never costs you the original digits.

More help

Other columns broken too? Use the full Shopify CSV fixer, or decode the message with the Shopify CSV import error guide. Read why Excel turns barcodes into scientific notation for the background.

Frequently asked questions

Why do my Shopify barcodes show as scientific notation?

Excel treats a 12 or 13 digit barcode as a number and displays it as something like 8.85909E+11. If you save the file as CSV, that form can be written into the file itself. Shopify stores whatever the column contains, so the broken value becomes your live barcode.

Can every barcode be recovered?

No. The notation can always be expanded back to plain digits, but digits Excel rounded away when it saved are gone. A rebuilt barcode ending in a run of zeros has usually lost digits, so export those products again from your source.

Is my product data uploaded?

No. The repair runs in your browser tab and nothing is sent to a server. You can switch off your Wi-Fi after the page loads, and it still works.

Should I tick Excel-safe export before importing to Shopify?

No, not for a file going straight to Shopify, because the importer stores the = as part of the barcode. Tick it only if you will reopen the file in Excel first.