Formatting Issues

Fix Excel Conditional Formatting Missing When Importing to Word

Maira Mehtab Sep 22, 2026 870 views

Question details

The user needs to retain Excel conditional formatting when importing data into a Word document via the Excel2Word add-in.

Product: Excel, Word, Excel2Word Add-in
Device & OS: not provided
Scenario: Importing spreadsheet data into a document using a third-party add-in.
Observed behavior: Conditional formatting is no longer visible in Word after the import process, despite it working correctly three months prior.

Before you start

Verify your current version of the Excel2Word add-in and ensure both Excel and Word are fully updated before attempting to embed the data manually.

Solution 1Recommended

Insert the Excel Range as an Embedded Object

Bypassing the add-in and embedding the Excel file directly into Word ensures all conditional formatting remains intact.

Excel formatting is not always fully preserved in Word due to differences in how each application handles complex styling. Inserting the worksheet as an embedded object guarantees that Excel's native rendering, including conditional rules, is maintained.

Open the Object Dialog

Open your Word document, navigate to the 'Insert' tab on the ribbon, and click on 'Object' in the Text group.

Select the Excel File

Choose the 'Create from File' tab in the Object dialog box, and click 'Browse' to locate your Excel workbook.

Embed the Worksheet

Select your file, click 'Insert', and then click 'OK'. The Excel data will now appear in your Word document with all conditional formatting clearly visible.

Link Option: You can check the 'Link to file' box before clicking OK if you want the Word document to update automatically whenever the original Excel file is modified.

Solution 2

Contact the Excel2Word Add-in Provider

Since the issue started recently, the add-in may have a bug or compatibility issue with recent Office updates.

Seamlessly Integrate Spreadsheets and Documents

Use WPS Office to Keep Spreadsheet Formatting Intact

WPS Office provides seamless integration between WPS Spreadsheet and WPS Writer. You can easily insert spreadsheet data into documents without losing conditional formatting, eliminating the need for unreliable third-party add-ins.

1. Prepare Your Document: Open your document in WPS Writer and place your cursor where you want the table to appear.
2. Insert the Spreadsheet: Navigate to the 'Insert' tab, click on 'Object', and select 'Create from file' to choose your saved spreadsheet.
3. Confirm and View: Click 'OK'. The spreadsheet is natively embedded, preserving all intricate conditional formatting without needing extra plugins.

Native compatibility with Microsoft Excel (.xlsx) and Word (.docx) formatsSeamless object embedding across all applicationsFree, lightweight, and easy-to-use office alternativeNo need for external add-ins to transfer data

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't standard copy-pasting preserve Excel conditional formatting in Word?

Word uses a different rendering engine for its native tables, which often strips complex Excel styling like conditional formatting data bars or color scales unless pasted as a picture or an embedded object.

Can I edit the embedded Excel data directly inside Word?

Yes. If you insert the Excel data as an embedded object, you can double-click the table in Word. This opens an Excel interface right within your document, allowing you to edit values and see conditional formatting update in real-time.

What should I do if the embedded Excel object looks cut off in Word?

Double-click the embedded object to activate it, then carefully adjust the row and column boundaries using the sizing handles to ensure all your formatted data is visible before clicking outside the object to save changes.

Document & File Issues