File Format & Compatibility

Fix Word Mail Merge External Table Format Errors with Excel Files

Bushra ParveenBushra Parveen Nov 18, 2026 868 views

Question details

Resolve intermittent Word mail merge format errors when using an Excel workbook as the recipient data source.

Fix Word Mail Merge External Table Format Errors with Excel Files
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
A user selects an XLSX workbook as the data source for a Word mail merge.
Observed behavior
Word intermittently reports that the external table is not in the expected format, even though the workbook opens in Excel. Converting it to XLS allows the merge to work.
Before you start

Open the source workbook in Excel and check for prompts about external links or data connections. Confirm which worksheet contains the recipient data and that it has a header row.

Solution 1Recommended

Check workbook links and test a clean XLSX data source

Use this approach to isolate workbook features that may interfere with the mail merge connection.

1
Inspect links and connections

Open the workbook in Excel and look under Data for Workbook Links or Edit Links and Queries & Connections. Review any links or connections that appear; a locally saved workbook can still contain them.

2
Remove unnecessary dependencies

Use the available link or connection controls on the Data tab to remove dependencies that are no longer needed. Check with the workbook owner before removing anything used to update its data.

3
Create a clean workbook

Create a new Excel workbook, copy the recipient table including its headers, and use Paste Special > Values to paste it into a worksheet. Save the new file as an Excel Workbook (*.xlsx).

4
Reconnect the data source

In Word, open the merge document and choose Mailings > Select Recipients > Use an Existing List. Select the clean XLSX file and the worksheet containing the recipient table, then preview the results.

Check workbook links and test a clean XLSX data source
Check pasted values: Pasting values removes formulas and live data connections. Verify that identifiers, dates, and other recipient fields appear as intended before completing the merge.
Free Microsoft Office alternative

Work with Word documents and Excel data in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility makes it easier to move existing files into WPS, though it does not fix a Microsoft Word mail merge connection error.

Open and review spreadsheet recipient lists in WPS SpreadsheetsWork with Microsoft Word DOCX and Excel XLSX and XLS filesUse a familiar interface to move between documents and spreadsheetsGet a free, lightweight office suite for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

Why can Excel open the workbook when Word mail merge cannot?

Excel and Word may access the workbook differently. Links, connections, or other workbook features can interfere with the data source, so test a clean XLSX file containing only the recipient values.

Can a locally saved Excel file still connect to an external database?

Yes. Saving a workbook locally does not necessarily remove its connections. In Excel, check Data > Queries & Connections and review any listed connections.

How do I select the new workbook in Word?

Open the merge document and choose Mailings > Select Recipients > Use an Existing List. Select the replacement workbook, then choose the worksheet containing your recipient data.

Is converting XLSX to XLS a permanent fix?

It can be a useful workaround, but it does not identify the underlying cause. Check the XLS copy for compatibility warnings and verify its data before running the merge.