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
Batch
1 file per run
1 file per run. Only use one run when files share the same operation.
Move into a related operation instead of re-finding the tool.
Download a destination-ready result and verify it before sharing.
Configured runtime limit applies.
Natural next steps
Continue with a related tool using the same file workflow.
CSV, TSV, TXT, XLSX, VCF
Process one source at a time
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.
Continue with Invoice Generator
Finish the job after Address Label Maker with a relevant MAXScanner tool, without creating a duplicate converter page.
- Address Label Maker
- Invoice GeneratorWorkflow-ready
Best when Address Label Maker is only the first step in your workflow.
Continue with Barcode Generator
Bulk-readyFinish the job after Address Label Maker with a relevant MAXScanner tool, without creating a duplicate converter page.
- Address Label Maker
- Barcode GeneratorBulk processing · ZIP-ready output · Workflow-ready
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 sheet | Printed on the label | Font size |
|---|---|---|
| Ana Ruiz · 12 Elm St Apt 4 · Austin · TX · 78702 · USA | Ana Ruiz / 12 Elm St Apt 4 / Austin TX 78702 | 12 pt |
| Walter Brown · 49 Featherstone Street · London · EC1Y 8SY · United Kingdom | Walter Brown / 49 Featherstone Street / LONDON / EC1Y 8SY / UNITED KINGDOM | 10 pt |
| Lena Vogel · Vogel & Partner · Wacholderweg 52a · Oldenburg · 26133 · Germany | Lena Vogel / Vogel & Partner / Wacholderweg 52a / 26133 Oldenburg / GERMANY | 10 pt |
| 田中 太郎 · 白山4-3-2 · ハイツ白山101 · 文京区 · 東京都 · 112-0001 · Japan | 〒112-0001 / 東京都文京区白山4-3-2 / ハイツ白山101 / 田中 太郎 / JAPAN | 10 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
| Sheet | Paper | Labels per sheet | Label size | Typical use |
|---|---|---|---|---|
| Avery 5160 / 8160 | US Letter | 30 (3 × 10) | 1" × 2-5/8" (25.4 × 66.7 mm) | Holiday cards, invitations, return addresses |
| Avery 5161 | US Letter | 20 (2 × 10) | 1" × 4" | Longer addresses on one line each |
| Avery 5162 | US Letter | 14 (2 × 7) | 1-1/3" × 4" | Addresses with a company line |
| Avery 5163 | US Letter | 10 (2 × 5) | 2" × 4" | Parcels and large envelopes |
| Avery 5164 / 8164 | US Letter | 6 (2 × 3) | 3-1/3" × 4" | Boxes, with room for a return address |
| Avery 5167 | US Letter | 80 (4 × 20) | 1/2" × 1-3/4" | Small return-address labels |
| Avery L7160 / J8160 | A4 | 21 (3 × 7) | 63.5 × 38.1 mm | The usual A4 address label |
| Avery L7159 / J8159 | A4 | 24 (3 × 8) | 63.5 × 33.9 mm | Address labels, 24 per sheet |
| Avery L7163 / J8163 | A4 | 14 (2 × 7) | 99.1 × 38.1 mm | Parcel and longer addresses |
| Avery L7173 / J8173 | A4 | 10 (2 × 5) | 99.1 × 57 mm | Parcels |
| Avery L7654 | A4 | 40 (4 × 10) | 45.7 × 25.4 mm | Return addresses |
| Avery L7651 / J8651 | A4 | 65 (5 × 13) | 38.1 × 21.2 mm | Tiny 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:
| Destination | Last lines of the address |
|---|---|
| United States, Canada, Australia | City, state or province and ZIP or postcode on one line: Austin TX 78702 |
| United Kingdom, Ireland | Post town in capitals, then the postcode on its own line: LONDON / EC1Y 8SY |
| Germany, Austria, Switzerland, Netherlands | Postcode before the town: 26133 Oldenburg |
| France, Italy | Apartment 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
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.
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.
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.
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.