Part of Avery labels. The sizes and the other how-tos for that printer start on that page.

← Avery labels

Avery 5164 shipping sheet labels from Google Sheets

Published: · 3 min read · How-to
Open it and print: this Avery 5164 shipping sheet. No signup.

You can print Avery 5164 shipping sheet labels from Google Sheets in the browser. Open the Avery 5164 shipping sheet template. It is already 8.5 x 11 in. Change the words, or load a list, and print. No signup.

Good to know: 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. A spreadsheet here prints one label per row. This sheet is the letter page you edit. Excel does not drop a different address into every cell by itself.

How to print Avery 5164 shipping sheet 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. Luis already has 24 rows, is labeling a pantry of jars, with Flavor, Size, and Price. Row 2 might read Peach jam, 8 oz, 7.

Paste the published link, then click those columns onto Avery 5164 shipping sheet. The size is already 8.5 x 11 in. A view-only share link will not load, even if you can open it yourself.

One row becomes one Avery 5164 shipping sheet 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-5164-sheet. No signup.
  2. The label is already 8.5 x 11 in. Change the line that should differ, or click your column names onto it.
  3. If you have a list, like Luis's 24 with Flavor, Size, and Price, 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. A spreadsheet here prints one label per row. This sheet is the letter page you edit. Excel does not drop a different address into every cell by itself.

This template is the whole letter page (Six large packing labels, two across and three down). If you put a column on one spot, each row prints a page where that spot changes. The other spots stay as you designed them. A list does not fill every cell with a different row.

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 Peach jam, 8 oz, 7, before you print the rest of the 24.

Questions people ask

How do I print Avery 5164 shipping sheet labels from Google Sheets?

Open the Avery 5164 shipping sheet template (8.5 x 11 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. A spreadsheet here prints one label per row. This sheet is the letter page you edit. Excel does not drop a different address into every cell by itself.

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.

Open the Avery 5164 shipping sheet label

The size is already set. You change the words.

Open this label