Document Editing Problems

Insert Sequential Excel Rows in Word with Mail Merge or Linked Ranges

Nimra MalikNimra Malik Nov 20, 2026 869 views

Question details

Insert sequential rows from an Excel table into a Word document using Quick Parts or another suitable method.

Insert Sequential Excel Rows in Word with Mail Merge or Linked Ranges
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
A user wants to reuse spreadsheet data in a Word template, potentially placing text around or between records.
Observed behavior
Word does not provide a simple SEQ field that automatically advances through Excel cells.
Before you start

In Excel, give each data column a unique header and save the workbook. Decide whether you need a repeated entry for each row or a linked table that displays the range together.

Solution 1Recommended

Use a directory mail merge to list Excel rows in Word

Choose this method when you want Word to produce a repeated entry for each Excel row in one document.

A directory merge repeats the merge layout for each record. Add one-time introductory text after completing the merge, or use a separate section if the layout requires it.

1
Start a directory merge

In Word, open the document and select Mailings > Start Mail Merge > Directory.

2
Connect the workbook

Select Mailings > Select Recipients > Use an Existing List, choose the saved Excel workbook, and select the sheet containing the data.

3
Build the repeated entry

Use Mailings > Insert Merge Field to insert the column fields for one row. Add any labels, spacing, or text that should repeat with every record.

4
Preview and finish

Select Preview Results to check the records, then choose Finish & Merge > Edit Individual Documents and select All to create the combined document.

Use a directory mail merge to list Excel rows in Word
Adding different text between rows: Text in the merge layout repeats for each record. If each row needs different custom text, add it to an Excel column or edit the merged document afterward.
Free Microsoft Office alternative

Work with Excel and Word files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Open compatible Office files to make migration easier, although it does not change how Microsoft Word Quick Parts fields work.

Work with document and spreadsheet data in one office suiteOpen and edit Microsoft Word DOCX and Excel XLSX filesUse a familiar interface that makes switching easierGet a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Can a Word SEQ field move to the next Excel row automatically?

No. SEQ fields generate sequence numbers; they do not advance through Excel cells. For one entry per row, use Mailings > Start Mail Merge > Directory instead.

Can I use Quick Parts to repeat the same merge layout?

You can save reusable content through Insert > Quick Parts, but inserting it does not automatically advance an Excel cell reference. A directory mail merge is better suited to repeating a layout for successive records.

How do I update linked fields in Word?

On Windows, press Ctrl+A to select the document and then F9 to update selected fields. For a linked Excel object, you can also right-click it and choose Update Link if that option is available.

Will a named range automatically add new rows to a linked Word table?

Do not assume the linked object will expand when the named range changes. Update and check the link in Word; if the new rows do not appear, copy the revised range and create the link again using Paste Special.

How do I type Word field braces manually?

On Windows, press Ctrl+F9 to insert a pair of field braces. Typing ordinary braces on the keyboard does not create a Word field.