Google Sheets · no add-on · Chromebooks too
Select your list in Google Sheets, header row included, copy it and paste it below. Choose the number on your label box and download a PDF at the sheet's exact size: no add-on to install, no access to your account.
Do it here
Select the list in Google Sheets, header row included, copy it and paste it in the box. Or open the .xlsx or .csv file Sheets downloads.
Worked example
The sheet a sign-up form fills, copied as it is: the form's own columns stay off and the zeros come back.
| Row | Timestamp | Name | Street address | Apt / Unit | City | State | ZIP code | Email address |
|---|---|---|---|---|---|---|---|---|
| 2 | 10/1/2026 9:14:03 | Abigail Turner | 27 Linden Way | Portland | OR | 97214 | abby.t@example.com | |
| 3 | 10/1/2026 10:02:47 | Marcus & Dee Pruitt | 412 Fern St | Apt 5 | Asheville | NC | 28801 | pruitts@example.com |
| 5 | 10/2/2026 8:45:59 | The Abernathy Family | 1903 Quarry Rd | Montpelier | VT | 5602 | abernathys@example.com | |
| 9 | 10/3/2026 11:16:25 | Lucía Navarro | 15 Harbor Hill Rd | Gloucester | MA | 1930 | lucia.n@example.com |
In Google Sheets, select the cells of your list, header row included: the names in the first row tell the box which column is which.
Copy with Ctrl+C (⌘C on a Mac), click the box above and paste with Ctrl+V (⌘V). The sheet beside it shows every label as it prints.
Pick the number printed on your label box, download the PDF and print it at its actual size.
Sizes from Avery's own template files. The numbers in a row share one layout, so one PDF fits them all.
| Sheet | Label size | Per sheet | Same layout | Good for |
|---|---|---|---|---|
| Avery® 5160 | 1 × 2-5/8 in | 30 | 8160 · 9160 · 18160 +56 | Most lists: a name, a street and a city line at 10 pt.For an inkjet printer, the same sheet is 8160. |
| Avery® 5161 | 1 × 4 in | 20 | 8161 · 5261 · 5909 +19 | Long names, such as two names joined by “&”: the labels are 4 in wide. |
| Avery® 5162 | 1-1/3 × 4 in | 14 | 8162 · 5262 · 5522 +8 | Four lines at 12 pt: room for a unit line or a country. |
Two ways in
Both give the box the same rows. Copying is quicker; a downloaded file keeps a copy of the list on your computer.
The cells arrive with a tab between them, so each of the 8 columns stays a column, and the header row tells the box which is which.
In an .xlsx file, the box reads the first sheet with a header row. Google lists the formats a spreadsheet downloads as: Excel, PDF, CSV, ODS and others (Google's note).
No add-on
No add-on to install and no permission to grant on your Google account: you copy the cells yourself, and the page sees only those.
No add-on, no extension: the page works in the browser you have open.
The page never opens your spreadsheet or your Drive. It sees only the cells you paste or the file you open.
The list is read in your browser and the PDF is made there too. Nothing is stored, and the list never goes in the page address.
No account and no trial: the whole list prints free, with no mark on the labels.
Chromebooks and Google Docs
Everything happens in Chrome, so a Chromebook does it all. Addresses typed in a document work too.
Paste the cells or open the file, then download the PDF and open it. To print it, press Ctrl + P and choose your printer next to Destination (Google's steps).
Print it at its own size, 100%: a sheet shrunk to fit the page drifts off its labels.
Copy the addresses with a blank line between them and paste them in the box above: each block becomes one label, line for line.
These 2 blocks make 2 labels, the first line of each in bold.
"Fit to page" can resize the sheet, and then the lower rows drift off their labels. The PDF opens at 100%; keep it there.
Printers differ: some print on the side facing up in the tray, others on the side facing down. Mark an X on a plain sheet, print once and look before you load labels.
Hold a plain-paper print over a 5160 sheet against a window. If it sits off, calibrate once and save the correction for that printer.
Yes. Select the list, header row included, copy it and paste it above, or download it as an Excel or CSV file and open that. Choose the number on your label box and download the PDF.
Paste the cells above and pick the number on your Avery box, 5160 for most address labels. The PDF is free, with no watermark and no account, and puts each label where Avery's template does: the template for Avery® 5160 labels has every measurement.
No. There's nothing to install and no access to your Google account to grant: you copy the cells yourself, and the page sees only what you paste.
Each row becomes one label, its columns matched to the lines by the names in the header row: Name, Street address, City, State, ZIP code. The header names it knows. A column it doesn't know, such as a form's Timestamp, stays off.
Yes, in Chrome. Download the PDF, open it and press Ctrl + P to print (Google's steps). Print it at 100%, not shrunk to fit the page.
Copy the addresses from the document with a blank line between them and paste them above: each block becomes one label, line for line, the first line in bold.
No. The page never opens your sheet: it reads only the cells you paste or the file you open, in your browser. Nothing is uploaded or stored, and who can see your sheet stays as you set it in Google Sheets.
The editor takes the same cells or file and does more: leave out duplicates and rows with no address, sort by last name or ZIP code, print copies.