Address Labels

Turn a contact list into printed address labels in minutes — free mailing and return address label templates with mail merge from a spreadsheet.

Picked for Letter paper · Start at the first free label on a partly used sheet.

My sheet isn’t listed

Address preset

Mailing labels use 4–5 lines; return labels are compact for a corner or the back of an envelope.

Label text
Logo, barcode and border
Mail merge list

Numbered labels
Alignment fix

Measure the printed test page, then nudge until the outlines sit inside the labels.

Your text and lists stay in this browser. Nothing is uploaded.

Sheet preview

Page 1 / 1

Ready

Print at 100 % (Actual size) — never “Fit to page”. Hold the test print against a label sheet before a large run.

How to print address labels from a list

Open the Mailing labels tab and paste the cells from Excel, Google Sheets or another spreadsheet. Include the header row so the tool can identify columns, or upload a CSV file. The preview shows a sample label and the mapping between each column and each printed line.

Check the mapping before anything else. A list with “Name”, “Street”, “City”, “State” and “ZIP” usually maps correctly, but exported files sometimes use headings such as “Address Line 1” or “Postal Code”. Correct any column that points at the wrong line, and confirm that the ZIP column is the one holding the postal code rather than a phone number.

Untick rows you do not want to print. The row picker supports a search across all cells and a range such as rows 10 to 40. The counter tells you exactly how many labels will be printed. You can also sort by last name or ZIP/postcode without changing the original order of the list.

Run a test print on plain paper at 100 percent. Place it over a real label sheet at a window and check the first and last labels. If the alignment is good, download the PDF for the whole run. If one edge is consistently off, use the nudge; if the error grows across the page, the printer is scaling the PDF.

Return address labels vs mailing labels

A return address label is your own address, repeated on every label. It normally sits in the top-left corner of an envelope or parcel, and its job is to bring the item back if delivery fails. Return labels are usually smaller and may be centred, because they do not need to be read by a sorting machine from across a room.

A mailing label carries the recipient’s address, one per label. It sits in the centre of the envelope and needs a clear margin around it. Mailing labels are usually left-aligned, use a plain sans-serif font, and keep the city, state and ZIP on the same line.

The two jobs are different enough that this page has separate tabs. The Mailing tab starts with mail merge open. The Return tab starts with three empty lines and the same design repeated across the sheet.

Add a logo or small picture to return labels

A small logo can make a return label look finished, especially for a business. Place it to the left of the text and keep it modest: the address still needs to be readable at a glance. Very detailed artwork may become muddy at return-label size, so use a simple mark and test it on paper.

Avery® is a registered trademark of its owner. PrintableMate is not affiliated with or endorsed by Avery.

Getting your list out of Excel, Google Sheets or a phone

The most reliable layout is one person per row, with a header row at the top. Put the full name in one cell, or use separate first and last name columns. Keep the street address, city, state, postal code and country in their own columns. Avoid merging cells, because a merged range does not export as clean rows.

Copying and pasting usually preserves the columns. If you save a file instead, choose CSV. A UTF-8 CSV keeps accented characters such as é intact; other CSV encodings are read as Western (Windows-1252), and the tool says which encoding it used. A name that looks right in Excel can become a question mark in a PDF if the file is saved in the wrong encoding.

Phone contact apps often export a CSV with names and addresses, but the headings vary. Map the columns manually if the automatic match misses one. Delete empty rows and rows for people who have asked not to be mailed before printing.

Address formats that sort well

USPS address guidelines favour a uniform left margin, a readable typeface and no punctuation that is not needed for delivery. Uppercase letters are acceptable, and omitting periods and commas can make the address easier for sorting equipment to read. The ZIP+4 hyphen is the exception; keep it when you have a ZIP+4 code.

A US address usually looks like this:

JANE DOE
12 OAK ST APT 4
PORTLAND OR 97201-1234

Mixed case and punctuation are still delivered, so USPS style is optional. It is most useful on large mailings where consistency helps. The tool can convert a pasted address to uppercase and remove common punctuation without changing the underlying list.

In the UK, the post town is conventionally written in capitals and the postcode sits on its own line. The tool also adds the spacing inside a UK postcode, so sw1a1aa becomes SW1A 1AA. Much of Europe writes the postcode before the town or city. The address format selector changes the line order, and the country line is added last when the address is outside your own country.

Fonts and text size

Use a plain sans-serif font for mailing labels. Eight points is a practical minimum for an address that will be read by hand; smaller type may pass a test print and still be difficult at arm’s length. Dark text on a white or very light label gives the best contrast.

Script fonts can suit return labels, but they are a poor choice for the delivery address. Thin strokes and touching letters are harder for sorting machines and for people in a hurry. If you use a script face, test it at the actual print size before committing to a large run.

Holiday cards, invitations and business mailings

December is the busiest time for address labels, and a list that worked in June may have moved house since. Check the list before printing, remove duplicates, and keep a separate column for households that should receive one card rather than two. A shared surname at one address is usually one envelope.

For weddings and events, address the invitation to the household rather than to each invited person. “Mr and Mrs Lee” belongs in one name cell. For business mailings, add a company line and use a consistent format; a logo on the return label can help the envelope look deliberate.

If you are printing envelopes rather than labels, use the envelope workflow instead. Labels are best when the envelope surface is textured, when you already own label sheets, or when you want to hand-address the envelope and add only a return label.

Line it up perfectly

A plain-paper test print is the cheapest alignment check. Print the sheet at 100 percent, hold it against a window with the label sheet behind it, and look at the outlines. The corners should sit inside the die-cuts. If the whole grid is shifted, adjust the nudge. If the spacing between labels is wrong, the selected sheet does not match the packet.

A common failure is “Fit to page”. It can shrink the sheet by several percent, which is invisible in a preview but obvious at the bottom of the page. Choose Actual size in the print dialog and make sure the paper size is Letter or A4 as appropriate.

For 30-per-sheet Letter labels, the 5160 template page gives exact measurements and a comparison tool for store-brand packs. The layout there is compatible with Avery® 5160 sheets; it is not an official template from that brand.

Your list stays on your device

Pasted rows are parsed in the browser. They are not uploaded, logged or added to a URL automatically. The list is saved only if you tick Remember this list, and Clear list removes it. Closing the tab without saving discards the rows.

A share link normally carries design settings only. If you choose to share a link with the list, the page warns that the link contains addresses and marks it as personal data. Treat that link like the list itself: send it only to someone who is allowed to see the addresses.

Small choices that prevent reprints

Use the row picker to exclude people who should not receive this mailing. Remove duplicates before printing rather than after, because duplicate labels are easy to miss once they are on a sheet. Keep a plain-paper test for a new pack of labels, even if the previous pack worked.

Check the smallest text on the sheet. If a long company name forces the address below 8 points, shorten the line or choose a larger label. A label that fits but cannot be read is not a successful print.

Updated:

Frequently asked questions

How can I print my own address labels for free?

Choose a label sheet, paste your list or type a return address, and download the PDF. Print it at 100 percent on the matching paper. There is no account, no watermark and no charge, and the list is processed in your browser.

How do I print address labels from Excel or Google Sheets?

Select the cells including the header row, copy them, and paste into the list box. Each row becomes one label. Check the column mapping, untick anyone you are not mailing, then run a test print before downloading the full sheet.

What is the proper format for an address label?

Put the name on the first line, the street address next, then the city, state and ZIP. Use a uniform left margin and a plain, readable font. Uppercase letters and no punctuation except the ZIP+4 hyphen are acceptable under USPS guidelines, but mixed case is also delivered.

What size are address labels?

Common sizes include 1 × 2-5/8 inches, 1 × 4 inches, 1-1/3 × 4 inches and 2 × 4 inches on Letter sheets, plus 63.5 × 38.1 mm and 99.1 × 38.1 mm on A4. There is no single required size for mail; choose one that leaves the delivery address clear of the envelope edges.

What size label fits a 5×7 envelope?

A 1 × 2-5/8 inch or 1 × 4 inch label fits comfortably on a 7 inch wide face. Use 2 × 4 inches when the address needs larger text or when the envelope will be handled roughly. Keep the label inside the clear area, away from the stamp and edges.

What are return address labels, and how do I make them?

A return label carries your own address and goes in the top-left corner of the envelope. Open the Return tab, type your name, street and city line, choose a sheet, and print one full sheet. The same address repeats on every label, so it is quick to restock.

Where do address labels go on an envelope?

Put the return address in the top-left corner and the delivery address in the centre, with the stamp in the top-right. Keep the delivery address clear of the bottom edge and both side edges. USPS asks for at least 5/8 inch of clear space above the bottom edge and 1/2 inch at each side.

Is my address list uploaded?

No. Rows are parsed on your device and are not sent to a server or written to a log. They are saved only if you tick Remember this list. A share link can include rows only when you choose Share link with list, and that link is marked as containing personal data.