Print address labels from a spreadsheet

Export your sheet as CSV, drop it here, pick your Avery label size and download a print-ready PDF. Text shrinks to fit each label, and an alignment test page lets you check the print before you use real label paper.

Everything runs in your browser. Your text and files stay on your device and are never uploaded.

No rows yet.

Add a CSV to see how many sheets you need.

How to use it

  1. In Google Sheets or Excel, use File, Download, Comma-separated values (.csv). Keep column names in the first row.
  2. Choose the CSV file here, or paste its text. Use Load example to see how it works first.
  3. Check the label layout. Name, address, city, state and zip columns are filled in for you. Edit it to add or remove lines, using column names in double braces.
  4. Pick the label sheet that matches the code on your box, such as 5160 or L7160.
  5. Print the alignment test page on plain paper and hold it against a label sheet to the light. Then download the PDF and print it at 100 percent scale, with page scaling off.

Questions

Which label sheets are supported?

Avery 5160 and 8160, 5161, 5162, 5163, 5164 and 5167 for US Letter, plus Avery L7160 and L7163 for A4. Look-alike sheets from other brands that share the same size and count, such as many Office Depot and Amazon Basics packs, use the same layout.

Why do my labels print slightly off the edge?

Printers scale pages by default. Set the print dialog to Actual size or 100 percent, turn off Fit to page, and print the alignment test page first. If it is still shifted, your printer has a margin offset that you can correct in its settings.

How do I start on a partly used sheet?

Enter the number of labels already used in Skip used labels. Labels fill left to right, then down, so a sheet with the first two rows gone on a 3-column layout means skipping 6.

Can I print the same label more than once?

Yes. Set Copies each and every row is repeated that many times in a row, which suits return address labels or one label per attendee.

What happens to accented or non-Latin letters?

Western European letters such as é, ñ and ü print correctly, and so do curly quotes and the euro sign. Letters outside that set, like Chinese or Cyrillic text, show as a question mark, because the PDF uses the standard Helvetica font that every PDF reader already has.

Are my addresses uploaded anywhere?

No. The file is read and the PDF is built in your browser, and nothing is sent to a server.

More free tools

All free tools