Document Editing Problems

How to Create One Word Report per Person from Multiple Spreadsheet Rows

Maira Mehtab Sep 22, 2026 868 views

Question details

The user wants to generate individual Word reports for specific staff members by consolidating multiple survey response rows from a spreadsheet, rather than generating a separate document for every single spreadsheet row.

Product: Word
Device & OS: not provided
Scenario: Consolidating multiple survey responses assigned to individual staff members into individual, neatly formatted Word reports.
Observed behavior: Standard mail merge operations create a new document for every single row in the spreadsheet, failing to group the data by staff member.

Before you start

Ensure your spreadsheet is sorted by the staff member's name or ID column so that all rows for a single person are grouped consecutively before initiating any merge.

Solution 1Recommended

Use the Many to One Feature in the Merge Tools Add-in

Utilize a specialized third-party add-in designed to group multiple spreadsheet records belonging to the same person into one consolidated Word document.

By default, standard Word Mail Merge treats every row in Excel as a separate document. To group multiple responses for the same person, you need a 'Many to One' merge solution. The widely recommended Merge Tools Add-in provides this functionality seamlessly.

Download the Merge Tools Add-in

Open your web browser and navigate to https://mergetoolsaddin.com/ to download the Merge Tools Add-in ZIP file.

Install the Add-in

Extract the downloaded ZIP file and place the add-in file into your Word Startup folder according to the instructions provided on the download page.

Prepare your template and data

Open your Word report template. Ensure your Excel spreadsheet containing the survey responses is closed, as the add-in will need to access it.

Run the Many to One Merge

Navigate to the newly added Merge Tools tab on your Word ribbon. Select the 'Many to One' option, choose your spreadsheet as the data source, and map the key field (e.g., Staff Name) to group the records into individual reports.

Third-Party Tool: The Merge Tools add-in is a highly trusted third-party tool created by a Microsoft MVP, specifically designed to bypass the limitations of standard Word mail merge.

Free Microsoft Office alternative

Create and Edit Professional Reports with WPS Office

If you are dealing with complex document formatting and mail merge tasks, WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. It seamlessly handles Word documents, Excel spreadsheets, and PDFs in a single tabbed interface.

1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
2. Open Your Files: Launch WPS Office and open your .xlsx spreadsheet and .docx report template in convenient tabs.
3. Utilize Advanced References: Navigate to the References tab in WPS Writer to access powerful Mail Merge and document formatting tools.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in Mail Merge features for bulk document creation and reporting.All-in-one interface allows you to view your spreadsheet data and Word report templates side-by-side.Lightweight software that runs smoothly on Windows, Mac, and Linux without bogging down your system.

microsoft office alternative - wps office

Frequently Asked Questions

Why does standard Mail Merge create a new document for every row?

Standard Mail Merge is designed to treat every row in a spreadsheet as a separate, unique record (like a mailing label or a single letter). To group multiple rows into one document, you must use a 'directory' merge or a specialized add-in.

Can I use the Word Directory feature for a many-to-one merge?

Yes, the built-in Directory (or Catalog) merge type can group items, but it requires complex field coding (like IF statements) to start a new page per person. Using an add-in like Merge Tools is generally a much simpler and faster choice.

Where can I find the Word Startup folder to install add-ins?

On Windows, the Word Startup folder is typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Word\STARTUP. Placing a valid add-in file here makes its features available every time you open Word.

Document & File Issues