How To Print Labels From Excel Spreadsheet

You can turn hundreds of rows in a spreadsheet into a stack of printed labels in about five minutes, and you only have to set it up once.

The catch is that Excel cannot do it alone. Excel holds the data, Word lays out the label sheet, and Word's Mail Merge feature is the bridge between them. If you would rather not involve Word at all, there is a section further down on the options that actually work.

How do you prepare your Excel spreadsheet?

Ninety per cent of failed mail merges are caused by the spreadsheet, not by Word. Get this right and the rest is clicking.

1. One column per field, one row per label. Split First Name, Last Name, Address, City, State and ZIP into their own columns. Do not put a whole address in one cell.
2. Put clear headers in row 1. Word reads that row as the field names, so "ZIP Code" is useful and "Column D" is not. Start your data in row 2 with no blank rows above it.
3. Format ZIP codes as text so Excel does not strip leading zeros from 01234. Select the column, then Home > Number Format > Text, and retype any codes that have already lost their zero.
4. Delete empty rows and unmerge every merged cell. Word treats a blank row as a record and will print you a blank label for it. Our guide on how to remove blank rows in Excel covers the fast way to do it.
5. Save as .xlsx and close the file. Word cannot always read a workbook that is still open in Excel.

The rule: if a piece of information needs to appear on its own line of the label, it needs its own column in the spreadsheet. You can always combine columns in Word, you cannot split them.

Which label product number should you choose?

Word does not ask for label dimensions, it asks for a vendor and a product number. That number is printed on the label box or the backing sheet. Match it exactly and the layout is done for you. Get it wrong and every label will be off by a few millimetres.

Worth knowing: Avery's 5000-series numbers are for laser printers and the 8000-series are the inkjet equivalents. 5160 and 8160 are the same size and the same layout, so if your box says 8160 and Word only offers 5160, either will work. What matters is the dimensions, not the series.

How do you set up the mail merge in Word?

You build the label sheet in Word first, before you connect any data.

1. Open a blank Word document and go to the Mailings tab.
2. Click Start Mail Merge and select Labels.

   

3. In the Label Options dialog, choose your label vendor (Avery US Letter, Avery A4, Herma and so on), then the product number from the table above.
4. Click OK. Word builds a blank grid matching your label sheet.

   

If you cannot see the grid outlines, go to Layout > View Gridlines. Working blind is how alignment problems start.

How do you connect the Excel data to Word?

The label grid is empty until you point Word at your spreadsheet.

1. Click Select Recipients in the Start Mail Merge group.
2. Choose Use an Existing List and browse to your Excel file.

   

3. If the workbook has several worksheets, pick the one holding your label data.

   

4. Make sure First row of data contains column headers is ticked. This is what lets Word see field names like Name, Address, City and ZIP Code instead of raw cell references.
5. Click OK to finish the connection.

   

Every label except the first should now show a «Next Record» field. That field is what makes each label pull a different row. Remember it, because its absence is the cause of the most common mail merge failure.

How do you insert the Address Block?

Address Block is a single field that assembles a properly formatted postal address out of your columns, and it suppresses empty lines automatically. That last part matters, because inserting merge fields one at a time leaves a gap wherever someone has no second address line.

1. Click inside the first label, the one at the top left.
2. In the Write & Insert Fields group, click Address Block.

   

3. In the dialog, choose the name format you want, for example "Mr. John Doe" or plain "John Doe".
4. Click Match Fields if the preview looks wrong. This is where you tell Word that your column called "Street" is its "Address 1", and so on. Mismatched field names are the usual reason an address comes through half empty.
5. Check the preview pane, then click OK.

   

6. Click Update Labels. This copies the Address Block into every label on the sheet. Skip it and all thirty labels will print the same person.

   

The rule: Update Labels is not optional and it is not obvious. If your labels all show the same name, this is why, every time.

How do you preview and complete the merge?

1. Click Preview Results on the Mailings tab. The field codes are replaced by real names and addresses, and you can page through the records with the arrows.

   

2. When it looks right, click Finish & Merge > Edit Individual Documents.

   

3. The Merge to New Document box appears with three choices:
   • All records, the default, generates labels for every row in your spreadsheet.
   • Current record generates a single label for the row you are previewing.
   • From and To prints a specific range, for example 1 to 10. Use this to test a single sheet before committing a whole box of labels.

   

Word produces a new document containing your finished labels. Editing that document does not affect the Excel file, so it is a safe place to fix a one-off typo.

How do you print the label sheets?

1. Do a test print on plain paper first. Hold it up against a label sheet at a window. This costs one sheet of paper and saves a box of labels.
2. Load the label sheets the right way up. Check whether your printer feeds face up or face down before you assume.
3. Go to File > Print and set scaling to 100% or Actual size. "Fit to page" or "Shrink to fit" is the single most common cause of labels drifting out of alignment down the sheet.
4. If your printer offers a Heavy Paper, Labels or Cardstock media setting, use it. It slows the feed and reduces smearing and jams.
5. Print.

Can you print labels from Excel without Word?

Not directly, and it is worth being straight about why. Excel has no label layout feature. There is no label template, no product number picker, and no way to flow one row per label across a sheet. Anything that claims to print labels straight out of Excel is a macro, an add-in, or a hand-built grid.

These are the routes that genuinely work:

The rule: if you have Word, use Word. Every alternative on this list costs more setup time than the mail merge does, and only Avery Design & Print gets close on flexibility.

Why are your labels coming out wrong?

How is this different on a Mac?

The sequence is the same: Mailings, Start Mail Merge, Labels, Select Recipients, Address Block, Update Labels. Two differences are worth knowing before you start.

• There is no DDE option. The "Confirm file format conversion on open" fix above is Windows only. On a Mac, sort number formatting out in Excel before you merge, by formatting ZIP codes and reference numbers as text.
• Use a field switch if a number still comes through wrong. Press Option + F9 to reveal the field codes, then edit the field to add a format switch, for example { MERGEFIELD ZIP \# 00000 }. Press Option + F9 again to hide the codes.

Final thoughts

Mail merge has a reputation for being fiddly, and almost all of that reputation comes from two clicks people do not know about: Update Labels, and the print scaling setting. Get the spreadsheet clean, match the product number to the box, click Update Labels, print one test page on plain paper. That sequence works whether you are sending fifty invitations or five thousand.

For more easy-to-follow Excel guides and the latest Excel templates, visit Simple Sheets and the related articles below.

Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials.

Frequently asked questions

Why are all my labels printing the same name?

You did not click Update Labels after inserting the Address Block. That button is what copies the field into every label and adds the «Next Record» instruction. Go back to the Mailings tab, click Update Labels, then Preview Results again.

Can I print labels from Excel without using Word?

Not from Excel alone, because Excel has no label layout feature. The practical alternatives are Avery Design & Print Online, which imports a spreadsheet in the browser and is free, a labels add-on for Google Docs if your data is in Google Sheets, or the software that came with a dedicated label printer.

Why did my ZIP codes lose their leading zeros in the merge?

Word reads the raw values from Excel and ignores your cell formatting. On Windows, tick Confirm file format conversion on open under File, Options, Advanced, then reconnect the data source and choose MS Excel Worksheets via DDE. On a Mac, format the column as text in Excel first, or add a field switch such as { MERGEFIELD ZIP \# 00000 }.

Which Avery label number should I use for addresses?

Avery 5160 is the standard mailing address label, 1 by 2 5/8 inches, 30 to a sheet. Use 5162 if your addresses run to four or five lines, and 5163 for 2 by 4 inch shipping labels. The 8000-series numbers are the inkjet versions of the same sizes.

How do I print labels from Excel on a Mac?

The steps are identical, but the DDE workaround for number formatting does not exist in Word for Mac. Format ZIP codes and reference numbers as text in Excel before merging, or use a field format switch, revealed with Option + F9.

Can I print barcodes on labels using mail merge?

Yes. Install a barcode font in Word, then apply that font to the merge field carrying your barcode data. Test-scan a printed sheet before running the whole batch, because some barcode formats need start and stop characters added around the value.

Related Articles

How to Select Multiple Adjacent Cells

How to Print an Excel Spreadsheet on One Page

How to Email an Excel Spreadsheet

How to Remove Blank Rows in Excel

Printable Spreadsheet Templates