GOOGLE SHEETS TO PRINTABLE QR LABELS
Your Google Sheet knows the row. The shelf still has vibes.
Export the active tab as CSV, map the readable ID and exact scan destination, then print up to 500 QR asset labels on a US Letter 30-label layout compatible with Avery 5160 and 8160 sheets. No add-on, no account, and the CSV stays in your browser.
A QR code should open the exact record or carry the exact item ID. It should not force someone to search a 900-row sheet while standing in front of the shelf.
THE TEN-MINUTE VERSION
From Google Sheets rows to a printable label sheet.
- 1
Give each row a readable ID. Use one short, stable label ID per row. Examples include TOOL-014, BIN-A-07, or CAMERA-03.
- 2
Add the exact scan destination. Put the record URL in its own column. Leave it blank when the QR code should contain only the readable ID.
- 3
Download the active tab as CSV. In Google Sheets, choose File, Download, Comma-separated values. Sheets exports the current tab as a CSV file.
- 4
Map, generate, and test-print. Import the CSV, choose the ID, destination, and small-text columns, generate the sheet, then print one page at actual size before labeling everything.
THE SHEET STRUCTURE
Three columns are enough for a useful label.
| Column | Example | What happens |
|---|---|---|
label_id | TOOL-014 | Prints the readable ID and becomes the QR value when no destination is supplied. |
record_url | https://example.com/tools/14 | Opens that exact existing record when someone scans the code. |
small_text | Electrical cart | Adds one short location, category, or purpose line beneath the ID. |
WHY EXPORT A CSV?
Skip the formula wrestling and the add-on permissions.
A QR formula can place images inside cells, but it does not automatically create a clean 30-label print layout. An add-on can solve more elaborate design jobs, but it also means installing another tool into the spreadsheet workflow.
The CSV route is deliberately boring. Google Sheets exports the rows, the browser maps the columns, and the free generator creates the printable sheet. Nothing needs access to the Google account.
Use US Letter paper, select actual size or 100 percent scale, and make sure the browser is not shrinking the page. The layout uses 1 × 2⅝ inch labels, a ⅛ inch column gutter, and ½ inch top and bottom margins. Scan several labels from normal working distance before applying the full batch.
WHAT SHOULD THE QR OPEN?
Use a stable record URL when the information will change.
Static text is fine for an ID that will never need more context. Use a record URL when the scan should show a current location, photo, status, custody, maintenance note, or history.
Do not bake a temporary room, truck, or employee name into the permanent label. Keep the physical ID stable and change the living record behind it.
READY TO PRINT?
Drop the Google Sheets CSV into the generator.
Map the columns, generate up to 500 labels, and print standard 30-label sheets locally.
WHEN A STATIC SHEET STOPS BEING ENOUGH
The same label can open a living Tagnetix record.
Tagnetix adds location, status, photos, custody, and history behind the scan. The Google Sheets workflow and free label generator work without creating an account.
Try Tagnetix with the labels →