Office for Mac Issues

Fix Word for Mac Mail Merge Error Reading an Excel File

Huda QurayshiHuda Qurayshi Nov 14, 2026 868 views

Question details

Resolve an error when selecting an Excel spreadsheet as a mail merge data source in Word for Mac.

Fix the Word for Mac Mail Merge Error Reading an Excel File
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the merge type

In Word, open the Mailings tab and select Start Mail Merge. Choose the type that matches your document, such as Letters or Labels.

2
Test another workbook

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.

3
Check for Office updates

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.

Check the Mail Merge Setup and Update Office for Mac
Free Microsoft Office alternative

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.

Work with document and recipient-list files in one office suiteOpen and edit Microsoft Word and Excel formats, including DOCX and XLSXUse a familiar interface that makes moving from Microsoft Office easierGet a free, lightweight alternative for everyday office work
microsoft office alternative - wps office

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.