Fix Word for Mac Mail Merge Error Reading an Excel File
Question details
Resolve an error when selecting an Excel spreadsheet as a mail merge data source in Word for Mac.

- Product
- Microsoft Word for Mac and Microsoft Excel
- Device & OS
- macOS Mojave
- Scenario
- The user is setting up a Word mail merge using an Excel workbook as the recipient list.
- Observed behavior
- Word displays an error reading from the file when the Excel workbook is opened as the mail merge data source.
Check that the worksheet has a header row and that each recipient occupies one row. Identify the worksheet containing your recipient list before selecting the data source in Word.
Check the Mail Merge Setup and Update Office for Mac
Use these checks to determine whether the error affects one workbook or the Word mail merge setup more broadly.
In Word, open the Mailings tab and select Start Mail Merge. Choose the type that matches your document, such as Letters or Labels.
On the Mailings tab, choose Select Recipients > Use an Existing List and select a different Excel workbook. If only one workbook fails, try the CSV or new-workbook workaround below.
In Word, select Help > Check for Updates and install any available updates compatible with your version of macOS. Restart Word and try selecting the workbook again.

Save the Recipient Worksheet as a CSV File
Use a CSV file as an alternative data source when Word cannot read the Excel workbook.
Copy the Recipient Data Into a New Excel Workbook
Try a new workbook if the issue appears limited to the original Excel file.
Work With Mail Merge Documents and Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format support helps you move existing files into WPS, though it does not repair Word for Mac errors.

Frequently Asked Questions
Why should I try a different Excel workbook?
Selecting another workbook through Mailings > Select Recipients > Use an Existing List helps determine whether the error is specific to the original file or affects multiple data sources.
Can I use a CSV file for Word mail merge on a Mac?
Yes. Save the recipient worksheet as a CSV in Excel, then choose it in Word through Mailings > Select Recipients > Use an Existing List. Preview the records to verify the imported data.
Will a CSV file retain all my Excel worksheets?
No. A CSV file stores the active worksheet only and does not retain Excel formatting. Select the worksheet containing the recipient list before using File > Save As.
How do I check for Office updates on macOS Mojave?
In Word, select Help > Check for Updates and install any updates offered for your system. Update availability depends on the Office version and macOS compatibility.




