Avery 5160 address labels from Google Sheets

You can print Avery 5160 address labels from Google Sheets in the browser. Open the Avery 5160 address label template. It is already 2.63 x 1 in. Publish the sheet to the web as CSV. A normal share link will not load. No signup.

How to print Avery 5160 address labels from Google Sheets

A Google Sheet has to be published before it will load. File, Share, Publish to the web, then CSV. Paste that link. A normal share link will not load. The first row has to be the column names. Asha already has 36 rows, is printing a club mailing, with Name, Street, and City. Row 2 might read Noah Ellis, 14 Pine Ave, Boise.

Paste the published link, then click those columns onto Avery 5160 address label. The size is already 2.63 x 1 in. A view-only share link will not load, even if you can open it yourself.

One row becomes one Avery 5160 address label. Check the rows you want, then Print. Print this reprints only the label on screen. Unchecked rows stay in the list. The file stays in this browser. There is no account.

1. Open https://app.mylabelmaker.com/?template=avery-5160-label. No signup.
2. The label is already 2.63 x 1 in. In Google Sheets choose File, Share, Publish to the web, then CSV. A normal share link will not load. The first row is the column names.
3. Paste the published link and click the columns onto the label. A sample list is like Asha's 36 with Name, Street, and City, upload Excel or CSV, or paste a published Google Sheet.
4. Check the rows you want. Print this is the label on screen. Print is the checked rows.
5. Print from this computer on any inkjet or laser that prints US Letter. In the print box, pick US Letter and leave scaling off so the words stay on the labels.

The other Avery sizes are on the Avery labels page. Open the number that matches the box in your hand. Check a short name and a long one, like Noah Ellis, 14 Pine Ave, Boise, before you print the rest of the 36.

Questions people ask

How do I print Avery 5160 address labels from Google Sheets?

Open the Avery 5160 address label template (2.63 x 1 in). Edit it or load your list, and print. No signup. Print from this computer on any inkjet or laser that prints US Letter. In the print box, pick US Letter and leave scaling off so the words stay on the labels.

Do I need an account?

No. Open the label, edit it, and print. You do not pay to download it. A published Google Sheet is fetched from Google. The label itself stays in this browser.

Does a spreadsheet fill every label on a page?

A spreadsheet prints one label per row. It does not fill every cell of an Avery 5160 sheet by itself. The sheet template is the letter page you edit.