This page opens in batch mode with four rows pasted straight from a spreadsheet: a header row, then SKU, product name and number of copies, separated by tabs as Excel and Google Sheets copy them. The table below shows how each row is read. Select the same three columns in your own sheet, copy, and paste over the example.
Step by step
- In Excel, put the barcode data in the first column. Add a column with the text you want on each label, and a column with the number of copies if you need more than one of some items.
- Select the cells (with or without the header row) and copy them. From a CSV file, open it in any text editor and copy the lines, or paste the file’s contents directly.
- Pick the barcode type. Code 128 is the usual choice for SKUs, bins and asset numbers because it takes letters and digits; choose EAN-13 or UPC-A if your column holds GTINs, and the check digits are added to every row that needs one.
- Under Print on labels, choose your sheet and download the PDF. Every row was read back by a barcode reader first; the line under the preview says so, or lists the rows that failed.
Tips for clean data
Excel likes to turn long numbers into scientific notation and drop leading zeros, which silently changes a GTIN. Format the column as Text before typing or importing numbers, and check that 012345678905 hasn’t become 12345678905. Keep each value on one line, and avoid characters your barcode type can’t hold: the generator names the line and the character when it finds one.
How the example rows are read
The columns pasted above, as the generator reads them (the header row is skipped).
| Line | Barcode data | Label text | Copies |
|---|---|---|---|
| 2 | SKU-10045-B | Oat bar 50 g | 3 |
| 3 | SKU-10046-B | Rye crackers | 2 |
| 4 | SKU-20017-W | Honey 250 g | 1 |
| 5 | SKU-20018-W | Honey 500 g | 1 |