Use the Print button on the page for exact-size labels.
Address labels
Add your address list, check the first label, then print.
Part of this page could not load. Check your connection and load the page again.
Address labels from your own list
- Your list stays with you. An Excel, CSV or Numbers file, or rows you paste, are read in your browser. Nothing is uploaded unless you log in and save it.
- ZIP codes come back whole. Spreadsheets drop the zero from 07030. We put it back where the state proves it, and tell you how many we fixed.
- Long addresses still fit. Empty lines close up, and a long address is made smaller until it fits. Any that still don’t fit are listed by row before you print.
- A small QR code if you like. The same link on every label, or a different one from a column of your list. Check that it scans before you print a big batch.
Free for up to 100 labels a month. No account needed. Printing the same labels again within a day doesn’t count twice.
From Excel without mail merge
No Word and no mail merge: open your list here and the labels are laid out for you.
Press Upload a file and choose your Excel workbook. CSV, Numbers and OpenDocument files work too.
Check the first label. We match your columns to the parts of an address: name (one column, or first and last), company, street, city, state and ZIP. If one is wrong, change it under Which column is which.
Pick your label paper, for example 1 × 2⅝ in, 30 per sheet (compatible with Avery® 5160).
Print, or download a PDF. Print the alignment test page on plain paper first and hold it against a sheet of labels.
Print address labels from Excel without mail merge: the full guide
From Google Sheets or Numbers
In Google Sheets, select your rows with the heading row on top, copy them, then press Paste from a spreadsheet here. You can also download the sheet as a Microsoft Excel or CSV file (File, then Download) and upload that.
A Numbers file from a Mac can be uploaded as it is. If it doesn’t open, export it from Numbers as Excel or CSV (File, then Export To) and upload that instead.
Return address labels (one address on a whole sheet)
Press Type them in and type just your own address. With one address, Print fills the whole sheet with it, so a sheet of return address labels takes a minute. Small labels suit this best, such as ½ × 1¾ in, 80 per sheet (compatible with Avery® 5167).
Holiday cards
Keep one list for every year, with each name written the way it should go on the envelope, such as “The Garcia family”. Open it here each December, check the first few labels and print. If a sheet is part-used from last year, set Start at label to the first empty one.
To keep the list ready for next year, keep the spreadsheet on your computer, or log in and save it as a datalist.
Questions
- Why did my ZIP codes lose their first 0?
- Spreadsheets treat a ZIP code as a number and drop the zero in front, so 07030 becomes 7030. We put the zero back wherever the state shows it belongs, and tell you how many we fixed. To stop it happening in the first place, format the ZIP column as Text in your spreadsheet before you type into it.
- What if a name or address is too long for the label?
- With Fit automatically on, empty lines close up and a long address is made smaller until it fits. Any that still don’t fit are listed by row before you print, so you can shorten them or pick a bigger label.
- Can I print international addresses?
- Yes. Give your list a Country column and leave Show the country line on. For most of Europe the postcode goes before the town (01067 Dresden): we set Postcode before the town to suit your list when you add it, and you can change it. Postal services prefer capitals, so ALL CAPS is there too.
- Is my list uploaded?
- No. When you open a spreadsheet or CSV file, your browser reads it. The file, and the names and addresses in it, are not uploaded to us. Your list only reaches us if you log in and press Save. The Privacy Policy says the same.
- Which label paper should I use?
- Most address labels are 1 × 2⅝ in, 30 per sheet. For bigger, easier-to-read labels use 1 × 4 in, 20 per sheet, and for parcels 2 × 4 in, 10 per sheet. On A4 paper the usual one is 63.5 × 38.1 mm, 21 per sheet (compatible with Avery® L7160). All the others are in the label paper list.