StriveFormats
CSV Fixer

Fix barcodes

Excel drops leading zeros from barcodes and shows long ones as 1.23457E+11. This tool repairs what can be proven correct and flags what can't.

Free · no sign-up · runs in your browser

Drop a CSV file here, or

Your file is processed in your browser. It is not uploaded.

How it works

  1. 1

    Drop in your CSV. Barcode columns (UPC, EAN, GTIN, Barcode) are found automatically.

  2. 2

    Leading zeros and scientific notation are repaired only when the barcode's check digit proves the result.

  3. 3

    Download the repaired file and check the list of barcodes that need your attention.

Questions

How can you be sure a leading zero is right?

Every UPC and EAN ends in a check digit calculated from the others. A zero is only added when the padded code passes that check, so the repair can be proven.

Can 1.23457E+11 be restored?

Not from that text: Excel kept only six digits. If the file still has every digit (for example 1.23456789012E+11), it is expanded. Otherwise the cell is flagged so you can copy the barcode again.

Which platforms need valid barcodes?

Shopify stores them as text, Google Shopping and Amazon check GTINs, and many marketplaces reject invalid ones. A barcode with a missing zero is a different product.

More free tools

CSV splitter

Split a large CSV into smaller files, each with the header row. Rows of the same product stay in the same file.

Open

Remove duplicate rows

Find and remove duplicate rows, either rows that are identical in every column or rows that share a value such as a SKU.

Open

Fix CSV encoding

Turn garbled text like "Café" back into "Café", and convert the file to UTF-8, the encoding every store platform expects.

Open

Excel to CSV

Convert an .xlsx workbook to a UTF-8 CSV. Barcodes keep their digits, dates become YYYY-MM-DD, and accents survive.

Open

Shopify handle generator

Turn product titles into clean Shopify URL handles, from a list of titles or for a whole product CSV.

Open