Document Editing Problems

How to Automatically Transfer Excel Values to Specific Word Locations

WPS Content Manager Oct 1, 2026 868 views

Question details

The user needs to automate the process of inserting specific values from an Excel spreadsheet into designated locations across pages in a Word document.

Word mail merge labels with Excel fields and Update Labels

Product: Word and Excel
Device & OS: not provided
Scenario: Transferring structured coordinate data (X and Y values) from a spreadsheet into specific, repeated locations within a text document without manually typing each entry.
Observed behavior: The user is looking for an automated workflow to replace the manual process of positioning and copying data whenever the spreadsheet values change.

Before you start

Ensure your Excel data is cleanly organized with column headers (e.g., 'X Coordinate', 'Y Coordinate') in the first row, and save a backup copy of your Word document before applying any automated macros or mail merges.

Solution 1Recommended

Use Mail Merge for Structured Automation

Mail Merge is the most efficient built-in feature for transferring structured Excel data into designated Word locations, especially for repeated document layouts.

This method treats your Excel spreadsheet as a database. It allows you to place 'Merge Fields' exactly where you want the X and Y coordinates to appear on your Word pages.

Prepare the Excel Data

Open your Excel file, ensure the first row contains distinct headers for your values, and save the file.

Start Mail Merge in Word

Open your Word document, go to the 'Mailings' tab on the ribbon, and click 'Start Mail Merge'. Choose the document type that fits your layout.

Select the Excel File

Click 'Select Recipients', choose 'Use an Existing List', and navigate to your saved Excel spreadsheet to link the data.

Insert Merge Fields

Place your cursor at the exact location in the Word document where the value should go. Click 'Insert Merge Field' and select the corresponding column header (e.g., X coordinate).

Complete the Merge

Click 'Preview Results' to verify the placement, then click 'Finish & Merge' to generate the final automated document with all values inserted.

Best Practice: Using Mail Merge is safer than macros and perfectly handles transferring hundreds of rows of data into individual pages seamlessly.

Solution 2

Copy and Paste Special for Simple Transfers

A straightforward, semi-manual method ideal for transferring a small number of values without complex setup.

Solution 3

Create a VBA Macro for Advanced Automation

For highly customized workflows where Mail Merge isn't flexible enough, you can write a VBA script to read Excel rows and insert them automatically.

Seamless Document Automation

Easily Merge Excel Data into Word Documents with WPS Office

WPS Office provides an intuitive Mail Merge feature that seamlessly integrates your spreadsheet data into text documents. It simplifies automating coordinate placements and is completely free.

1. Open WPS Writer: Launch WPS Office and open your text document in WPS Writer.
2. Access the Mailings Tab: Navigate to the 'References' or 'Mailings' tab on the top ribbon and click 'Mail Merge'.
3. Import Spreadsheet Data: Click 'Open Data Source' and select your saved WPS Spreadsheet containing the X and Y coordinates.
4. Insert Fields: Click 'Insert Merge Field' at the required document locations to dynamically link your spreadsheet columns.
5. Merge to Document: Click 'Merge to New Document' to automatically generate all pages with the inserted values.

Free, lightweight, and fast Office suiteFully compatible with Microsoft Excel (.xlsx) and Word (.docx) formatsIntuitive Mail Merge interface for rapid data transferAll-in-one tabbed workspace to easily switch between your spreadsheet and document

microsoft office alternative - wps office

Frequently Asked Questions

Can I make the Word document update automatically when Excel values change?

Yes. Instead of doing a standard paste or Mail Merge, you can link the data. Copy the cells in Excel, go to Word, click Paste > Paste Special, select the 'Paste Link' radio button, and choose 'Unformatted Text'. Whenever the Excel file is updated and saved, the Word document will reflect the new values.

Why is my Excel data pasting into Word as an image or a messy table?

By default, Word tries to retain the source formatting, which often pastes spreadsheet cells as a table. To prevent this, use the 'Paste Special' feature and select 'Unformatted Text' so only the text characters are inserted into your document.

Where can I find the Mailings tab if it's hidden?

In most modern Word processors, including Microsoft Word and WPS Writer, the Mailings tools might be grouped under a 'References' tab or hidden if the ribbon is collapsed. You can right-click the ribbon and select 'Customize the Ribbon' to ensure the 'Mailings' tab is checked and visible.

Document & File Issues