Fix @__xludf.DUMMYFUNCTION Error When Exporting Google Sheets to Excel
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.

- 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.
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.
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.
Click on the specific cell in your worksheet that displays the @__xludf.DUMMYFUNCTION error.
Press the Delete key or click into the Formula Bar and erase the existing text to start fresh.
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").
Press the Enter key. The results will automatically spill into adjacent empty cells if multiple matches are found.
Use XLOOKUP or INDEX/MATCH for Older Versions
If you are using Excel 2019 or older, or if you only need to return a single matching value rather than an array, use alternative lookup functions.
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. Open your file in WPS Spreadsheet: Launch WPS Office and open the downloaded XLSX file containing the formula errors.
- 2. Select the error cell: Locate the cell showing the @__xludf.DUMMYFUNCTION error and click to highlight it.
- 3. Rewrite the formula: Clear the error from the Formula Bar and type =FILTER( followed by your specific array and condition parameters.
- 4. Apply and evaluate: Press Enter to execute the formula. WPS Spreadsheet will automatically spill the filtered results into the surrounding cells.

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.




