Home › Bulk Generator

Free Batch Barcode Generator — CSV and Excel Workflow Guide

When your product catalogue has more than a handful of items, generating barcodes one at a time stops being practical. The batch generator takes a spreadsheet — whether you work in Excel, Google Sheets, or any other tool that exports CSV — and converts every row into a barcode image in a single pass. This page walks through the full workflow: file preparation, upload, generation, and troubleshooting common errors.

What the Batch Generator Does

You upload a file. The tool reads each row, generates the appropriate barcode for that row, and packages the results for download. The output options are a ZIP archive of individual PNG or SVG files (one per barcode, named by the barcode value or label text), a multi-page PDF formatted for a label sheet, or an Excel file with barcode images embedded alongside your original data.

All processing happens in your browser. A catalogue of 1,000 items typically takes 20–60 seconds depending on device speed. There is no server-side processing and no file size limit enforced by the tool — practical limits depend on your device's memory.

Preparing Your CSV File

The minimum CSV structure is one column containing the barcode values. A more complete file includes a label text column, which controls the human-readable text printed beneath each barcode. Here is a working example:

barcode,label,price
012345678905,Blue Widget 500ml,$12.99
012345678912,Blue Widget 1L,$18.99
012345678929,Red Widget 500ml,$12.99
200100001234,Internal SKU — Warehouse Bin 4A,
SHIP-2026-04-001,Outbound Shipment April 1,

Column names in the header row do not need to match exactly — you select which column maps to which field during the upload step. The price column above would simply be ignored unless you map it to label text. Rows with an empty barcode cell are skipped.

Generating Barcodes from Excel

Excel files (.xlsx) can be uploaded directly — you do not need to export to CSV first. Open the Batch Generator tab, drag your .xlsx file into the upload area, and the tool reads the first sheet. If your data is on a different sheet, export that sheet as CSV.

From Google Sheets: File → Download → Comma-Separated Values (.csv). The downloaded file opens cleanly in the batch generator without any modification.

Column Mapping

After uploading, the tool shows the first few rows of your file and asks you to confirm which column contains the barcode values and which (optionally) contains the label text. If your file has a header row, check the "First row is header" option. If values are in column A with no header, leave it unchecked and select column A manually.

Quick access: Generate FNSKU barcodes · Generate ITF-14 barcodes · Generate Code 128 barcodes

Choosing Your Barcode Format

Select the format once for the entire batch — all rows generate the same format. If your file contains a mix of UPC values and Code 128 values, split them into two separate files and run two batches. The formats most commonly used in batch generation:

UPC-A — for retail product labelling. Provide 11 digits; check digit is added automatically. Or provide all 12 including the check digit.
EAN-13 — for international retail. Provide 12 digits; check digit added. Or all 13.
Code 128 — for shipping labels, asset tags, SKUs. Enter the data exactly as it should be encoded — letters, numbers, and hyphens are all valid.
QR Code — for URLs, WiFi credentials, or any text. Each row becomes a separate QR code.

Common Errors and How to Fix Them

"Invalid barcode value" on some rows — for UPC-A and EAN-13, check that the values are purely numeric. A stray space, a letter, or a hyphen will cause that row to fail. In Excel, format the barcode column as Text before entering values to prevent leading zeros from being dropped.

Leading zeros disappearing — this is the most common Excel issue. If your UPC starts with 0 (like 012345678905), Excel silently removes it. Fix: before entering or pasting values into Excel, format the entire barcode column as Text (right-click → Format Cells → Text). Alternatively, prefix each value with an apostrophe: '012345678905.

Check digit errors — the generator validates check digits for UPC-A, EAN-13, and ITF-14. If a value fails, use the single barcode generator to confirm the correct check digit for that number.

File encoding issues — if your CSV was exported from a non-English locale, it may use a different character encoding. Save or re-export as UTF-8. In Excel: Save As → Tools → Web Options → Encoding → Unicode (UTF-8).

Output Options

ZIP of PNG files — individual raster images, one per barcode. File names default to the barcode value. Change naming by including a label column and enabling "Use label as filename." PNG at the generator's default output size is sufficient for screen use and basic label printing at up to 300 DPI.

ZIP of SVG files — vector format. No quality loss at any print size. The right choice if images will be placed into packaging artwork in Illustrator, InDesign, or a similar tool.

Multi-page PDF — barcodes arranged on a label sheet. Use the Page Designer settings to match your label stock (Avery 5160, Avery 5163, or custom dimensions). The PDF exports at 72pt per inch base; print at 100% scale, not "fit to page."

Open the Batch Generator