Document Editing Problems

How to Insert Excel Data into Specific Places in Word via Mail Merge

Natalie Taylor Oct 1, 2026 868 views

Question details

The user needs to automatically populate a Word agreement template with client data stored in an Excel spreadsheet.

How to Insert Excel Data into Specific Places in Word Documents

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating customized agreements or templates where variable client data needs to be placed into specific, predefined locations within the text.
Observed behavior: Instead of copying and pasting manually, a method is needed to link the Excel columns directly to designated areas in the Word document for batch generation.

Before you start

Before connecting your files, open your Excel spreadsheet and ensure that the first row contains clear column headers (e.g., First Name, Address, Sales Amount) and that there are no blank rows or columns before your data begins.

Solution 1Recommended

Use the Mail Merge Feature in Microsoft Word

Mail Merge is the standard and most efficient way to link an Excel data source to a Word document and map fields to specific locations.

By setting up a Mail Merge, Word reads your Excel file row by row. Each column header becomes a customizable tag (merge field) that you can drop anywhere into your document. You can generate a single combined document or individual files for each row of data.

Start the Mail Merge

Open your agreement template in Microsoft Word. Navigate to the 'Mailings' tab on the ribbon, click 'Start Mail Merge', and select 'Letters' (or 'Normal Word Document' depending on your formatting needs).

Select the Excel Data Source

Still on the Mailings tab, click 'Select Recipients' and choose 'Use an Existing List'. Browse your computer to locate and open your Excel spreadsheet. Select the specific worksheet containing your client data and ensure 'First row of data contains column headers' is checked.

Insert Merge Fields into the Text

Place your text cursor exactly where you want a piece of data (like a name) to appear in the document. Click 'Insert Merge Field' on the ribbon, and choose the corresponding column header from the dropdown menu. Repeat this step for all specific places that require Excel data.

Preview Results

Click the 'Preview Results' button on the Mailings tab. This replaces the field tags with actual data from the first row of your Excel sheet, allowing you to check spacing and punctuation.

Finish & Merge

Once satisfied, click 'Finish & Merge'. Choose 'Edit Individual Documents' to create a new Word document containing all merged agreements, or 'Print Documents' to send them directly to your printer.

Use the Mail Merge Feature in Microsoft Word

Pro Tip: If you are working with dates, currency, or percentages, Word might strip Excel's formatting. You can format the source data in Excel as text before merging to preserve the exact appearance.

Efficient Document Generation

Easily Automate Document Creation with WPS Writer

WPS Office offers a built-in, highly intuitive Mail Merge toolkit in WPS Writer. You can seamlessly connect spreadsheets to document templates to batch-generate agreements, letters, and forms in seconds without formatting loss.

1. Launch WPS Writer: Open WPS Office and load your agreement template in WPS Writer.
2. Access the Mail Merge Toolkit: Navigate to the 'References' tab and click on 'Mail Merge' to display the dedicated merge ribbon.
3. Link Your Spreadsheet: Click 'Open Data Source', browse for your Excel file, and select the sheet holding your client information.
4. Insert Fields and Complete Merge: Click 'Insert Merge Field' to place data placeholders throughout your text. Click 'Merge to New Document' to generate your final filled-out agreements.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Dedicated Mail Merge toolbar designed for quick, visual setup and previewing.Lightweight software that handles large data sets rapidly without freezing.Free to use, offering an excellent alternative for automated document workflows.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel numbers or dates showing up with wrong formats in Word?

Word pulls raw data from Excel, ignoring cell formatting like currency symbols or date layouts. To fix this, you can format the data in Excel as text using the TEXT function, or press Alt + F9 in Word to edit the merge field code and add formatting switches (e.g., adding \@ "MMMM d, yyyy" for dates).

How do I update the Word document if I add new rows to my Excel spreadsheet?

If your Excel file is updated, open your connected Word document, go to the 'Mailings' tab, and click 'Edit Recipient List'. Word should automatically refresh the connection, but you can also click the data source in the list and select 'Refresh' to ensure all new rows are loaded.

Can I merge multiple Excel records into a single page or table?

Yes. Instead of selecting 'Letters' as your document type, go to the Mailings tab, click 'Start Mail Merge', and choose 'Directory'. This configuration allows Word to list multiple records consecutively on the same page without forcing page breaks after every row of data.

Document & File Issues