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.
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
- In the sidebar’s Label section, choose Create template. If a template is already selected, choose Create new template.
- In the new editor tab, choose paper that matches your label stock, including its dimensions and layout.
- Add text and barcode elements. Connect their data fields to the worksheet’s column names. For the example worksheet, use
productfor the text andbarcodefor a Code 128 barcode. - Choose Save to save the design. A newly saved template becomes your current template.
- 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