How to print labels from Google Sheets
Printing labels from a spreadsheet works best when the source data is tidy and the stock is identified before formatting begins. This guide walks through a repeatable process: find the label product number, prepare one row per label, review the preview, and test the result on plain paper.
A repeatable label-printing workflow
Choose the exact label stock
Read the product number from the package and search the PrintGenius catalog. Compare the brand, product number, paper size, label dimensions, row and column counts, and labels per sheet. If the package lists a different number, do not assume that a similar-looking stock uses the same spacing. The template is a starting point; verify the physical sheet before printing.
Prepare a clean spreadsheet
Give each label a row when each record needs a different name or value. Use clear column headings such as Name, Address, Product, Batch, or Date. Remove blank rows from the intended print range, keep punctuation consistent, and avoid merged cells in the data area. If each spreadsheet cell already contains a complete label, that format can also be used.
Open the Google add-on and choose the data
Open Label Wizard in the Google document or sheet where you want to work. Select the relevant spreadsheet or range and map each column to the label text fields. Keep the mapping simple: one source column for each value that may change from row to row. The add-on uses the selected data to build the preview.
Review the layout before printing
Check a short sample first. Confirm that the first and last rows show the intended values, that long names fit, and that line breaks are useful. You can arrange a single label, paste a list, use each row or each cell, emphasize lines in bold, and allow text to shrink to fit. Shrinking is a layout aid, not a substitute for readable type.
Set paper size and scale
In the print dialog, choose the same paper size shown for the label stock. A4 and US Letter sheets are not interchangeable. Select 100% or Actual size, and disable Fit to page or any scaling option that changes dimensions. Confirm the correct printer tray and feed orientation.
Run a plain-paper test
Print the preview on ordinary paper, then place it behind the label sheet against a light source. Check that rows and columns line up with the die cuts. If the test is shifted, confirm orientation, page size, scaling, and how the printer feeds the sheet before changing the template.
Print the final run and save the source
When the test aligns, load the label paper in the correct direction and print a small first batch. Label Wizard can create a PDF, create a Google Doc, or place output in the currently open Doc. Keep the spreadsheet as the source of truth so later updates do not have to be typed into a finished label file.
Keep the source data and printed output in sync
Make corrections in the source spreadsheet rather than editing a stack of output labels by hand. Use a separate field for each changing value, check a representative long record, and verify that the selected rows match the current run. If a value is missing, pause and fix the source before creating a second version of the same label.
Label Wizard supports catalog product numbers and custom dimensions, one-label layouts, pasted lists, and spreadsheet data organized by row or cell. You can bold lines, shrink text to fit, begin at a selected label on a partly used sheet, and create a PDF, a new Google Doc, or output in the active Doc. The preview helps check layout; it does not validate the source information or the printer’s physical feed.
Common checks before the final sheet
- Read the stock number and paper size from the package.
- Compare the catalog dimensions with the physical label sheet.
- Use 100% or Actual size and turn off page fitting.
- Print on plain paper and compare the top, middle, and bottom rows.
- Keep the approved spreadsheet as the source of truth for updates.
For a one-off run, check that the spreadsheet contains only the intended rows. For a recurring run, keep the template name, stock number, and paper settings with the production notes so the next person can reproduce the result.
Practical notes for this guide
Treat the spreadsheet as a small production document. Keep a clear header row, avoid mixing instructions with printable values, and choose a predictable sort order before opening the add-on. If a label uses several lines, decide which source column feeds each line and keep that mapping consistent. A short sample with the longest values is more useful than checking only the first record. Confirm that blank cells are intentional, since an empty source value can leave an unexpected line or make neighboring text appear crowded.
For recurring print runs, record the label product number, paper size, printer, and feed orientation alongside the source sheet. These details are not a substitute for a new paper test after a printer or stock change, but they make the next run easier to reproduce. Save the reviewed sheet as the source of truth and regenerate output after corrections rather than editing individual labels by hand. Before loading adhesive stock, verify the first, middle, and last records, then compare the paper proof with the physical sheet.
Questions about this workflow
Can each spreadsheet row become one label?
Yes. Map the columns you need and preview the rows in the intended order.
Can a cell contain the whole label?
Yes. Whole labels pasted into cells can be used instead of mapping multiple columns.
How do I stop labels from shifting?
Match paper size and orientation, print at 100% or Actual size, and compare a plain-paper test with the stock.
Can I print only part of a sheet?
Yes. Use the start-at-any-label option and confirm the position with a test page.