Print barcodes from Google Sheets
Open the free label maker: https://app.mylabelmaker.com. No signup. Design the label, then print to a Zebra or download PNG, PDF, or ZPL.
You can print barcodes from Google Sheets without an add-on. Publish the sheet as CSV, open the free label maker, map {{sku}} to a CODE128 barcode, and print. No signup. A normal share link will not load.
Good to know: Publish to the web as CSV (File, Share, Publish to web). A normal share link will not load. Google Sheets still needs the network so your browser can fetch the published sheet.
How to print barcodes from Google Sheets
- Open https://app.mylabelmaker.com. No signup.
- Headers: sku, name. File, Share, Publish to web, CSV. Copy the URL. 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
Got a Zebra? Print with Browser Print at the printer's DPI. Everyone else: print from this computer, or download PNG, JPG, SVG, PDF, or ZPL. Save JSON if you want the editable master back later.