In Excel: prepare one header row in Excel, save the workbook, then in Word use Mailings ▸ Select Recipients ▸ Use an Existing List and insert merge fields from that sheet.
Put one clean header row at the top of the Excel list.
Remove blank rows, merged cells and totals from the recipient data.
Save the workbook, then open Word and start the mail merge from the Mailings tab.
Select the Excel workbook as the recipient list, insert fields, preview results and finish the merge.
What this does
Mail merge uses Excel as the recipient database and Word as the document template. Each Excel row becomes one letter, label, envelope or email; each column header becomes a merge field such as FirstName, Company or AmountDue. Clean headers and consistent data types matter because Word reads the first row as field names. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “mail merge with excel and word”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a text operation that turns messy entries into clean, usable data useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A sheet named Customers has headers FirstName, LastName, Address and Balance. Save and close the workbook, open Word, choose Mailings ▸ Start Mail Merge ▸ Letters, then Select Recipients ▸ Use an Existing List and pick Customers. Insert FirstName and Balance fields; preview shows each row merged into the letter. Mail merge is the practical bridge between spreadsheet lists and personalized documents: invoices, notices, labels, certificates and any message that repeats with row-specific details. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Here is the takeaway for “mail merge with excel and word”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
Common mistakes
- Using merged cells or multi-row headers, which Word cannot treat as clean field names.
- Leaving the workbook unsaved or open in a way that prevents Word from reading the latest data.
- Formatting ZIP codes or IDs as numbers, which can drop leading zeros during merge.
- Forgetting to preview several records before printing hundreds of letters or labels.
Frequently asked questions
Can Word mail merge directly from Excel?
Yes. Word reads a worksheet or named range from an Excel workbook as the recipient list.
Why are leading zeros missing?
Excel stored the values as numbers. Store ZIP codes and IDs as text before merging.
Can I filter recipients?
Yes. In Word, use Edit Recipient List to filter and sort the Excel rows before finishing.
Other ways people ask this
On the way here you may have searched this as “mail merge word and excel”, “mail merge in word and excel”, “mail and merge in excel” and “mail merge with excel and word” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “mail merge word and excel”, “mail merge in word and excel”, “mail and merge in excel” all point at the one operation explained on this page, which is why they all lead here.