Make mail-merge labels in Google Docs without merge fields
Traditional mail merge workflows can require inserting fields, maintaining a separate template, and diagnosing placeholders. Label Wizard takes a spreadsheet-first route: select the data, map its columns, and preview labels without asking you to place merge fields in a document.
A repeatable label-printing workflow
Keep records in a Google Sheet
Use one row for each label record and a clear heading for every changing value. Separate name, address, product, date, and batch into their own columns. If the entire label is already in a single cell, that can also be used. Avoid mixing notes for staff with text meant to print.
Choose a matching template
Search the product number on the label package in the catalog. Confirm paper size, label dimensions, shape, and number per sheet. If no catalog layout matches, choose a custom size only after measuring the actual stock. Do not rely on a product name alone when the package lists a different version.
Open the add-on in Docs or Sheets
Launch Label Wizard in the Google document or spreadsheet where you want to prepare labels. Select the relevant source data. Unlike a conventional field-by-field merge, the workflow uses the selected rows to generate a preview, so you can check the values before creating a document or PDF.
Map and format the label
Connect each spreadsheet column to a label line and choose the order that makes the record easy to scan. You can design one label, paste a list, bold lines, and allow text to shrink to fit. Check long names at the final size; a field that technically fits may still be hard to read.
Preview the sequence
Compare the first, middle, and last records with the source sheet. Confirm that filters have not left hidden rows in an unexpected order. For a mixed set, make sure each row belongs to the intended batch and that no staff-only notes appear in the print output.
Create the output and test
Choose whether to make a PDF, create a new Google Doc, or place labels in the active Doc. Set the paper size and print scale to 100% or Actual size. A plain-paper test shows whether the printer feed and sheet orientation match the layout.
Maintain one source of truth
When a name or address changes, update the sheet and regenerate the affected labels. Keeping values in the spreadsheet avoids editing many individual cells in a generated document. Save a copy of the approved layout if the same stock will be used again.
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
A spreadsheet-first workflow keeps the changing information in one place. Give each row a complete record and use headings that are clear to the person preparing the print run. Keep staff-only notes outside the mapped range, and decide whether one row or one cell represents a label before building the preview. This avoids the common mistake of printing a note or an extra blank row. Review a handful of records in source order and compare them with the generated preview before creating the output.
The output choice depends on how the team works. A PDF is useful for a reviewed file or later print, a new Google Doc gives you a separate document, and placing labels in the active Doc keeps the result with the document you already opened. After creating output, use the same paper size as the stock and print at Actual size. When a value changes, update the Sheet and generate the corrected label rather than making separate edits across a document.
Questions about this workflow
Does Label Wizard use merge fields?
No. It selects spreadsheet rows and creates a label preview without requiring merge fields in the Doc.
Can one row produce one label?
Yes. Map the columns and review the preview in the same order as the source rows.
Can I use whole-label cells?
Yes. A cell can contain all the text for one label if that suits the sheet.
Where does the output go?
You can create a PDF, create a Google Doc, or put the labels in the currently open Doc.