How to print 5160 address labels from Google Sheets
By Jake Marsh · Updated
To print 5160 address labels from Google Sheets, install Labelyard, open Extensions > Labelyard > Create labels, type 5160 in the Label sheet search and click the layout. Write the label as {{Name}}, {{Address}}, {{City}}, {{State}} {{ZIP}} on the Design tab, print the free alignment test page, then click Create PDF and print at 100%. You get 30 labels per sheet, one per row of your tab.
Before you start
- A Google Sheets tab with one address per row and column names in row 1.
- A pack of labels that says 5160 on the box. The same 1 x 2-5/8 in, 3 across by 10 down layout is sold under other codes too, including 8160 (inkjet), 5260, 5960, 18160 and 15160, and Labelyard lists them as compatible with the same layout.
- Google Sheets has no label feature of its own and Google Docs has no mail merge, which is the gap the add-on fills.
Steps
- Set up the sheet. Use separate columns for Name, Address, Address 2, City, State and ZIP. Keep ZIP codes as plain text or as they show in the cell; Labelyard prints what the cell displays, so 02134 stays 02134.
- Open Extensions > Labelyard > Create labels.
- Type 5160 in the Label sheet box and click "Address labels, 1 x 2-5/8 in, 30 per sheet". The preview on the right draws the sheet.
- Pick the tab and the rows. Leave All rows with data, or choose Only the rows I select in the sheet to print part of the list.
- Write the label on the Design tab. Use Insert a column... to add each field, one per line:
Tick Leave out lines whose columns are empty, so a row with no Address 2 doesn't print a gap.{{Name}} {{Address}} {{Address 2}} {{City}}, {{State}} {{ZIP}} - Print a free alignment test page from the Print tab on plain paper. Hold it against a label sheet and the light. The ruler on it should measure exactly 4 in.
- Click Create PDF and print it with Scale set to 100% or Actual size.
If the labels don't line up
| What you see | What to change |
|---|---|
| Every row drifts a little further down the page | The print dialog is scaling. Set 100% or Actual size, not Fit to page |
| Everything is off by the same amount | Use Move right (mm) or Move up (mm) on the Print tab, then test again |
| Long addresses look crowded | Text shrinks down to 5 pt and then wraps. Lower Largest size, or tick Same text size on every label for an even look |
| Some labels on the sheet are already used | Under Start on a used sheet, click the first empty spot |
Labelyard saves the nudge for that spreadsheet, so the next batch prints the same way.
Other common address label sizes
| On the box | Size | Per sheet |
|---|---|---|
| 5161 | 1 x 4 in | 20 |
| 5162 | 1-1/3 x 4 in | 14 |
| 5163 | 2 x 4 in (shipping) | 10 |
| 5167 | 1/2 x 1-3/4 in (return address) | 80 |
| L7160 (A4) | 63.5 x 38.1 mm | 21 |
What it costs
Labelyard's free trial covers your first 300 labels or 14 days, whichever comes first, with no card needed. Previews and alignment test pages never count. After that it's $9.99 a month, $39 a year or $99 once for lifetime use on one Google account, and a $149-a-year team plan covers everyone at your company or school domain. Install it from the Labelyard page.
Labelyard: Print Labels & Envelopes
Print address labels, name tags and stickers from Google Sheets rows, lined up on the first try $9.99 a month or $39 a year per Google account.
Questions
Is the 8160 the same layout as the 5160?
Yes. Both are 1 x 2-5/8 in labels, 30 per sheet, on US Letter. The 5160 is for laser printers and the 8160 for inkjets. Search either code and you get the same layout.
Can I print one page of 5160 labels to test my list?
Yes. Choose Row numbers... under Rows and type something like 2-31. That's exactly one sheet of 30.
How many 5160 labels does the free trial cover?
300 labels, which is 10 full sheets, or 14 days, whichever comes first. Previews and the alignment test page don't count.
Can I add a return address in the corner of each label?
Each label prints the text you write on the Design tab, so you can add a small line for it. For a separate sheet of return address labels, use the 5167 layout with The same label on every spot.
More Labelyard guides
More Google guides
- How to create a PDF for each row in Google Sheets (PickMerge)
- How to make a Google Sheets spreadsheet accessible (Includewell)
- How to export more than 1,000 rows from Search Console (Queryledger)
- How to count cells by font color in Google Sheets (Huecount)