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
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:
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.
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.
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.
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 size | Per sheet | Sheet | Compatible with |
|---|---|---|---|
| 1 × 2⅝ in | 30 (3 × 10) | US Letter | Avery® 5160, 8160, 5260, 18160 |
| 1 × 4 in | 20 (2 × 10) | US Letter | Avery® 5161, 5261, 8161 |
| 1⅓ × 4 in | 14 (2 × 7) | US Letter | Avery® 5162, 5262, 8162 |
| 63.5 × 38.1 mm | 21 (3 × 7) | A4 | Avery® 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.
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.
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.