Formula Errors

Fix @__xludf.DUMMYFUNCTION Error When Exporting Google Sheets to Excel

Phi Hung VoPhi Hung Vo Oct 12, 2026 877 views

Question details

The user needs to resolve an issue where a Google Sheets FILTER formula converts into an unusable @__xludf.DUMMYFUNCTION error when downloaded as an Excel XLSX file.

How to Fix the @__xludf.DUMMYFUNCTION Error After Google Sheets to Excel Conversion
Product
Microsoft Excel
Device & OS
not provided
Scenario
Downloading a Google Sheets workbook containing specific dynamic array functions like FILTER and opening it in Excel.
Observed behavior
The Excel file fails to process the Google Sheets formula, resulting in an @__xludf.DUMMYFUNCTION error instead of the filtered data.
Before you start

Verify whether your current version of Excel supports dynamic array formulas (such as Microsoft 365 or Excel 2021). If you are using an older version, you will need to rely on traditional lookup formulas.

Solution 1Recommended

Replace with Excel's Native FILTER Function

If you are using a modern version of Excel, rewrite the error formula using Excel's built-in FILTER function to achieve the exact same dynamic results.

Modern versions of Excel (Microsoft 365, Excel 2021, and Excel for the Web) natively support the FILTER function. However, during the export process, Google Sheets often writes its own proprietary function signature into the file, causing Excel to fail when reading it.

1
Select the error cell

Click on the specific cell in your worksheet that displays the @__xludf.DUMMYFUNCTION error.

2
Clear the corrupted formula

Press the Delete key or click into the Formula Bar and erase the existing text to start fresh.

3
Enter the new FILTER formula

Type =FILTER(array, include, [if_empty]) into the Formula Bar. For example, select your data range, then specify the criteria range such as =FILTER(A2:B10, A2:A10="Holiday", "Not Found").

4
Apply dynamic array

Press the Enter key. The results will automatically spill into adjacent empty cells if multiple matches are found.

Formatting the Results: To fulfill the requirement of showing holidays in uppercase, you can wrap your entire formula in the UPPER function: =UPPER(FILTER(...)). Use Conditional Formatting from the Home tab to turn the text red.
Seamless Spreadsheet Editing

Fix Formula Compatibility Errors Effortlessly with WPS Spreadsheet

WPS Spreadsheet provides comprehensive native support for advanced dynamic array functions, including FILTER, XLOOKUP, and UNIQUE. It seamlessly opens XLSX files exported from Google Sheets or Microsoft Excel, allowing you to quickly replace broken expressions and analyze your data without compatibility barriers.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the downloaded XLSX file containing the formula errors.
  2. 2. Select the error cell: Locate the cell showing the @__xludf.DUMMYFUNCTION error and click to highlight it.
  3. 3. Rewrite the formula: Clear the error from the Formula Bar and type =FILTER( followed by your specific array and condition parameters.
  4. 4. Apply and evaluate: Press Enter to execute the formula. WPS Spreadsheet will automatically spill the filtered results into the surrounding cells.
Full compatibility with Microsoft Excel formats (.xlsx, .xls, .csv)Native support for advanced dynamic array formulas like FILTER and XLOOKUPLightweight application that opens large data files instantlyFamiliar user interface requiring zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Google Sheets formula change to DUMMYFUNCTION in Excel?

This occurs because the Google Sheets export process writes certain specific functions (like FILTER or custom scripts) using an internal syntax. Since Excel does not recognize this proprietary Google signature, it replaces the formula with the @__xludf.DUMMYFUNCTION error.

Does Excel support the FILTER function?

Yes, but only in Microsoft 365, Excel 2021, and Excel for the Web. If you export a Google Sheet containing the FILTER function and open it in an older version of Excel (like Excel 2016 or 2019), the function will not evaluate correctly.

How do I make the matched holiday names appear in uppercase and red?

You can transform the text to uppercase by wrapping your lookup formula inside the UPPER function, such as =UPPER(XLOOKUP(...)). To make the text red, highlight the cells, go to the Home tab, click 'Conditional Formatting', create a New Rule based on cell value, and set the font format to red.

Can I prevent this error before downloading from Google Sheets?

Unfortunately, you cannot prevent Google Sheets from altering the formula signature upon export if the function mapping isn't perfectly supported. The most reliable workaround is to download the file and quickly replace the broken formula with native Excel syntax.