How to print barcode labels from Google Sheets
By Jake Marsh · Updated
To print barcode labels from Google Sheets, set up the codes in Rowcode, open the Labels & files tab, choose your label sheet (such as Avery 5160) under Label sheet, add any text you want on each label, and click Download label PDF. Print the PDF at 100% ("Actual size"), not "Fit to page", so the codes land inside the labels.
Label sheets Rowcode knows
| Label sheet | Size | Per sheet |
|---|---|---|
| Avery 5160 / 8160 / 5960 | 1 x 2-5/8 in | 30 |
| Avery 5161 / 8161 | 1 x 4 in | 20 |
| Avery 5162 / 8162 | 1-1/3 x 4 in | 14 |
| Avery 5163 / 8163 | 2 x 4 in | 10 |
| Avery 5164 / 8164 | 3-1/3 x 4 in | 6 |
| Avery 5167 / 8167 | 1/2 x 1-3/4 in | 80 |
| Avery L7160 (A4) | 63.5 x 38.1 mm | 21 |
| Avery L7159 (A4) | 63.5 x 33.9 mm | 24 |
| Avery L7163 (A4) | 99.1 x 38.1 mm | 14 |
| Avery L7651 (A4) | 38.1 x 21.2 mm | 65 |
There are also plain-paper grids (2 in and 1.5 in squares on Letter, 50 mm and 35 mm on A4), one code per page for posters and signs, and Custom, where you type the page size, columns, rows, label size, margins and gaps from your label box.
Steps
- Make the codes first. In Codes in cells, pick the code type and the column, and click Make codes. The label PDF uses the same settings.
- Open Labels & files and choose the Label sheet.
- Add Text on each label. Use column names in double braces, such as
{{Product}}or{{Product}} {{Price}}, so each label shows its own row's text under the code. Tick Also print the encoded value to print the SKU or number too. - Do a test print. Tick Draw label outlines, download the PDF and print one page on plain paper at 100%. Hold it against a label sheet up to the light.
- Adjust if it's off. Use Nudge right (mm) and Nudge up (mm) to move everything a little. Most printers are off by a millimetre or two, the same way on every page.
- Untick the outlines and click Download label PDF again. Print on the label sheets at 100%.
Using a partly used sheet
Set Skip the first labels to the number of labels already gone from the sheet. Printing starts at the next free label, counting across the first row and then down.
Getting codes that scan
Rowcode draws bars and QR squares as sharp shapes, not a picture that gets blurry, and checks the size before you print. It warns you when QR dots would be smaller than 0.3 mm or barcode bars thinner than 0.19 mm, which many scanners struggle with. If you get that warning, choose a bigger label, shorten what's in the QR code, or use a lower error correction level such as M.
Image files instead of a PDF
For a label printer with its own software, or for a designer, use Download ZIP of PNGs in the same tab. Each row becomes one PNG, named with File name for each image, such as {{SKU}}.
What it costs
Rowcode is $4.99 a month or $39 a year per Google account. Free trial: 100 codes or 14 days, whichever comes first. No card needed. Every plan and the install link are on the Rowcode page.
Rowcode: Bulk QR Codes & Barcodes
Bulk QR codes and barcodes from Google Sheets rows, made inside Google, never expiring $4.99 a month or $39 a year per Google account.
Questions
Can I print labels for only some rows?
Yes. In Codes in cells, set Rows to the rows you want, or select them in the sheet and click Selection, before you download the PDF.
Where does the PDF go?
Straight to your computer's downloads. Click Save PDF to Drive instead to put it in your Google Drive; Rowcode can only see files it creates there.
Can I print address labels this way?
Rowcode prints a code on every label, so it's built for barcode and QR labels. For address labels, name tags and stickers without codes, Labelyard prints them from Google Sheets rows.
Does my trial cover a big print run?
Each label counts as one code during the trial. If a PDF has more labels than the trial has left, Rowcode says so before making it instead of giving you half a sheet.