Open your address list or drop it here
Excel (.xlsx, .xls), .ods or .csv — read in your browser, never uploadedMatch the columns
Open a file above, or paste rows from Excel or Google Sheets here. You can still change any address by hand.
Making the PDF…
About address labels from Excel
Have your addresses in a spreadsheet — a wedding guest list, a Christmas card list, club members or customers? Open the file here and print it on a sheet of sticky address labels. No mail merge, no Word, no add-on.
Open an Excel file (.xlsx or .xls), an .ods or a .csv, or paste the rows straight from Excel or Google Sheets. The tool finds the name, street, city, state and ZIP columns by itself; you can change the match in a second. Then pick your label sheet and print. It works with common 30-per-sheet address labels (1 × 2⅝ in, 3 across and 10 down on US Letter) and nine other sheet sizes.
Your list is read in your browser and is never uploaded.
Features
- Open .xlsx, .xls, .ods or .csv — or paste rows from Excel or Google Sheets; a file with several sheets lets you pick one
- Column matching — name (or first and last name), company, street, address line 2, city, state, ZIP and country, found from the column names or from the data
- US address format — "Springfield, IL 62704" on the last line, and ZIP codes that lost their first 0 in Excel get it back
- 10 label sheets — 30, 20, 10, 6 or 80 per US Letter sheet, 21, 18, 14, 8 or 65 per A4 sheet, or your own size
- 5 styles — classic, framed, a colour bar, modern, or the name in calligraphy, in 6 accent colours
- Skip used labels on a half-used sheet, print copies of each label, and move the print to fit your printer
- Close-up of one label with a PNG download, and the whole PDF to print or download
What your spreadsheet should look like
One row per address, one column per part. The first row can hold the column names:
| Name | Street | City | State | ZIP |
|---|---|---|---|---|
| Jane Smith | 12 Oak Street | Springfield | IL | 62704 |
| Carlos Diaz | 45 Maple Avenue, Apt 3 | Portland | OR | 97205 |
Each row becomes one label:
- Jane Smith
- 12 Oak Street
- Springfield, IL 62704
First and last names in two columns are joined ("Jane" + "Smith"). An "Address 2" column (apartment or suite) gets its own line. Empty cells are left out, so a label never has a blank line.
Column names the tool knows
| Part of the address | Column names it finds by itself |
|---|---|
| Name | Name, Full Name, First Name, Guest, Recipient, Contact |
| Last name | Last Name, Surname, Family Name |
| Company | Company, Organization, Business |
| Street | Address, Street, Address 1, Street Address, Mailing Address |
| Address line 2 | Address 2, Apt, Suite, Unit |
| City | City, Town |
| State | State, Province, Region |
| ZIP code | ZIP, ZIP Code, Postal Code, Postcode |
| Country | Country |
No column names? The tool looks at the data instead: 5-digit numbers are ZIP codes, two capital letters are states, and text that starts with a house number is the street. Check the Match the columns boxes once, and change any that are wrong.
How many label sheets?
The common address label sheet holds 30 labels (3 across, 10 down, each 1 × 2⅝ in).
| Addresses | Sheets of 30 | Free labels on the last sheet |
|---|---|---|
| 45 | 2 | 15 |
| 100 | 4 | 20 |
| 150 | 5 | 0 |
| 250 | 9 | 20 |
Next time, put the half-used sheet back in the printer and set Skip labels already used to the number of used labels.
Label styles
- Classic — plain black text, the first line in bold. Best for business mail.
- Framed — a thin rounded border inside each label.
- Colour bar — a coloured strip down the left side.
- Modern — the name in capitals with a thin line under it.
- Script — the name in flowing calligraphy, the address in clear print. Lovely for wedding invitations and Christmas cards.
The accent colour (navy, black, green, burgundy, pink or gold) colours the border, the bar, the line or the script name. The address itself always prints in black, so it stays easy to read.
Frequently asked questions
Is this the same as a mail merge in Word?
It does the same job — one label per row of your list — without Word. Open the file, check the columns, and print. Nothing to install.
Do I need Excel?
No. Any spreadsheet works: save it as .xlsx or .csv from Google Sheets, Numbers or LibreOffice, or copy the rows and paste them into the address box.
My ZIP codes lost the first zero. What can I do?
Excel often turns 02134 into 2134. The tool adds the missing 0 back to 3- and 4-digit ZIP codes (only when the country is empty or the US).
Can I change one address before printing?
Yes. The addresses are written into the box under the file, one label each. Change, add or delete any of them there. If you change the column matching later, the box is filled again from the file.
Which labels should I buy?
Any brand of 30-per-sheet address labels, 1 × 2⅝ inches on US Letter works with the first sheet in the list. For other sizes, check the label size and the number per sheet on the box.
Is my address list uploaded?
No. The file is read in your browser, and the PDF is made on your device. Only your settings (label sheet, style, colour) are saved in this browser — never the addresses.
Related tools
- Address Label Maker — type addresses by hand, or print one return address on a whole sheet
- Print Envelope — print the addresses straight onto envelopes
- Remove Duplicate Rows — clean double addresses out of the list first
- Excel to CSV — save a sheet as CSV
- Wedding Invitation Maker — the invitations that go into the envelopes
- Thank You Card Maker — thank-you cards for your guests
How to use it
- Press Open your address list and pick your .xlsx, .xls, .ods or .csv file — or paste rows into the address box
- Check Match the columns: name, street, city, state and ZIP
- Choose your label sheet — 30 per sheet is the common address label
- Pick a style and an accent colour if you like
- Make a test print on plain paper with the outlines on, and hold it against a label sheet
- Put in the label sheet and press Print, or Download PDF
