Word can pull names and addresses from an Excel spreadsheet and print them directly onto label sheets

Word has a built-in mail merge feature that reads data from Excel and prints it onto Avery labels or other standard label templates. You set up the label layout once, point Word to your Excel file, and it fills in each label with a different name and address from your list. This works for mailing labels, name badges, shipping labels, and any other label format that comes in a standard size.

The process takes about 10 minutes the first time and works the same way every time after that. You do not need to manually type or copy-paste anything into each label.

Key Takeaways

  • Word's mail merge feature reads directly from Excel files, so your spreadsheet data stays in Excel and Word pulls from it during printing.
  • Your Excel file needs column headers in the first row — like "First Name", "Last Name", "Address" — and one person per row below that.
  • Word comes with built-in templates for Avery label sheets and other common brands, so you do not have to measure or set margins yourself.
  • After you set up the merge once, you can reuse the same Word document with updated Excel files without redoing the setup.

Prepare your Excel spreadsheet with headers and clean data

Open your Excel file and look at the first row. Each column needs a header name that describes what goes in that column — "First Name", "Last Name", "Address", "City", "State", "ZIP Code". Word will use these header names to know which Excel column goes into which part of the label. If your headers say something different, Word can still work with them, but matching names make the process clearer.

Each person should be on their own row, starting from row 2. Delete any blank rows in the middle of your list, because Word will try to print a label for every row, including empty ones. If you have 150 names, you should have rows 2 through 151 filled, with no gaps. Save the file when you are done — you can keep it open while you work in Word, or close it. Word will find it either way.

Start a new label document in Word and choose your label size

Open Word and start with a blank document. Go to the Mailings tab at the top. Click Start Mail Merge, then select Labels from the dropdown menu.

A dialog box will open asking you to choose a label vendor and product number. If you are using Avery labels, find your product number on the sheet box — it usually looks like "5160" or "8160" — and search for it in the list. If you are using a different brand like Staples or Office Depot, look for that brand name in the vendor dropdown. If you do not know your exact product number, measure the label width and height and search by those dimensions instead. Click OK when you have found your label size.

Word will create a page with a table showing where each label will print. The table has light gray lines showing the boundaries of each label, but these lines will not print — they are just guides. You will see one label template at the top left, and that is where you will add the merge fields next.

Insert merge fields into the label template

Click inside the first label (the top-left one) so your cursor is positioned there. Go to Mailings again and click Insert Merge Field. A dropdown list will show all the column headers from your Excel file.

Click the first field you want — usually "First Name". Word will insert it as <<First Name>> in the label. Press Enter to move to the next line, then click Insert Merge Field again and select "Last Name". Keep going until you have added all the fields you need in the order you want them to appear. For a mailing label, the typical order is First Name, Last Name, Address, City, State, ZIP Code, with line breaks between each one.

You can type regular text around the merge fields too — for example, you could type "City: " before the City field if you want that label to say "City: New York". Most mailing labels do not need extra text, but name badges or inventory labels often do.

Copy the template to all labels on the page

After you have set up the first label with all your merge fields, you need to copy that template to every other label on the page. Click inside the first label to select it, then go to Mailings and click Update Labels. Word will copy your template to every label position on the page automatically.

You should now see the merge fields repeated in every label box on the page. The actual names and addresses will not appear until you preview or print the merge.

Connect Word to your Excel file and preview the results

Go to Mailings and click Select Recipients. Choose Use an Existing List. A file browser will open — navigate to your Excel file and click Open. Word will ask you which sheet contains your data (usually "Sheet1") and whether the first row contains headers (it does). Click OK.

Now go to Mailings and click Preview Results. The merge fields will disappear and you will see actual names and addresses from your Excel file filling in the labels. Use the arrow buttons next to Preview Results to scroll through and check that the data looks right — names are not cut off, addresses are complete, and nothing is obviously wrong.

If you see a problem, click Preview Results again to turn off the preview, fix the merge fields or the Excel data, and then preview again.

Print the merged labels or save as a new document

When the preview looks correct, go to Mailings and click Finish & Merge. You have two options: Print Documents sends the labels directly to your printer, or Edit Individual Documents creates a new Word document with all the merged labels so you can review or edit them before printing.

If you choose to print directly, Word will ask which records you want to print — you can print all of them, or just a range like records 1 through 50. Load your label sheets into the printer and click OK. The printer will print one label per label space on the sheet.

If you choose to edit individual documents, a new Word file opens showing all your merged labels. You can make changes to individual labels if needed, then print from there. This new document is separate from your original mail merge template, so you can close it without affecting the template.

Reuse the template with a different Excel file next time

After you have created and saved your label template, you can use it again with a different Excel file without redoing any of the setup. Open the saved template document, go to Mailings, click Select Recipients, and choose a different Excel file. The merge fields stay in place, and Word will pull from the new file instead.

This works as long as the new Excel file has the same column headers as the original. If the headers are different, you will need to update the merge fields to match, but that is usually faster than setting up from scratch.

Frequently Asked Questions

What if my Excel file has extra columns I do not want on the label?

You do not have to use every column from your Excel file. Just insert the merge fields you actually need into the label template. Word will ignore the columns you do not insert. You can also delete columns from Excel before starting the merge if you want to clean up the file.

Can I print only some of the labels, not the whole list?

Yes. When you click Finish & Merge and choose Print Documents, Word will ask which records to print. You can enter a range like "1-50" to print only the first 50 labels, or "5,10,15" to print specific rows. This is useful if you are testing on a few labels before printing the whole batch.

What happens if my Excel list has blank cells or missing data?

Word will print the label with whatever data is there and leave blank space where data is missing. If a name is missing but the address is there, the address will still print. Check your Excel file before merging to catch obvious gaps, especially in required fields like names or addresses.

Do I need to keep the Excel file open while I print?

No. Word reads the Excel file when you select it, so you can close Excel before printing. The data is loaded into Word's memory, and the merge will complete even if you close the original file.

Can I use Word's mail merge for other things besides labels?

Yes. The same process works for form letters, envelopes, and email messages. You set up the template in Word, connect it to your Excel data, and merge. The steps are nearly identical — the only difference is choosing "Letters" or "Envelopes" instead of "Labels" at the start.