Insert Sequential Excel Rows in Word with Mail Merge or Linked Ranges
Question details
Insert sequential rows from an Excel table into a Word document using Quick Parts or another suitable method.

- 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.
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.
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.
In Word, open the document and select Mailings > Start Mail Merge > Directory.
Select Mailings > Select Recipients > Use an Existing List, choose the saved Excel workbook, and select the sheet containing the data.
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.
Select Preview Results to check the records, then choose Finish & Merge > Edit Individual Documents and select All to create the combined document.

Paste a linked Excel range as a table in Word
Use a linked range when the rows can appear together as an Excel object rather than as separate merge entries.
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.

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.




