File Format & Compatibility

Fix Excel Workbook Text Converter Warning in Word Mail Merge on Mac

Huda Qurayshi Oct 9, 2026 869 views

Question details

The user encounters a security warning regarding the Excel Workbook Text Converter and finds some dialog fields disabled when attempting a mail merge.

How to Fix Excel Workbook Text Converter Warning in Word Mail Merge on Mac

Product: Microsoft Word / Excel
Device & OS: macOS
Scenario: Using an Excel spreadsheet as the data source for a mail-merge operation in Word on a Mac.
Observed behavior: Word triggers an Excel Workbook Text Converter security warning, and certain fields within the subsequent pop-up dialog are greyed out or unclickable.

Before you start

Verify that your Excel data source is not password-protected and is not currently open in another application, which can restrict Word's ability to read the file.

Solution 1Recommended

Update Software and Use Modern Excel Formats

Updating your system and saving the data source in the modern .xlsx format eliminates the need for older text converters, resolving compatibility prompts.

The text converter warning often indicates that Word is relying on a legacy converter to read an older file type (like .xls). It is not necessarily an error but a security notification. Moving to the native .xlsx format usually bypasses this prompt.

Update macOS and Office

Open 'System Settings' > 'General' > 'Software Update' to ensure macOS is current. Then, open Word, go to 'Help' > 'Check for Updates' and install any pending Microsoft Office updates.

Convert the Excel File

Open your data source in Excel. Click 'File' > 'Save As' and choose 'Excel Workbook (.xlsx)' from the format dropdown. Save it to a local folder like your Documents.

Re-link the Data Source

Open your Word document, navigate to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List'. Browse to your newly saved .xlsx file and select it.

Update Software and Use Modern Excel Formats

Data Connection Restored: Using the native .xlsx format allows Word to read the data source directly, skipping the converter warning and keeping all dialog fields active.

Solution 2

Grant Full Disk Access to Word and Excel

Fixes issues where macOS sandbox restrictions prevent Word from accessing the linked Excel file, which causes greyed-out fields in the converter dialog.

Free Microsoft Office alternative

Perform Seamless Mail Merges with WPS Office

If Microsoft Word's text converter warnings and macOS permission issues are interrupting your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible environment for document creation and data management without the hassle of legacy converter prompts.

1. Open WPS Writer: Launch WPS Office and open your main document in WPS Writer.
2. Start Mail Merge: Navigate to the 'References' tab and click on 'Mail Merge' to activate the toolbar.
3. Import Data Source: Click 'Open Data Source', browse your Mac for your spreadsheet (.xlsx or .csv), and click 'Open' to link the data instantly.
4. Insert Fields and Merge: Use 'Insert Merge Field' to place your data into the document, then click 'Merge to New Document' or 'Merge to Printer' to complete the task.

Highly compatible with Microsoft Office formats (.docx, .xlsx, .csv)Free and lightweight alternative to Microsoft OfficeBuilt-in, intuitive Mail Merge feature without complex converter warningsUnified all-in-one interface for Writer and Spreadsheets

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel Workbook Text Converter warning appear in Word for Mac?

This warning typically triggers when Word uses an internal converter to translate a non-native or older file format (such as an old .xls file or CSV) into readable data for the mail merge. It is a standard macOS and Office security notification.

Can I simply ignore the text converter warning?

Yes, if your data imports correctly after acknowledging the prompt, you can proceed. It is often just an informational security alert rather than a critical failure.

Why are the options in the text converter dialog disabled or greyed out?

Fields may be disabled if macOS is blocking Word's access to the file due to sandbox restrictions, if the Excel workbook is currently open and locked for editing by another application, or if the document contains unsupported legacy macros.

Document & File Issues