Print Avery labels from Excel or Google Sheets

You can fill a whole Avery sheet from a spreadsheet, with a different address on every sticker: 30 per page on 5160, 10 per sheet on 5163, 6 per page shipping labels on 5164, or 80 tiny ones on 5167. Upload your Excel file or CSV, or bring in a Google Sheet, check the sheet on screen, and print a plain-paper proof before the real labels go in. No signup.

How it works

Every row in your spreadsheet becomes a label

sample-products.csv5 rows

	A	B	C
1	SKU	Product	Variant
2	00123	Linen tea towel	Natural
3	00124	Linen tea towel	Sage
4	A-203	Stoneware mug	Ash
5	A-204	Stoneware mug	Moss
6	A-205	Stoneware mug	Clay

5 rows5 labels

Fill an Avery sheet

Open a 5160 sheet with five sample addresses, then upload your own list.

Fill an Avery sheet →

Different addresses on one sheet, not a roll

A thermal roll prints one label per row, one after another. A sheet is different. All 30 stickers come out of the printer on one page at once, so each sticker has to know which row of your list it belongs to. That's what the sheet templates here are built for.

Here is the fictional mailing list behind the 5160 example. The names and addresses are made up:

Five rows fill the first five stickers of the 30. The other 25 stay blank, because there is nothing for them to read. Keep those for the next batch, or add more rows to your list until the sheet is full.

Avery sheet examples you can open

These are real renders of whole US Letter sheets from the editor. Each card opens that sheet with its sample list loaded. All the data is fictional.

Avery 5160 sheet, 30 per pageUS Letter, 30 labels of 2.63 x 1 in. Five addresses fill the first five; the rest stay blank. Avery 5163 sheet, 10 per pageUS Letter, 10 labels of 4 x 2 in. Five orders: name, address, order number and its barcode. Avery 5164 sheet, 6 per pageUS Letter, 6 labels of 4 x 3.33 in. Name, address, order and its barcode. Avery 5167 sheet, 80 per pageUS Letter, 80 labels of 1.75 x 0.5 in. One Name column, four stickers per name.

Match your Avery stock: 5160, 5163, 5164 or 5167

The number on the Avery box is the layout. Pick the sheet that matches it:

• Avery 5160, 30 per page: 1 x 2⅝ inch address labels, three across and ten down. The classic for Christmas cards, invitations and return mail. Avery 5160 details. 8160 is the same layout for inkjet.
• Avery 5163, 10 per sheet: 2 x 4 inch labels with room for a name, an address and an order barcode. Avery 5163 details.
• Avery 5164, 6 per page: 4 x 3⅓ inch shipping-size labels for boxes and padded mailers when you don't have a thermal printer.
• Avery 5167, 80 per sheet: ½ x 1¾ inch return-address and name stickers. The example puts four stickers per name. Avery 5167 details.

Looking for Avery 5168? This editor has no 5168 template, so it can't lay out that sheet for you. The four above are the Avery whole sheets it fills from a list. All of them are US Letter. There are no A4 sheets here, and an A4 sheet has different spacing, so a Letter layout won't line up on it.

Only printing one address, or one label at a time? The single-label templates, like the 5160 label, open just one sticker on a small canvas. They're simpler for one-off labels, but for a list on a sheet use the whole-sheet versions shown here. The Avery templates page has both.

Bring your list from Excel, Google Sheets or CSV

• Excel: click Data, then Upload, and pick the .xlsx, .xls or .xlsm file. See printing labels from Excel.
• CSV: upload it the same way. Contact exports from your email or address book usually come out as CSV. See printing labels from a CSV.
• Google Sheets: to print Avery labels from Google Sheets, the Google Sheet tab takes a sheet published as CSV. An address list is personal, so the better route is File > Download > Comma-separated values in Google Sheets, then upload that file. More on Google Sheets labels.

Put the column names in the first row and keep one address per row. ZIP codes that start with 0 need the column formatted as Text in Excel, or 02134 turns into 2134.

Connect your address columns to the sheet's stickers

On a sheet, the layout mode is One sheet ("Many labels on page"). Instead of one label per row, each sticker holds a cell token that points at one cell of your list. On the 5160 sample, the first sticker's name reads {{Name}}{1}{1}: the Name column, row 1, column 1. The sixth sticker reads row 6.

1. Open https://app.mylabelmaker.com with the 5160 sample. The five addresses above are already on the first five stickers. No signup.
2. Click Data and upload your own list. Use the same three columns in the same order (Name, Street, City), and the stickers read your rows instead. If Data shows Each row, choose One sheet.
3. To change what a sticker shows, click its text box, then click Place data under the label. A small table of your list opens.
4. Click the cell you want, then Add to label, and the text box you selected gets that cell. Double-clicking a cell places it straight away. A row number picks every cell in that row, and the editor adds one text box per cell next to the one you selected.
5. Look over the whole sheet on screen. Stickers that point past the end of your list stay blank.

The 5163 and 5164 samples work the same way with four columns: Name, Street, City and Order. Each sticker keeps its printed heading ("Ship to" on the 5163, "Packing label" on the 5164) and adds the order number with its barcode. They are address and packing labels, not postage. For more on address lists in general, see mail merge labels.

What prints, and what stays blank

On a sheet, the stickers decide what prints. A row of your list prints if a sticker points at it. On the 5160 that's rows 1 to 30. Row 31 has no sticker, so a 45-address list needs a second sheet: save the rows after 30 as their own file and load it once the first sheet is printed.

Partly used sheet? The editor has no setting to start at a later sticker, so it always prints from the first position. Feed it full sheets when you print a list.

With This computer chosen, Print sends the whole sheet straight to your computer's print dialog, and you set copies there. Each copy is another full sheet with the same stickers, so 3 copies prints the same 30 addresses on three pages. That's handy for 5167 return-address stickers. For a mailing list you usually want 1.

Print a plain-paper proof at 100%

1. In the top bar, choose This computer, then click Print.
2. In your computer's print dialog, set the paper to US Letter and the scale to 100% or Actual size. Turn off Fit to page. Fitting shrinks the whole sheet a little, and by the bottom row the text has drifted off the stickers.
3. Print on plain paper first. Hold it against a label sheet in front of a window or a lamp and check the top row and the bottom row.
4. If it lines up, load the Avery sheet the right way up for your printer and print again.

Sending holiday cards? The Christmas address labels page has festive 5160, 5163 and 5167 address labels for your card list.