Mail merge pulls data from Excel into Word documents automatically

A mail merge takes information stored in an Excel spreadsheet — names, addresses, amounts, dates — and inserts it into a Word document template to create personalized copies. Instead of typing each recipient's details by hand, you set up the connection once, and Word generates as many customized documents as you have rows in your spreadsheet.

The process works in three steps: prepare your Excel data, set up your Word template with merge fields, and run the merge. Most people use mail merge for letters, envelopes, labels, or invoices where the same text repeats but certain details change for each recipient.

Key Takeaways

  • Your Excel file must have column headers in the first row, with each column representing one piece of information (Name, Email, Amount, etc.).
  • In Word, you insert merge fields where you want Excel data to appear, using the Mailings tab to mark those locations.
  • Word pulls data from Excel one row at a time, creating a separate document or page for each row in your spreadsheet.
  • You can preview the merge before completing it to catch errors in your data or template layout.

Prepare your Excel spreadsheet correctly

Your Excel file must be organized in a specific way for Word to read it. Put your column headers — the labels for each piece of information — in the very first row. Use straightforward, single-word headers without spaces or special characters. For example, use FirstName instead of "First Name", LastName instead of "Last Name", and Amount instead of "Dollar Amount".

Each row below the headers represents one person or one transaction. If you have 50 people to send letters to, you will have 50 rows of data plus the header row. Make sure there are no blank rows in the middle of your data — Word will stop reading when it hits an empty row. Save your Excel file before you open Word.

Open Word and start the mail merge

In Word, go to the Mailings tab at the top of the screen. Click Start Mail Merge, then choose the type of document you are creating: Letters, Email Messages, Envelopes, Labels, or Directory. For a standard letter or email, choose Letters.

Next, click Select Recipients and choose Use an Existing List. Browse to your Excel file and open it. Word will ask you which sheet to use (if your file has multiple sheets) and whether the first row contains headers — answer yes to both. Your Excel data is now connected to your Word document.

Insert merge fields into your template

Type or paste the body of your document — the text that stays the same for every recipient. Wherever you want Excel data to appear, click Insert Merge Field in the Mailings tab. A dropdown menu shows all the column headers from your Excel file. Click the one you want to insert.

Word inserts the field name in double angle brackets, like <<FirstName>> or <<Amount>>. These are placeholders. When you run the merge, Word replaces each placeholder with the actual data from your spreadsheet. You can insert the same field multiple times if you need it in different places.

Preview and complete the merge

Before you generate all your documents, click Preview Results in the Mailings tab. Word shows you what the first document will look like with real data from your Excel file. Use the arrow buttons to flip through a few examples and check that the data is in the right places and formatted correctly. If something looks wrong, click Preview Results again to turn off the preview, fix your template, and try again.

When the preview looks correct, click Finish & Merge and choose how you want to output the documents. Edit Individual Documents creates a new Word file with all merged documents in it, one per page, so you can review or edit each one. Print Documents sends them straight to your printer. Send Email Messages works only if you have an Email field in your Excel data and are merging email messages, not letters.

Common problems and how to fix them

If Word cannot find your Excel file, the file may be open in another program. Close Excel completely, then try the merge again. If the merge fields show the placeholder text instead of actual data, you are still in preview mode — click Preview Results to turn it off and complete the merge.

If data appears in the wrong place or is cut off, check your template formatting. Make sure merge fields are inside the text where they belong, not in margins or headers. If your Excel data contains commas or special characters, they may cause Word to misread the columns — save your Excel file as a .csv (comma-separated values) file instead and try again.

Alternatives if mail merge is not working

If you only need to send a few documents, copying and pasting the data manually is faster than troubleshooting a merge. If your Excel file is very large or complex, consider using a mail merge tool designed for bulk email, like Mailchimp or a similar service, which handles the formatting for you.

If you are merging into envelopes or labels and the alignment looks wrong, Word's envelope and label templates can be finicky. Print a test copy on regular paper first, hold it up to a real envelope or label sheet, and adjust the margins in your template before printing the whole batch.

Frequently Asked Questions

Can I merge to email instead of printing?

Yes, but only if you choose Email Messages when you start the merge, and your Excel file has a column with email addresses. Word will use your default email program to send each message. The merge field for the email address must be in the "To" field, not in the body of the message.

What if my Excel file has more columns than I need?

Extra columns do not cause problems. Word only inserts the merge fields you actually place in your template. You can have 20 columns in Excel but only use 3 of them in your Word document.

Can I edit the merged documents after they are created?

Yes. If you choose Edit Individual Documents when you finish the merge, Word creates a new file with all the merged pages. You can edit, delete, or rearrange pages in that file before saving or printing. Changes to individual documents do not affect your original template or Excel file.

What happens if I have blank cells in my Excel data?

Word inserts nothing where the data is blank, which usually looks fine. If a blank cell causes awkward spacing — like "Dear ," instead of "Dear John," — you may need to adjust your template text or clean up your Excel data before merging.

Do I have to use .xlsx files, or can I use other formats?

Word works with .xlsx, .xls, and .csv files. If you have trouble with .xlsx, try saving your Excel file as .csv and connecting to that instead. Some older versions of Word work more reliably with .csv format.