How to make Avery 5160 labels in Google Docs
Avery 5160 is a familiar US Letter address-label layout, but the product number alone does not guarantee that a printer will align it. This guide shows how to find the catalog record, prepare the names and addresses, place the layout in Google Docs, and test the sheet at actual size.
A repeatable label-printing workflow
Confirm the package number and dimensions
Find 5160 on the label package and match it to the catalog record. The PrintGenius catalog lists the 5160 as a 30-label sheet with three columns and ten rows; each label is 2⅝ inches wide by 1 inch high on US Letter paper. If your package differs, use the number and dimensions printed on the box rather than assuming it is equivalent.
Prepare the address list
Set up one row per recipient with separate columns for name, street, unit, city, state, and postal code. Keep a consistent order and remove empty records from the print range. Check household names and apartment numbers against the approved source before loading data into the add-on.
Open Label Wizard in Google Docs
Open a Google Doc and launch Label Wizard. Select the Google Sheet or the range that contains the addresses, then map each source column to a line on the label. Use the preview to check how long names and multi-line addresses fit. You can adjust the design, paste a list, or use the spreadsheet rows.
Check all 30 positions
Review the first row, a middle row, and the final row. Look for missing values, unexpected blank lines, and postal codes that were interpreted as numbers. If a leading zero disappeared, format the source column as plain text and verify the value again.
Print a test at actual size
Choose US Letter paper and print at 100% or Actual size. Turn off Fit to page and any borderless expansion. Print one page on regular paper and compare it with a 5160 sheet held against light. Check the top and bottom rows; small scaling errors are easier to see at the edges.
Print and save the layout
After the paper test aligns, load the label sheet in the orientation specified by the printer. Print a small run first. Label Wizard can create a PDF or a new Google Doc, or place label output in the active Doc. Keep the spreadsheet as the source so corrections can be made to a name once.
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
The catalog lists Avery 5160 as 30 labels on a US Letter sheet, arranged in three columns and ten rows. That is a useful starting point, not a substitute for checking the number printed on your package. Similar products can use a different grid or paper format. Keep the address list in a separate Google Sheet and preserve postal codes as text, especially when they begin with zero. Review punctuation, apartment details, and country-specific address order before mapping values into the label.
A reliable proof checks more than the first label. Inspect a long name, a multi-line street address, a middle position, and the last row. Small scale differences may be hard to see near the top but become visible farther down the page. Turn off Fit to page and borderless expansion, use Actual size, and compare a plain-paper test over an unused sheet. If the proof is off, check the tray and feed direction before changing the template dimensions.
Questions about this workflow
How many Avery 5160 labels are on a sheet?
The catalog entry lists 30 labels arranged in three columns and ten rows.
Can I use Avery 5160 for shipping?
The 5160 catalog record is an address-label layout. Choose a larger shipping product if the carrier workflow needs more space.
Why is my 5160 print shifted?
Check paper size, orientation, scale, tray feed, and a plain-paper alignment test before changing the design.
Can I print different addresses on one sheet?
Yes. Use one spreadsheet row per address and review the row order.