Guide

Print address labels from Excel without mail merge

Open your address list, check the first label, print. No Word document, no merge fields, and the list never leaves your computer.

Updated

Open address labels

Why mail merge feels fiddly

Word can print labels from an Excel list, but it takes a mail merge. Microsoft’s own instructions run to seven steps: start the Step-by-Step Mail Merge Wizard from the Mailings tab, choose Labels, pick the label vendor and product number, browse to your spreadsheet, add an Address block, press Update all labels, preview, and finally print (Microsoft: Print labels for your mailing list).

Each step is a chance for something to slip: the wrong label size, a field left out of the first label, or a ZIP code that lost its first zero. Microsoft’s checklist for the spreadsheet says the postal codes must be “correctly formatted” so Word can read them, but leaves the how to you (Microsoft: Create and print mailing labels for an address list in Excel).

The address labels tool does the same job in one screen. You add the list, it works out which column is which, and the preview shows every label as it will print.

Get the list ready

One row per address and one column per part works best. The first row should hold the column names. These are the parts the tool looks for, and the names it understands:

  • Name: “Name”, “Full name”, “Recipient” or “Ship to”. Or two columns, “First name” and “Last name”, which are joined with a space.
  • Company (optional): “Company”, “Organization” or “Business”.
  • Street: “Address”, “Address 1” or “Street”, and a second line in “Address 2”, “Apt” or “Suite”.
  • City, State and ZIP: “City” or “Town”, “State” or “Province”, “ZIP”, “ZIP code” or “Postal code”.
  • Country (optional): “Country”. You can hide this line on the labels.

Spanish, French and German column names are understood too. If a column is matched wrongly, open Which column is which under the first label and change it. Empty parts are skipped, so a missing second street line leaves no gap, and each label reads name, company, street, city, state and ZIP, then country.

ZIP codes that lost their first zero

ZIP codes in New England, New Jersey and a few other places begin with 0. A spreadsheet treats them as numbers and turns 07030 into 7030. When you add the list, the tool puts the zero back where the state on the same row proves it belongs, puts the hyphen back in a nine-digit ZIP+4, and tells you how many it fixed.

8.7E+11 instead of a long number

That is a spreadsheet shortening a long number to fit its cell. In the Excel file itself (.xlsx) the whole number is usually still there, and the tool reads it. In a CSV file saved that way the digits are gone, and nobody can get them back from the file. Format the column as Text in your spreadsheet, type the numbers again and save once more.

To stop both problems at the source: format the ZIP column as Text (“Plain text” in Google Sheets) before you type or paste into it.

Excel, CSV, Numbers or Google Sheets

The tool offers three ways in, plus typing addresses by hand:

  1. Upload a file

    An Excel file (.xlsx or .xls), a CSV file, a Numbers file or an OpenDocument spreadsheet. Files up to 15 MB and 20,000 rows are read.

  2. Paste from a spreadsheet

    Select the rows in Excel or Google Sheets, header row included, copy them, and paste. This is the quickest way from Google Sheets, with nothing to download.

  3. Try sample addresses

    Twenty made-up addresses, to see how it works before you use your own.

Once the list is in, you see the first label and can step through the others with the arrows under it. Long addresses are made smaller until they fit, and any that still don’t fit are listed by row before you print.

Open address labels

Pick the label paper

Choose the paper by the size printed on the pack. The most common address label in the US is 1 × 2⅝ inches, 30 to a sheet: three across and ten down on US Letter. These are a few of the sizes the tool knows:

Label sizePer sheetSheetCompatible with
1 × 2⅝ in30 (3 × 10)US LetterAvery® 5160, 8160, 5260, 18160
1 × 4 in20 (2 × 10)US LetterAvery® 5161, 5261, 8161
1⅓ × 4 in14 (2 × 7)US LetterAvery® 5162, 5262, 8162
63.5 × 38.1 mm21 (3 × 7)A4Avery® L7160, J8160

If the number on your pack isn’t one of these, search for it in the label paper list in step 2 of the tool, or measure a label and type in your own size. The Label paper page lists every size with its exact margins.

The top half of a US Letter sheet of 1 by 2⅝ inch labels, three across, each holding a name, street, city, state and ZIP code from the sample list
The sample list on 1 × 2⅝ in labels, 30 per sheet (the top half of the sheet), drawn by the tool itself.

Start on a part-used sheet

Label sheets cost too much to throw away half used. In the tool’s print step, open Start at and tap the first unused label on the picture of the sheet. The labels before it stay empty, and only the first sheet starts there: the next sheet is filled from the top.

The top of a sheet of 30 labels where the first seven are left empty and the addresses start at label 8
Starting at label 8: the first seven places, already used, are left empty.

Under How many, choose Every row of your datalist to print each address once, or more copies of each row. A list with a single address is taken as a return address and fills the whole sheet with it.

Your list stays in your browser

The file or the rows you paste are read by your own browser, on your own computer or phone. The list is not sent to EncodeLabel to make the labels: the preview, the PDF and the print are all made on your device.

It reaches the site only if you log in, press Save and say yes to keeping the list, so you can print from it again next time. The Privacy Policy says what is kept and for how long.

When labels don’t line up

Before the first real sheet, print the test page on plain paper. It is in the print step, under Line it up, and it never counts towards your labels. Hold the print against a label sheet, up to a window:

  • Every box is off by the same amount: use the arrows under Line it up to move everything the other way, in steps of 0.01 inch (0.25 mm on metric paper). The tool remembers the nudge for that label paper in this browser.
  • The boxes are too small, or drift further off toward the edges: the printer is shrinking the page. In the print window set Scale to 100% or “Actual size”, never a Fit setting.
  • Each row is further off than the one above: the paper size in the print window is wrong. Choose Letter for US sheets and A4 for most others.

The printing help shows each of these with a picture, and the print settings for Chrome, Edge, Firefox, Safari, iPhone and Android.

Try it

Free for up to 100 labels a month. No account needed. Your labels are made in your browser.

Open address labels Printing help

Feedback

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.