Skip to content
Gookit Help

Pick your store platform

Choose your store platform and install BarcodeMan. Plans, pricing and trial eligibility vary by platform. Confirm the available plans in the app and the final charge on the approval or checkout screen.

Keep your list in Google Sheets instead? BarcodeMan for Google Sheets

Articles

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.

Verified
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.

productbarcodeqty
MugMUG-0013
ToteTOTE-002
BoxBOX-0030

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