Bulk Barcode Generator: Create Hundreds of Barcodes From a Spreadsheet

A bulk barcode generator does one job: take a column of codes and turn each row into a scannable barcode without typing them one at a time. The reliable route is a spreadsheet for the data, a generator or barcode font for the symbols, and a label template for printing.

The shortest working path:

• Data: one row per product, one column per field, SKU stored as text so leading zeros survive.

• Symbols: a barcode font for Code 39, or a generator that outputs images for Code 128 and EAN-13.

• Output: merge the column into a label sheet and print at 100% scale, never “fit to page”.

Bulk Barcode Generator: Create Hundreds of Barcodes From a Spreadsheet

Three Ways to Generate Barcodes in Bulk

Most failures come from picking the route before checking the format. Each route has a page limit or a download limit that shows up halfway through a catalog.

Route	How it works	Watch out for
Online bulk generator	Upload a CSV, download a PDF or ZIP of images	Free tiers cap rows, and your SKU list leaves your machine
Barcode font in a spreadsheet	Type the code, apply the font, print the sheet	Only works cleanly for Code 39; start and stop characters are required
Label software with a data merge	Connect the sheet to a label template	Per-seat licence, and a template that resizes the barcode

For a few hundred internal codes, the font route is fastest and stays offline. For retail codes that need a valid check digit, use a generator — a font cannot calculate check digits for you.

Three bulk barcode generation routes

Choose the Barcode Type Before You Generate

The type decides the character set, the length, and who is allowed to issue the number. Pick it wrong and the printer’s scanner rejects the label.

Type	Characters	Use it for	Who issues it
Code 39	Digits and capital letters, variable length	Assets, shelves, internal tracking	You, no registration
Code 128	Full ASCII, compact, includes a check digit	Shipping labels, serial numbers	You, no registration
EAN-13	12 digits plus a check digit	Retail products sold in stores	A GS1 company prefix
QR or 2D code	Text and URLs	Packaging links, manuals, promotions	You, or GS1 for retail 2D

Retail is the hard constraint: a shop’s point-of-sale system will only accept a barcode built on a GS1 company prefix, and resellers usually refuse homemade EANs. For anything internal — equipment, bins, files — Code 39 or Code 128 with your own numbering is enough.

Barcode types compared for bulk printing

How to Build the Barcode Batch in a Spreadsheet

The spreadsheet is the part that decides whether the batch prints cleanly. Five minutes of cleanup saves a reprint of 400 labels.

1. Store codes as text. Format the SKU column as Text before you paste, or “00123” becomes 123 and every label is wrong.

2. Keep one code per row and remove duplicates with a formula or a pivot count. Duplicate codes scan fine and destroy your inventory data.

3. For a font-based batch, add a helper column with the start and stop characters: ="*"&B2&"*" for Code 39, then apply the barcode font to that column only.

4. For image-based barcodes, generate one image per row and insert it into a fixed-size cell so the symbols stay identical in width.

5. Freeze the header row and sort by SKU before printing, so the sheet order matches the packing list.

A layout that survives printing looks like this: four data columns, one narrow helper column for the code string, and one column for the barcode itself. Keep the barcode column the same width for every row, because a symbol squeezed into a narrow cell is the most common reason a label fails to scan.

Barcode batch layout in spreadsheet

Print and Validate the Batch Before It Ships

A printed barcode is a physical object: ink spread, paper curl, and a resized print dialog can all break it. Test on paper, not on screen.

1. Print at 100%. Turn off “fit to page” and “shrink to fit”; both rescale the bars and change the ratio between wide and narrow elements.

2. Keep the quiet zone. Leave clear white space on both sides of every symbol — text or a border pressed against the bars stops the scan.

3. Print one sheet first and scan three labels with two different devices: a handheld scanner and a phone camera app.

4. Check the human-readable line against the barcode data, since a mismatch means the wrong column was applied.

5. Store the batch as a PDF plus the source sheet, so a reprint in six months produces identical labels.

One more trend matters if you print packaging, not shelf labels: GS1 is moving retail toward 2D codes that carry a web link alongside the product number, so a batch generated today may need a QR-style companion later. Building the data column now — clean, unique, text-formatted — is what makes that migration a reprint rather than a rebuild.

Printing and scanning a barcode batch

The Best Free Spreadsheet Alternative: WPS Office

A barcode batch is a spreadsheet job before it is a printing job: clean the column, build the string, freeze the header, export the PDF. That is the work WPS Spreadsheet is built for.

• Text formatting that holds: set the SKU column to Text and leading zeros survive the paste.

• Duplicate and formula checks: count duplicates and build the code string with the same formulas you would use in Excel, then export to PDF at 100% scale.

• Free on every device: the file opens on Windows, macOS, Android, and iOS, so the person printing labels is not tied to one desk.

If you are starting from zero, the Excel barcode guide covers fonts, formulas, and generators step by step before you scale to a full catalog.

WPS Spreadsheet handles data and charts

FAQs

How many barcodes can I generate at once?

A spreadsheet can hold tens of thousands of rows, but free online generators usually cap a batch at a few hundred. For large catalogs, generate images locally or use a label tool with a data merge.

Can I create barcodes in Excel or WPS for free?

Yes, for Code 39 with a barcode font: wrap the value in asterisks, apply the font, and print. Code 128 and EAN-13 need a generator because they include a check digit the font cannot compute.

Why does my barcode not scan after printing?

Usually scaling or contrast: the print dialog shrank the page, the symbol lost its quiet zone, or the printer spread the ink. Reprint one label at 100% and test again.

Do I need a GS1 prefix for retail barcodes?

Yes, for products sold through retail checkout. GS1 issues the company prefix that makes the EAN or UPC unique, and marketplaces usually require it before listing.

Can a barcode be reused on a different product?

No. A retail barcode identifies one product variant permanently; reusing it mixes sales data and gets listings rejected. Internal asset codes can be recycled only after the asset is retired.