Prepare a worksheet for BarcodeMan labels
Set up row 1 headers, keep leading zeros, and name columns so BarcodeMan template fields match your Google Sheets data.
On this page
BarcodeMan reads your worksheet one row at a time. Row 1 names the columns, and each row below it becomes a label. Set this up before you create a template.
Set up the header row
Put a unique, non-empty column name in every used column of row 1. Each row below it is one item. Avoid merged cells in the headers and data.
For a first batch, enter these values. Leave the second item’s qty cell empty.
| product | barcode | qty |
|---|---|---|
| Mug | MUG-001 | 3 |
| Tote | TOTE-002 | |
| Box | BOX-003 | 0 |
The qty column is optional. See Choose rows and label quantities for how BarcodeMan uses it.
Keep leading zeros
BarcodeMan uses the values displayed in the cells. To keep a barcode such as 00123, format its cells as Plain text before entering the value. A zero already removed by Sheets cannot be recovered by the label template.
How column names match template fields
Template data fields read columns with matching names. A field named product uses the product column in each row. Names match without regard to capitalization, spaces at either end, or repeated spaces. For example, Item name matches item NAME.
Use distinct names after those differences are removed. Headers Item name and Item name would count as duplicates. There is no separate column-mapping screen: rename the worksheet column or change the template’s data field when the names do not match.
Limits
- Up to 1,000 worksheet rows at a time, blank and hidden rows included.
- Up to 1,000 labels in one PDF.
Questions about this article? Email our team.
Send feedback