Address labels

Add your address list, check the first label, then print.

Address labels from your own list

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.

  1. Press Upload a file and choose your Excel workbook. CSV, Numbers and OpenDocument files work too.

  2. 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.

  3. Pick your label paper, for example 1 × 2⅝ in, 30 per sheet (compatible with Avery® 5160).

  4. 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.

Christmas card address labels from your list

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.

Suggestions and feedback

What would make EncodeLabel better, or what isn’t working? It goes straight to the people who run the site.

Only if you’d like a reply.

We use your email only to reply to you. Please don’t include passwords or private details. Privacy Policy

Add EncodeLabel to your Home Screen

One tap to your labels, like an app, with nothing to download from an app store.