Mail Merge Labels From Excel to Word, Step by Step

To mail merge labels from Excel to Word, you connect your spreadsheet to a label layout. Word then fills each label with one row from the list. You need three things: a clean Excel list with a heading row, a label sheet with a product number, and the Word desktop app. The whole process takes about 15 minutes the first time.

What you need to mail merge labels from Excel

• Microsoft Word on Windows or Mac. Mail merge does not work in Word for the web.
• An Excel file (.xlsx) with one row per person.
• Your label sheet's product number, printed on the box, such as 5160 or L7160.

Step 1: Prepare your Excel list

Most mail merge problems start in the spreadsheet, so check it first.

1. Put a heading on the first row of each column, such as First Name, Last Name, Company, Street, City, State and ZIP.
2. Put one person on each row. Do not merge cells or add a second title above the headings.
3. Delete empty rows at the bottom of the list. Each empty row can produce a blank label.
4. Check the ZIP column. Select it, go to the Home tab, and set Number Format to Text. This keeps leading zeros such as 02134.
5. Check the date and number columns. If a date shows as 1/2/2026 on the sheet, it will print the same way on the label. Make sure it is the format you want, or use Text for the column.
6. Save the file and note where it is. Word needs to find it when you connect.

Step 2: Set up the label document

This step tells Word which label sheet you are using.

On Windows, go to Mailings, then Start Mail Merge, then Step-by-Step Mail Merge Wizard, and choose Labels. Click Next: Starting document, then Label Options. Pick the vendor and the product number, then click OK.

On a Mac, go to Mailings, then Start Mail Merge, then Labels. In the Label Options dialog, choose the supplier and product number, and click OK. If you do not see the label outlines, go to Table Layout, then View Gridlines.

For the Avery® 5160, the product number is 5160. For the A4 address sheet, use L7160, which is 63.5 × 38.1 mm and holds 21 labels. You can check the layout on the 5160 page or the L7160 page before you start.

Step 3: Connect to your Excel list

Now you tell Word where the names are.

On Windows, click Next: Select recipients, then Browse. Open your Excel file and choose the sheet that holds the list. Word shows the rows in a box so you can check them.

On a Mac, go to Mailings, then Select Recipients, and choose your Excel file as the data source. Pick the worksheet tab with your data. Some versions of Word show this as Use an Existing List under the Select Recipients menu.

To check the list, go to Mailings, then Edit Recipient List. You can untick any row you do not want to print. Unticked rows will not produce labels.

Step 4: Add the address to the label

Word needs to know which fields go on each label. There are two ways to add them.

Address Block is the easiest choice on Windows. It puts the full address in the standard order, with the name on the first line. Click Next: Arrange your labels, then Address block, and confirm the format.

Insert Merge Field is the method on a Mac. Go to Mailings, then Insert Merge Field, and add each field in the order you want it. Type spaces, commas and line breaks between them yourself. For example, put a space between First Name and Last Name, and press Enter after the street.

You only need to add the fields to the first label. Word copies the layout in the next step.

Step 5: Update the labels

Click Update Labels under Mailings. On Windows, click Update all labels. Word copies the first label's fields to every label on the page. Do this every time you change the layout. If you skip it, only the first label will change.

Step 6: Preview the results

Click Preview Results under Mailings. Your first label now shows real names from your list. Use the arrows to step through the records.

Check three things on each preview:

• The name and address are on the right lines.
• ZIP codes show all their digits.
• No label shows a field name, such as «First Name», in place of a real name. That means a field did not connect.

If a field looks wrong, go back to the Excel file, fix the cell, then click Update Labels again.

Step 7: Finish the merge and print

When the preview looks right, finish the merge.

1. Go to Mailings, then Finish & Merge.
2. Choose Print Documents to print straight away. On Windows, choose Complete the merge, then Print.
3. To check the labels first, choose Edit Individual Documents, select All, and click OK. Word then makes one new document with every label in it.
4. Save the document from File, then Save if you want to use it again.

Before you load the label sheet, print one page on plain paper. Hold it over a sheet against a window. If the text fits inside the label edges, print the real sheet.

Common errors and how to fix them

ZIP codes lost their leading zeros. Excel treats ZIP codes as numbers, so 02134 shows as 2134. Set the column to Text before you merge, as in step 1. If the zeros are already gone, type them back into the Excel list and connect the list again.

Blank labels at the end. Excel may count empty rows as records. Delete them from the list, then reconnect the list and click Update Labels.

Dates show the wrong format. Word uses the format shown in Excel. Change the cell format in Excel to the date style you want, then merge again.

Numbers have too many decimals. A price or a phone number may pick up extra decimal places. Format the column as Text or as a number with no decimals in Excel.

Merge fields show «First Name» instead of names. The field is not connected to your list. Go back to Select Recipients, check the file, and then insert the fields again.

The labels run onto a second page. The text is too long for one label, or the sheet is set up wrong. Shorten the text, reduce the font, or check the product number.

The wrong worksheet was used. Your Excel file may have more than one tab. Connect the list again and choose the tab that holds the names. Keep the headings on the first row of that tab.

A faster route

If you want to skip the steps, you can paste the same Excel rows into LabelPeel. Each row becomes one label. You can try it without an account. Our guide to printing labels from Excel compares the three ways.

For the basic layout of Word labels without a list, read how to print labels in Word.

Tips for better results

• Use the same heading names across lists so you can reuse the layout.
• Keep a copy of the list in its original form, so you can always go back to it.
• Test with five or six rows first, then merge the full list.
• Save the merged document with a clear name, such as Labels for Christmas 2026.