How to print address labels from a spreadsheet
A clean address list is more important than a complicated layout. Before printing, confirm the source list, choose the exact stock, and inspect the label preview for line breaks and missing information. This process is designed for small teams sending approved mail from Google Sheets.
A repeatable label-printing workflow
Start with an approved list
Use a current list from the system your organization trusts. Keep access limited, remove duplicate or outdated records, and apply the appropriate contact preferences. Do not copy payment card details, passwords, or internal notes into the print sheet.
Separate address components
Use columns for name, organization, street, unit, city, region, postal code, and country when needed. Separate fields make line order predictable and help reveal incomplete values. Format postal codes as text so leading zeros are preserved.
Identify the stock
Read the product number on the package and find it in the template catalog. Confirm its brand, paper size, dimensions, rows, columns, and labels per sheet. If the package number is absent, compare measured dimensions and use a custom size only when the stock is verified.
Map columns and preview
Open Label Wizard in Google Docs or Sheets and select the address rows. Map the columns to the label lines. Preview a short sample with the longest address and any unit numbers. If a label looks crowded, change the layout or shorten a source field only when the underlying record supports that edit.
Check the list and print order
Review names and postal data against the authorized source. Check the first and last labels and compare a few middle entries. If the mailing run follows an order sequence, sort the source sheet before starting so the printed stack is easy to reconcile.
Test paper alignment
Set the same paper size as the label stock and print at 100% or Actual size. Disable Fit to page. Print on plain paper and compare it to the label sheet; confirm the printer feeds the stock in the intended orientation.
Print a small batch and secure leftovers
Start with a small number of sheets. Store unused labels and any temporary exports according to your organization’s privacy practices. Keep the source workbook as the record, and avoid leaving addresses in an unsecured print queue or shared folder.
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
Address data deserves a careful review because a polished layout cannot correct a bad source record. Confirm that the list is current and approved for the mailing, check duplicate recipients, preserve leading zeros, and compare any changed addresses with the trusted record. When you use separate columns, map them in the intended reading order. Try a long name and address first: those records reveal wrapping issues that a short sample may hide. Do not put confidential staff notes or unrelated account details in the print range.
After printing, handle leftover sheets and temporary files according to your organization’s privacy practices. Keep the approved workbook as the source of truth, and avoid saving additional copies in shared folders without a reason. A plain-paper test checks layout and printer feed without using adhesive stock. If the alignment is correct but an address is wrong, fix the spreadsheet and regenerate the affected output; do not rely on handwriting a correction across a larger batch.
Questions about this workflow
Can I use separate address columns?
Yes. Mapping name, street, city, region, and postal code separately makes line order easier to review.
How do I preserve leading zeros?
Format postal-code cells as plain text and check the preview against the original list.
Does Label Wizard validate addresses?
No. It lays out text supplied by the user; use your approved address-validation workflow.
Can I print only selected recipients?
Yes. Choose the intended rows and verify the selection before printing.