How to Merge Excel Data into Word Using Mail Merge (2026)

How to Merge Excel Data into Word Using Mail Merge (2026)

Mail merging Excel data into Word creates personalized documents at scale. Whether generating invoices, certificates, or form letters, mail merge automates the process and eliminates manual data entry.

Step-by-Step Instructions

Step 1: Organize Excel Data

Create an Excel spreadsheet with headers in the first row. Data should be organized in columns (Customer Name, Invoice Amount, Date, etc.).

Step 2: Save Excel File

Save the Excel file in a location you’ll remember. Close the file completely before proceeding.

Step 3: Create Word Document

Open Word and create your document template. Include static text and formatting that will appear in every merged document.

Step 4: Start Mail Merge

Click Mailings > Start Mail Merge. Choose the merge type (Letters, Envelopes, Labels, etc.).

Step 5: Select Data Source

Click Mailings > Select Recipients > Use Existing List. Navigate to and select your Excel file.

Step 6: Insert Merge Fields

Click in the document where you want data inserted. Click Mailings > Insert Merge Field. Select the Excel column name.

Step 7: Preview Results

Click Mailings > Preview Results to see how documents will look with actual data from Excel.

Step 8: Complete Merge

Click Mailings > Finish & Merge > Merge to New Document to create personalized documents for every Excel row.

Common Mistakes to Avoid

• Changing Excel data after starting the merge—update Excel first, then reconnect the data source
• Using special characters in Excel column headers that Word doesn’t recognize—stick to letters, numbers, and underscores
• Merging without previewing first—always check preview to catch formatting issues before generating all documents

Tips and Tricks

• Filter Excel data before merging if you want to merge only specific rows (e.g., only customers in California)
• Use conditional merge fields for advanced scenarios where you want different content based on data values
• Save the merge template for reuse—you can merge the same template with different data sources