How to Merge Excel Data Into Word Documents

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.

These steps are for Word for Microsoft 365, Word 2024, and Word 2021 on Windows. Microsoft’s desktop and web feature comparison lists Mail Merge as a desktop feature, so open the document in desktop Word if you’re working in a browser. If you only want a block of spreadsheet cells inside a Word report, see the last section.

1. Prepare and save your Excel list

A merge uses three files: the Excel list, a Word main document with placeholders called merge fields, and the finished output. Keeping them apart lets you fix a mistake and run the merge again.

Make a working copy of your workbook before reorganizing it. Put the records 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 a decorative title row, and delete blank rows inside the list. If you want one full-name field, you can combine first and last names in Excel first, and lists built from several exports are worth checking so you can remove duplicates in Excel.

If your list is currently a table in a Word document, copy the Word table into Excel first, then add a clear header row.

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.

Preserve postal codes and other identifiers as text, especially when they start with zero; Microsoft warns that a code such as 00399 loses its zeros during a merge otherwise. 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 bring the digits back; correct the value from the original record. If the list is headed for a print layout instead, see how to import an Excel spreadsheet into InDesign.

Microsoft’s Prepare your Excel data source page also suggests typing currency or percent symbols in the Word document next to the field, since spreadsheet formatting doesn’t always carry over.

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, and leave First row of data contains column headers checked. Check the column names before continuing; another sheet gives you the wrong fields.
  4. Select Edit Recipient List. Clear the check boxes for unwanted recipients, and apply a sort or filter if needed.
Word mail merge from Excel: open Mailings, start a Letters merge, use an existing recipient list, choose the worksheet, and edit the recipient list
Illustration: how to start a mail merge from Excel data in Word.

Nothing is emailed or sent at this stage. Word only creates documents. Microsoft’s Excel mail-merge guide covers choosing records and reusing the list later.

For a guided first merge, choose Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard instead. A pane on the right walks through the same choices one screen at a time.

3. Insert fields into the text

  1. Type the shared wording of the letter. Click exactly where a changing value belongs.
  2. Select the arrow under Mailings > Insert Merge Field and choose a column, such as FirstName. Word inserts a placeholder that looks like «FirstName».
  3. Repeat for each changing value. Type ordinary spaces, punctuation, and line breaks around the fields.
  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.

Typing angle marks around a column name does not create a working field; use Word’s command. Address Block and Greeting Line insert grouped fields. If either one leaves out part of your list, select Match Fields and pick the right Excel column for each item, such as your Zip column for Postal Code. If the field buttons are dimmed, no list is connected yet. Microsoft’s Insert mail merge fields article has more on these options.

4. Preview with a small worked example

For practice, use fictional records in a separate workbook.

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.

Word mail merge preview showing a letter to Alex Rivera with the October 15 appointment filled in
Select Preview Results and use the record buttons to check each letter.

Check spacing, long values, page breaks, blank cells, and numeric fields. Select Preview Results again to return to field view and revise the main document before using real records.

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.
  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.

Edit Individual Documents creates one combined output file, not a separate file per recipient. Finish & Merge > Print Documents skips the review step, so use it only after a checked run. See Microsoft’s personalized-letter instructions. You can use the same list to print envelopes in Word, one for each record.

The saved main document stays connected to the workbook. When you open it later, Word asks about placing data from your list; choose Yes to keep the connection and preview the current Excel data.

Send the Merge as Email Instead

Your list needs an email address column, and you need a MAPI-compatible email program, such as Outlook, set up on the computer.

  1. Open the message text in Word and choose Mailings > Start Mail Merge > E-mail Messages.
  2. Connect the workbook with Select Recipients > Use an Existing List.
  3. Add Greeting Line or other fields, then check several records with Preview Results.
  4. Choose Finish & Merge > Send E-mail Messages.
  5. In To, pick the email column, type a Subject line, keep Mail format on HTML, choose the records, and select OK.

Word sends a separate message to each address. Microsoft’s email merge instructions note that you can’t add attachments or CC and BCC anyone. Send one record to yourself first.

When the result is wrong

Wrong names or missing fields: check the selected worksheet, its headers, the field at that spot, and Match Fields for grouped fields. Check recipient selections if people are missing or unexpectedly included, then preview again.

Zeros or amounts look different: fix missing digits in the source and check the Word result. Don’t keep changing number formats without checking that the underlying value is still correct.

Dates show as numbers or in the wrong order: Excel stores dates as serial numbers, and Word doesn’t always use the cell’s display format. Add a helper column: if the date is in B2, type =TEXT(B2,”mmmm d, yyyy”), fill it down, name the column ApptDate, save, and insert that field in Word instead.

The old output did not change after editing Excel: that is expected. Save and close the workbook, reopen the main document, choose Yes to keep the connection, and produce a new output file. If you moved or renamed the workbook, select it again through Use an Existing List.

Merge Excel Addresses Into Word Labels

Prepare the Excel list using the first section above, then start a blank document in desktop Word. Choose Mailings > Start Mail Merge > Labels, select the label vendor and the product number printed on the package, and confirm. Choose Select Recipients > Use an Existing List, open the saved workbook, and select its address worksheet. Event badges work the same way, with a few layout tweaks covered in how to make name tags from Excel.

Build the first label with Insert Merge Field or Address Block, adding spaces and line breaks as needed. Choose Update Labels to copy that layout to the other labels, then Preview Results. Use Finish & Merge > Edit Individual Documents, and test-print a page on plain paper held against the label sheet before printing on labels. Microsoft’s mailing-label instructions cover this workflow. To put street, city, and state on one line, you can combine columns into one in Excel first.

For label sheets that don’t use Excel data, such as one return address repeated on every label, print labels straight from Word.

Choose a different merge type when needed

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. Microsoft provides the full directory-merge instructions.

Insert an Excel Table in Word Without a Mail Merge

To show spreadsheet cells in a report, copy the range in Excel and paste it into Word. It becomes an ordinary Word table that doesn’t change when the workbook does. To keep a live copy instead:

  1. In Word, select Insert > Object in the Text group.
  2. Open the Create from File tab and select Browse to choose the workbook.
  3. Check Link to file to keep it updated from the workbook, or leave it unchecked to embed a fixed copy.
  4. Select OK. Double-click the object later to edit it.

Microsoft’s guide to inserting an object in Word explains that a linked object keeps the Word file smaller, while an embedded one travels with the document to people who don’t have the workbook.

Mail Merge Questions

Can I mail merge in Word for the web?

No. Mail Merge is a desktop Word feature. Open the file in the Word desktop app and run the merge there.

Will Word update the letters if I change the Excel file?

The main document will, when you reopen it and choose Yes to keep the connection. A finished output document is a fixed copy, so run Finish & Merge again.

Can each letter be saved as a separate file?

Not with the built-in options. Edit Individual Documents puts every letter in one document. For one letter, choose Current record when finishing and save that output.

Can I use a Google Sheets or CSV list?

Yes. Download the Google Sheet as an Excel workbook or CSV, check postal codes and dates as described in section 1, then connect it with Use an Existing List.

For your first real batch, merge two or three test rows, compare each letter with its Excel row, and then print or send the full list.