Wall of Tools

Address Labels from Excel: Print Avery Labels from a Spreadsheet

Paste rows from Excel or open a spreadsheet and get a PDF laid out for Avery 5160, L7160 and other label sheets, ready to print. Your contacts stay on your computer.

  • Runs in your browser, nothing is uploaded
  • Free, no sign-up
  • 32 automated checks

Print at 100% or Actual size, not "Fit to page", or the labels will drift.

Print address labels from a spreadsheet

Sending wedding invitations, holiday cards, a mailing to customers or parcels from a small shop? If the addresses are already in Excel or Google Sheets, there is no need to wrestle with a word processor's mail merge. Paste the rows or open the file here, choose your label sheet, and download a PDF that lines up with the labels, ready to print. The preview is the PDF itself, so what you see is what will print.

The spreadsheet is read in your browser and never uploaded: a contact list is personal data, and it stays on your computer.

How to use it

  1. Get the addresses in. Open an xlsx, xls or csv file, or copy the cells in Excel or Google Sheets, including the heading row, and paste them.
  2. Check what goes on each label. The tool guesses from the column names (name, company, address, city, state, postcode, country). Edit the layout freely and click a column name to add it.
  3. Choose your label sheet. The code is printed on the label box, such as Avery 5160 or L7160.
  4. Using a part-used sheet? Set "Start at label number" to the first empty label, counting across and then down.
  5. Download the PDF and print it at 100% (Actual size). Do a test print on plain paper first, with outlines turned on, and hold it against a label sheet to the light.

Supported label sheets

  • US Letter: Avery 5160 and the many sheets that match it (30 per sheet, 1 x 2-5/8 inches), 5162 (14 per sheet, 1-1/3 x 4 inches) and 5163 (10 per sheet, 2 x 4 inches).
  • A4: Avery L7160 (21 per sheet, 63.5 x 38.1 mm), L7161 (18 per sheet), L7163 (14 per sheet, 99.1 x 38.1 mm) and L7173 (10 per sheet).

Other brands often sell the same layouts and print the matching Avery code on the box.

Good to know

  • Long addresses shrink to fit, down to 6 points, and the tool tells you if any were still too long so you can shorten them.
  • Letters and symbols: the PDF uses a standard font that covers English and Western European letters, including accents. Other alphabets show as "?" and the tool warns you.
  • Printers differ by a millimetre or two. If everything is shifted the same way, check that scaling is off; most printers also have a small margin they cannot print in.

How this tool was tested

Before publishing, I ran 32 automated checks on the finished page in Microsoft Edge, which is built on Chromium like Chrome. Last full run: 15 November 2026.

  • Label sheets: the sizes and positions match Avery's published measurements (for example 5160: 30 labels of 2-5/8 x 1 inch, the first 3/16 inch from the left and 1/2 inch from the top; L7160: 21 labels of 63.5 x 38.1 mm), and on every sheet the labels stay on the page and never overlap.
  • The PDF, read back with pdf.js: each address sits inside its label box, across and then down; "start at label 8" uses the 3rd row, 2nd column; 35 labels fill a second sheet; a long address shrinks until every line fits inside the label; an address too long even at 6 points is reported.
  • Columns: the layout is guessed from US and UK style column names, empty lines are dropped without stray commas, and quoted cells with line breaks are read correctly.
  • Using the tool: the sample, opening an xlsx file, editing the layout, adding a column, choosing an A4 sheet, the download and an empty list.

What the tests did not cover: Printing on real label sheets was not tested: printers differ by a millimetre or two, which is why the page suggests a test print. Safari and Firefox were not tested. Something not working? Tell me on the contact page.

FAQ

Can I print return address labels, all the same?

Yes. Paste one heading row and one address, then copy that row as many times as you need labels, or type the address straight into the layout box without any column names.

Does it work with Word labels?

You do not need Word: the PDF is laid out for the sheet. Print it from any PDF viewer.

Can I make barcodes or name badges?

This tool prints text. For barcodes, use the barcode generator.

Published 16 November 2026