Skip to main content

Find your next tool

Address Label Maker — Avery Labels from Excel

Print address labels from Excel, Google Sheets, CSV or phone contacts on Avery 5160, 5163, L7160 and other sheets. Each address in its country's order, start on a used sheet, test page. Free, nothing uploaded.

Loading only the code needed for this tool…

PDF conversion

Convert for the destination, not just the extension

The useful conversion is the one that matches the receiving workflow. Check page size, orientation, image clarity, text readability and the resulting file before replacing the source or submitting the PDF.

Input

.csv, .tsv, .txt, .xlsx

Output

PDF

Batch

1 file per run

Paste From SpreadsheetCsv Xlsx VcardColumn Auto DetectCountry Address OrderAvery And A4 SheetsFont Fit Per Label
Batch-aware

1 file per run. Only use one run when files share the same operation.

Workflow continuity

Move into a related operation instead of re-finding the tool.

Output-ready

Download a destination-ready result and verify it before sharing.

File limits

Configured runtime limit applies.

PDF quality check before download
Check page dimensions
Review text and images
Verify the output opens cleanly

Natural next steps

Continue with a related tool using the same file workflow.

Supported input

CSV, TSV, TXT, XLSX, VCF

Output

PDF

Single file

Process one source at a time

Keep your source

Review the result before sharing

Smart workflows

Finish the job, not just the file

Use the existing tool graph to continue into useful next steps. Bulk and output-packaging capabilities are surfaced automatically where the underlying tool supports them.

Workflow-ready

Continue with Invoice Generator

Finish the job after Address Label Maker with a relevant MAXScanner tool, without creating a duplicate converter page.

Output: Invoice Generator

Best when Address Label Maker is only the first step in your workflow.

Continue with Barcode Generator

Bulk-ready

Finish the job after Address Label Maker with a relevant MAXScanner tool, without creating a duplicate converter page.

  1. Address Label Maker
  2. Barcode Generator
Output: Barcode Generator

Best when Address Label Maker is only the first step in your workflow.

About This Tool

To print address labels, paste the rows from your spreadsheet (or open a CSV, Excel or contacts file), check that each column is matched to the right part of the address, pick the label sheet printed on your box, and select Download label PDF. Print the PDF at 100 % (Actual size) and every address lands on its label. Each address is laid out the way the destination's post office asks, the text is sized to fit each label, and you can start on a sheet that is already partly used. There is no account and no label limit, and your list is read by your browser: nothing is uploaded.

What we got from a real list

We pasted four addresses from a spreadsheet, sending from the United States, and printed them on Avery 5160 (30 labels of 1" × 2-5/8" on US Letter):

Row in the sheetPrinted on the labelFont size
Ana Ruiz · 12 Elm St Apt 4 · Austin · TX · 78702 · USAAna Ruiz / 12 Elm St Apt 4 / Austin TX 7870212 pt
Walter Brown · 49 Featherstone Street · London · EC1Y 8SY · United KingdomWalter Brown / 49 Featherstone Street / LONDON / EC1Y 8SY / UNITED KINGDOM10 pt
Lena Vogel · Vogel & Partner · Wacholderweg 52a · Oldenburg · 26133 · GermanyLena Vogel / Vogel & Partner / Wacholderweg 52a / 26133 Oldenburg / GERMANY10 pt
田中 太郎 · 白山4-3-2 · ハイツ白山101 · 文京区 · 東京都 · 112-0001 · Japan〒112-0001 / 東京都文京区白山4-3-2 / ハイツ白山101 / 田中 太郎 / JAPAN10 pt

The US address needs no country line because it stays in the country. The five-line labels drop to 10 pt so every line fits the 1-inch height. The PDF was 4.7 KB; the Japanese characters are embedded from the Noto font, only the ones used. A list of 300 US addresses filled 10 sheets of 5160 in a 21.9 KB PDF, built in about a tenth of a second in our test.

Label sheets you can print on

SheetPaperLabels per sheetLabel sizeTypical use
Avery 5160 / 8160US Letter30 (3 × 10)1" × 2-5/8" (25.4 × 66.7 mm)Holiday cards, invitations, return addresses
Avery 5161US Letter20 (2 × 10)1" × 4"Longer addresses on one line each
Avery 5162US Letter14 (2 × 7)1-1/3" × 4"Addresses with a company line
Avery 5163US Letter10 (2 × 5)2" × 4"Parcels and large envelopes
Avery 5164 / 8164US Letter6 (2 × 3)3-1/3" × 4"Boxes, with room for a return address
Avery 5167US Letter80 (4 × 20)1/2" × 1-3/4"Small return-address labels
Avery L7160 / J8160A421 (3 × 7)63.5 × 38.1 mmThe usual A4 address label
Avery L7159 / J8159A424 (3 × 8)63.5 × 33.9 mmAddress labels, 24 per sheet
Avery L7163 / J8163A414 (2 × 7)99.1 × 38.1 mmParcel and longer addresses
Avery L7173 / J8173A410 (2 × 5)99.1 × 57 mmParcels
Avery L7654A440 (4 × 10)45.7 × 25.4 mmReturn addresses
Avery L7651 / J8651A465 (5 × 13)38.1 × 21.2 mmTiny return-address labels

Sheets from other makers with the same layout work too: check that the label size and the number of labels per sheet match the box. The positions come from the makers' published label sizes and spacing.

Each address in its country's order

Countries do not write addresses the same way, and a postcode in the wrong place slows sorting. The page follows the address format each national post publishes through the Universal Postal Union. A few examples:

DestinationLast lines of the address
United States, Canada, AustraliaCity, state or province and ZIP or postcode on one line: Austin TX 78702
United Kingdom, IrelandPost town in capitals, then the postcode on its own line: LONDON / EC1Y 8SY
Germany, Austria, Switzerland, NetherlandsPostcode before the town: 26133 Oldenburg
France, ItalyApartment or building above the street line; postcode before the town (Italy adds the province: 00144 ROMA RM)
Japan, China, Korea (in their own script)From the largest area to the smallest, postcode first and the name last: 〒112-0001 / 東京都文京区白山4-3-2 / 田中 太郎

Rows without a country are treated as the country you send from. When a row goes abroad, the country name is added in capital letters on the last line, as the UPU recommends. The full list of countries and their rules is in the tool's data, and countries without their own rule get a plain block: name, street, postcode and town, region.

Return address labels

Choose One address on every label, type the address with one line per row, and select Fill the sheet. On Avery 5167 that gives 80 labels; a three-line return address prints at 8.25 pt, which is as large as fits in half an inch.

If the print does not line up

  • Print at 100 %, Actual size or Scale 100. Fit to page shrinks the page by a few percent, so the lower rows drift off their labels.
  • Download the test page and print it on plain paper. Hold it against a label sheet in front of a window: the outlines should sit on the die cuts. The ruler in label 1 shows whether the printer scaled the page.
  • If everything sits a little to one side, enter the shift under Printer alignment (in mm, negative for left or up). The page remembers it on this device for next time.

When this is not the right tool

  • It does not buy postage or print carrier shipping labels with tracking barcodes. Use your carrier's own site for those.
  • It does not check that an address exists or correct it. Your list is printed as you typed it, in the right order.
  • Thermal label rolls (4" × 6" and the like) are not supported. Envelopes are: choose Envelopes under Print on, and each address prints straight onto a #10, A7, DL, C5 or other common size, one envelope per page.
  • Old Excel .xls files cannot be read: save them as .xlsx or CSV first. Bengali, Thai and Hebrew text cannot be printed in the PDF yet; the page tells you before you download.
  • Need a barcode or QR code on each label instead? Use the Barcode Generator or the QR Code Generator, which print on the same sheets.

How to Use

  1. Add your addresses

    Paste the rows from Excel, Google Sheets or Numbers, or open a CSV, .xlsx or .vcf contacts file. Choose One address on every label for return-address labels.

  2. Check the columns

    Each column is matched from its name (Name, Street, ZIP, Country…). Change any that are wrong and set columns you do not want printed to Don't print.

  3. Pick your label sheet

    Choose the code on your box, such as Avery 5160 or L7160. On a partly used sheet, tap the first free label on the sheet map.

  4. Download and print at 100 %

    Select Download label PDF and print at Actual size. Print the test page on plain paper first if you have not used this printer for labels before.

Use Cases

Holiday cards and invitations

A list of family and friends from a spreadsheet or your phone contacts, on 30-up sheets, with duplicates removed and addresses abroad given their country line.

Small shops and clubs

Order or member addresses from a CSV export, sorted by postcode for bulk mail, on larger parcel labels.

Return address labels

Your own address repeated on a full sheet of small labels, starting wherever the last sheet left off.

Frequently Asked Questions

How do I print address labels from an Excel list?+

Copy the rows in Excel (with the header row) and paste them into the box, or open the .xlsx file directly. Check that each column is matched, choose your label sheet and download the PDF. Print it at 100 % on the label sheet.

Which Avery template is used for address labels?+

Avery 5160 (and 8160, the same layout for inkjet printers) is the most common US address label: 30 per Letter sheet, 1" × 2-5/8". In A4 countries it is L7160 or J8160: 21 per sheet, 63.5 × 38.1 mm. Use the code printed on your box.

Why do my labels not line up when I print?+

Usually the print dialog scaled the page. Choose Actual size or 100 %, not Fit to page. If the print is still off by the same amount everywhere, print the test page and enter the shift under Printer alignment.

Can I use a sheet that already has some labels missing?+

Yes. Tap the first free label on the sheet map, or type its number in Start at label. Labels are counted left to right, then top to bottom; the following sheets start at label 1.

How should I write an address going abroad?+

In the destination's own order, with the country name in capitals on the last line. Turn on Country in your columns and the page does both: GERMANY under "26133 Oldenburg", UNITED KINGDOM under the postcode for the UK.

Are my addresses uploaded?+

No. The list and the PDF are processed by your browser on this device. Analytics record which button was used, never names, addresses or file names.