Fix Word Mail Merge External Table Format Errors with Excel Files
Question details
Resolve intermittent Word mail merge format errors when using an Excel workbook as the recipient data source.

- 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.
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.
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.
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.
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.
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).
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.

Use an XLS copy as a temporary workaround
Try the older Excel format if Word still cannot read the XLSX source.
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.

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.




