Document Editing Problems

How to Create Multiple Word Documents from an Excel Spreadsheet

Partner Editor Oct 7, 2026 868 views

Question details

The user needs to generate multiple separate Word letters in bulk using a list of names and addresses stored in an Excel spreadsheet.

Create Multiple Word Documents from an Excel Spreadsheet

Product: Word, Excel
Device & OS: not provided
Scenario: Bulk generating personalized letters or individual documents from an existing spreadsheet data source.
Observed behavior: The goal is to successfully populate separate Word documents or PDFs for each record in an Excel spreadsheet, ensuring correct address information in each file.

Before you start

Ensure that your Excel column names are located in the very first row, contain only alphanumeric characters, and do not begin with a number to prevent merge errors.

Solution 1Recommended

Use Word Mail Merge with the Merge Tools Add-in

This is the standard and most reliable method for generating personalized letters and saving them as individual Word or PDF files.

While standard Word Mail Merge generates a single large document containing all letters, using a third-party add-in like Merge Tools allows you to easily split the output into separate files for each record.

Prepare your Excel data

Open your Excel spreadsheet and verify that all names and addresses are neatly organized with clear column headers in the first row. Save and close the workbook.

Start Mail Merge in Word

Open a new Word document, go to the Mailings tab, and select Start Mail Merge. Choose Letters, then click Select Recipients and Use an Existing List to import your Excel file.

Insert Merge Fields

Place your cursor where you want the specific data to appear in the letter, click Insert Merge Field, and add the corresponding fields (e.g., Name, Address).

Split into individual documents

To save each letter as a separate file, install and run the Merge Tools Add-in. Select the 'Merge to Individual Documents' feature to automatically generate separate Word or PDF files for every record.

Use Word Mail Merge with the Merge Tools Add-in

Add-in Requirement: If you do not have the Merge Tools Add-in, standard Mail Merge will only allow you to output all letters into a single continuous Word document or print them directly.

Solution 2

Automate Document Creation Using VBA Macros

Ideal for advanced users who need highly customized file naming and automated document generation directly from Excel without third-party add-ins.

Efficient Document Processing

Create Personalized Letters with WPS Writer Mail Merge

WPS Writer includes a powerful and easy-to-use Mail Merge feature that seamlessly connects to your spreadsheet data, allowing you to bulk-create customized letters and documents effortlessly.

1. Open Mail Merge in WPS Writer: Launch WPS Writer, navigate to the References tab on the top ribbon, and click on Mail Merge to activate the merge toolbar.
2. Connect your spreadsheet: Click Open Data Source on the ribbon and browse your computer to select the spreadsheet containing your names and addresses.
3. Insert fields and generate documents: Use the Insert Merge Field button to place your data into the letter template. Finally, click Merge to New Document to bulk-generate your personalized letters.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in Mail Merge tool with an intuitive, easy-to-follow wizard.Free, lightweight, and supports directly exporting merged documents.

microsoft office alternative - wps office

Frequently Asked Questions

Can I save each mail merge record as a separate PDF file?

Yes. While the default Word Mail Merge creates a single document, you can use third-party tools like the Merge Tools Add-in or a custom VBA macro to automatically export and save each record as an individual PDF file.

Why are my Excel column names not showing up as merge fields in Word?

This usually happens if the spreadsheet is formatted incorrectly. Ensure that your column headers are in the very first row of your Excel sheet, contain no special characters, and do not begin with a number.

Does WPS Office support Mail Merge from spreadsheets?

Yes, WPS Writer has a built-in Mail Merge feature that can link directly to WPS Spreadsheets, Excel files (.xlsx), or CSV files to quickly generate personalized letters and labels.

Document & File Issues