Print barcodes from Google Sheets
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.
Google Sheets can hold the SKUs. It should not have to fake a barcode with a font. Publish the sheet as CSV, open the free label maker, map {{sku}} to a CODE128 barcode, print.
Good to know: Publish to the web as CSV (File, Share, Publish to web). A normal share link will not load.
How to print barcodes from a Sheet
- Headers: sku, name. File, Share, Publish to web, CSV. Copy the URL.
- Open the free label maker. Set 2x1.
- Barcode {{sku}}. Text {{name}}.
- Variables, Google Sheet, paste the CSV URL. Preview. Print.
Sample spreadsheet
A live inventory tab might look like this before you publish it.
| sku | name |
|---|---|
| BIN-A12 | Spare filters |
| BIN-A13 | Belts |
| BIN-B01 | Gloves |
First row is the header. Those header words go inside the curly braces on the label, like {{sku}}.
QR instead of bars: QR from Google Sheets. Upload a file instead: Sheet CSV to labels.
Print or save
Zebra thermal: print from the browser with Browser Print at the printer’s DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.