Batch barcode generator and label sheets
Paste a list or open a CSV, pick the format and get every barcode at once: as a ZIP of files, or as a PDF of label sheets ready for your printer. Nothing is uploaded.
Any text per line: SKUs, asset tags, serial numbers. Pasting two or three columns from a spreadsheet adds a caption and a number of copies.
4 ready
Barcode size
On label sheets a barcode larger than its label is shrunk to fit, and you are told when that happens.
Print at 100% (“Actual size”). Try one page on plain paper first and hold it against a label sheet.
How a batch works
- Step 1
Bring your list
Paste a column from a spreadsheet, open a CSV or generate a number sequence. A second column becomes the caption and a third the number of copies.
- Step 2
Check the rows
Every row is checked for the format you chose, as you type. Rows that cannot be drawn are listed with their line number and the reason.
- Step 3
Download
Get a PDF of label sheets with the barcodes as vectors, or a ZIP with one SVG or PNG file per row, named after its value.
Label sheet layouts
The layouts below match the label size and count of common Avery sheets, centred on the page. Sheets from other makers with the same size usually fit too. For anything else, choose “Custom grid” and type the measurements printed on the box or the maker’s template.
| Layout | Page | Labels | Label size |
|---|---|---|---|
| 30 per sheet, 1 × 2⅝ in | US Letter | 30 | 1 × 2.625 in |
| 80 per sheet, ½ × 1¾ in | US Letter | 80 | 0.5 × 1.75 in |
| 10 per sheet, 2 × 4 in | US Letter | 10 | 2 × 4 in |
| 21 per sheet, 63.5 × 38.1 mm | A4 | 21 | 63.5 × 38.1 mm |
| 14 per sheet, 99.1 × 38.1 mm | A4 | 14 | 99.1 × 38.1 mm |
Avery is a trademark of its owner; these layouts are not made or endorsed by Avery. US sizes checked against the Avery template pages below; printers shift paper slightly, so print a test page with outlines on plain paper first.
- Avery template 5160
1 × 2⅝ in labels, 30 per sheet.
- Avery template 5167
½ × 1¾ in labels, 80 per sheet.
- Avery template 5163
2 × 4 in labels, 10 per sheet.
Getting the size right
Barcodes on the sheet keep the module width and bar height you set. If one is bigger than its label, it is shrunk to fit and you are told by how much: a shrunk barcode has thinner bars, so test-scan it. Set a smaller module width or less data to avoid shrinking.
In the PDF the barcodes are vectors, so they print sharp at any printer resolution. PNG files in the ZIP store their dpi, so layout and label programs place them at the right size. For a single barcode with every option, use the generator.
Questions about batches and labels
How should I lay out my CSV?
Put the barcode data in the first column. A second column, if present, is printed as a caption under each barcode, and a third column sets how many copies of that label to print (1 to 100). A header row is detected, and you can switch it on or off.
How many barcodes can I make at once?
Up to 1,000 rows and 3,000 labels per batch. For more, split the list and run it again; nothing is stored between runs.
My labels do not line up with the sheet. What can I do?
Print at 100% (“Actual size”), not “Fit to page”. Then print one page on plain paper with outlines on, hold it against a label sheet in front of a light, and adjust the margins of a custom sheet if your printer shifts the paper.
What happens to rows that are not valid?
They are listed with the line number and the reason, and left out of the files. Fix them in the list and run the batch again.
Can I continue on a sheet I already used?
Yes. Set “Skip labels” to the number of labels already used and printing starts on the next free one.