How to Merge Excel Data Into Word Documents: A Step-by-Step Guide

To merge Excel data into Word documents, use Mailings > Start Mail Merge > Letters in desktop Word, connect your workbook through Select Recipients > Use an Existing List, insert merge fields, and preview the results. Finish with Edit Individual Documents to create a Word file you can review before printing.

Mail merge combines a reusable document with a list of records. It is useful when each person needs the same letter with different names or amounts. The finished output is a snapshot: changing Excel later does not automatically rewrite those completed letters. Keep the main merge document so you can run it again.

This walkthrough uses Word for Microsoft 365, Word 2024, or Word 2021 on Windows. Mac desktop Word also supports mail merge, but some dialogs differ. Microsoft’s desktop and web feature comparison lists Mail Merge as a desktop feature. Open the document in desktop Word if you are working in a browser.

1. Prepare and save your Excel list

Make a working copy of your workbook before reorganizing it. Put the records to merge on one worksheet, preferably the first sheet. Use the first row for clear column names, such as FirstName, LastName, and Appointment, and put one person or item on each following row. Avoid using a decorative report title as the header row. If you want one full-name field, you can combine first and last names in Excel before you merge.

Finish your edits, save the workbook locally, and close it before connecting Word. A browser sharing URL is not a workbook file path; Microsoft’s mail-merge data-source guidance calls for a local file or file share. Keep the saved workbook somewhere you can find again.

Preserve postal codes and other identifiers as text, especially when they start with zero. For CSV data in Excel for Microsoft 365, use Data > From Text/CSV and set the postal-code column to Text before loading. Changing a cell to Text after zeros have disappeared does not recreate the missing digits; correct the value from the original record.

Check dates, currency, and percentages in the Word preview rather than assuming the spreadsheet’s display will carry over exactly. Microsoft explains number preparation and adding currency or percent symbols in Prepare your Excel data source.

2. Start a letter and connect the workbook

1. Open a blank document or a copy of an existing letter in desktop Word. Select Mailings > Start Mail Merge > Letters.
2. Select Mailings > Select Recipients > Use an Existing List. Browse to the saved Excel workbook and open it.
3. Choose the worksheet containing your records if Word asks. Inspect the column names before continuing; choosing another sheet can give you the wrong fields.
4. Select Edit Recipient List. Check which records are included, clear the check boxes for unwanted recipients, and apply a sort or filter if needed. Confirm the selection before generating output.

Start Mail Merge > Letters, select Recipients > Use an Existing List, choose the worksheet, select Edit Recipient List” class=”wp-image-163075″ style=”width:650px;height:auto”/>

A recipient is simply one record in your list; it does not mean Word has sent anything. These steps create documents. Microsoft’s Excel mail-merge guide covers selecting records and retaining the source connection for reuse.

3. Insert fields into the text

1. Type the shared wording of the letter. Click exactly where a changing value belongs.
2. Select Mailings > Insert Merge Field and choose a column, such as FirstName. Word inserts a field placeholder.
3. Repeat for each changing value. Type ordinary spaces, punctuation, and line breaks around the fields so the letter reads normally.
4. Save the main document with a recognizable name, such as Appointment-letter-main.docx. This is the reusable file, separate from the completed output.

Insert fields with Word’s command; typing angle marks around a column name does not create a working merge field. Use Address Block or Greeting Line for their grouped fields when appropriate. If individual fields are unavailable, connect a list with Select Recipients first. Microsoft documents these options in Insert mail merge fields.

4. Preview with a small worked example

For practice, use fictional records in a separate workbook. This example shows how rows become personalized letters.

FirstName	LastName	Appointment
Alex	Rivera	October 15 at 10 AM
Sam	Chen	October 16 at 2 PM

Build the sentence Dear [FirstName] [LastName], your appointment is [Appointment]. Replace each bracketed example with an actual inserted field. Select Preview Results, then use the next and previous record buttons. Alex’s letter should show Alex Rivera and the October 15 appointment; Sam’s should show Sam Chen and October 16.

Check spacing, long values, page breaks, blank cells, and any numeric fields. Select Preview Results again to return to field view and revise the main document. Do this before using real records or spending paper on a full batch.

5. Create and inspect the finished documents

1. Select Mailings > Finish & Merge > Edit Individual Documents.
2. Choose All, Current record, or a record range, then select OK. Start with the current record if you want a small check.
3. Review the new document, including the first and last letters. Save it under a different name, such as Appointment-letters-output.docx.
4. Print the checked output when ready. Keep the main merge file and Excel source for another run.

Edit Individual Documents creates a combined output file; it does not automatically save a separate file for every recipient. You can also use Finish & Merge > Print Documents, but reviewing the generated file first makes errors easier to catch. See Microsoft’s personalized-letter instructions.

When the result is wrong

Wrong names or missing fields: check the selected worksheet, its column headers, and the field inserted at that location. Check recipient selections if people are missing or unexpectedly included. Correct the source or the main document, then preview again.

Zeros, dates, or amounts look different: compare the preview with the original records. Fix missing digits in the source and verify the Word result. Do not repeatedly change number formats without checking whether the underlying value is still correct.

The old output did not change after editing Excel: that is expected. Save and close the revised workbook, reopen the main merge document, and confirm its source connection if prompted. Preview the new values and produce a new output file. If you moved or renamed the workbook, select it again through Use an Existing List.

Choose a different merge type when needed

For labels containing different addresses, follow how to print labels from Word; a label sheet needs its own layout and Update Labels step. Do not use the Letters layout for a mailing-label sheet.

For a single continuous catalog or directory, start with Mailings > Start Mail Merge > Directory, connect the list, and insert the content that should repeat for each record. Preview, then finish through Edit Individual Documents and add one-time introductory text to the output. Microsoft provides the full directory-merge instructions.

For this letter workflow, the best final check is simple: compare a few finished letters with their Excel rows and confirm the recipients you intended to include. Keep the source and main document separate from the output so a later correction can be rerun cleanly.