Bulk barcode generator and label sheets
Paste one value per line or upload a CSV exported from Excel, Shopify or your inventory system. You get a PDF with one barcode per label, laid out for common A4 and Letter sticker sheets or for your own label size.
6 labels on 1 sheet
Codes are centred with 1.5 mm kept free at each label edge.
How to use it
- Choose the code type. For products use UPC-A or EAN-13 with your GS1 numbers; for SKUs and bins use Code 128.
- Paste the values, one per line, or upload a CSV. The first column is encoded; an optional second column becomes the caption under codes that allow one.
- Pick your label sheet. The presets match the sizes printed on common sticker sheet packs; for anything else enter columns, rows, label size and margins.
- Download the PDF and print at 100% (“Actual size”). Print one sheet on plain paper first and hold it against a label sheet to check alignment.
Exporting from Excel, Google Sheets or Shopify
In Excel or Google Sheets, select the column with your numbers or SKUs and copy it into the box, or save the sheet as CSV. Format UPC and EAN columns as text before exporting, otherwise spreadsheets drop leading zeros or turn long numbers into 5.9E+12.
In Shopify, export products as CSV; the “Variant Barcode” or “Variant SKU” column holds the values. Delete the other columns or move the one you need to the front.
Label sheet presets
Each preset is defined by its measurements, so it matches any brand of sheet with the same layout. Check the sizes on your pack.
| Sheet | Labels | Label size | Top / side margin |
|---|---|---|---|
| Letter | 30 (3 × 10) | 2 5/8 × 1 in | 0.5 / 0.1875 in |
| Letter | 20 (2 × 10) | 4 × 1 in | 0.5 / 0.156 in |
| Letter | 10 (2 × 5) | 4 × 2 in | 0.5 / 0.156 in |
| Letter | 80 (4 × 20) | 1 3/4 × 1/2 in | 0.5 / 0.281 in |
| Letter | 6 (2 × 3) | 4 × 3 1/3 in | 0.5 / 0.156 in |
| A4 | 21 (3 × 7) | 63.5 × 38.1 mm | 15.15 / 7.25 mm |
| A4 | 24 (3 × 8) | 63.5 × 33.9 mm | 12.9 / 7.25 mm |
| A4 | 14 (2 × 7) | 99.1 × 38.1 mm | 15.15 / 4.65 mm |
| A4 | 40 (4 × 10) | 52.5 × 29.7 mm | 0 / 0 mm |
| A4 | 65 (5 × 13) | 38.1 × 21.2 mm | 10.7 / 4.75 mm |
Fitting codes on small labels
Each code is centred on its label with 1.5 mm kept free at the edges. If a code is wider than the label, it is scaled down, and the page tells you when that takes the module width below the standard minimum. Shorter values, Code 128 instead of Code 39, or a larger label fix that.
Questions
- How many barcodes can I make at once?
- Up to 2,000 rows per PDF. The PDF is built in your browser, so a large batch takes a few seconds on older computers.
- Are my CSV files uploaded?
- No. The file is read by your browser and never leaves your computer.
- Can I start on a partly used sheet?
- Yes. Set how many labels to skip and printing starts at the next free label.
- Can I print on a roll label printer?
- Use a custom layout with 1 column, 1 row and your label size, and the PDF will have one label per page.