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

Create a label template for Google Sheets

Create, reuse and edit BarcodeMan label templates from the Google Sheets sidebar, and connect text and barcode fields to your column names.

Verified
On this page

A template sets the paper, layout and design of your labels. Its data fields read the columns of your worksheet, so prepare your worksheet first.

Create a template

  1. In the sidebar’s Label section, choose Create template. If a template is already selected, choose Create new template.
  2. In the new editor tab, choose paper that matches your label stock, including its dimensions and layout.
  3. Add text and barcode elements. Connect their data fields to the worksheet’s column names. For the example worksheet, use product for the text and barcode for a Code 128 barcode.
  4. Choose Save to save the design. A newly saved template becomes your current template.
  5. Close the editor tab to return to Sheets. If you leave that tab open, choose Refresh in the sidebar to load the changes.

Reuse or edit a template

To reuse a saved template, choose it from the sidebar’s Template dropdown. To change the selected design, choose Edit template, make the changes, and save. Use Template details to check its paper size and layout.

Use a template on another worksheet

A template’s data fields must match the worksheet you print from. If you reuse a template on a different worksheet, check the headers again.

The current template belongs to your Google account, so changing it in another spreadsheet can also affect the template shown here. If BarcodeMan reports a template change, check the newly displayed template before printing.

Next, choose the rows and label quantities to print.

Questions about this article? Email our team.

Send feedback