How to Fix Google Sheets Functions Converted to DUMMYFUNCTION in Excel
Question details
The user needs to resolve an issue where Google Sheets functions like ARRAYFORMULA and REGEXMATCH convert into _xlfn or _xludf.DUMMYFUNCTION expressions when downloaded and opened in a desktop spreadsheet application.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Downloading a cloud-based Google Sheets workbook to local storage and opening the exported XLSX file in Excel.
- Observed behavior
- Google-exclusive formulas fail to calculate and display as _xlfn, _xludf.DUMMYFUNCTION, or #NAME? errors in the formula bar and cells.
Identify the original Google Sheets functions used in your document before downloading, so you know exactly which logic needs to be mapped to standard spreadsheet equivalents.
Manually Replace Google Sheets Functions with Compatible Desktop Formulas
Since desktop spreadsheet applications do not natively support specific Google functions like ARRAYFORMULA and REGEXMATCH, you must reconstruct the original calculation logic using universally supported spreadsheet functions.
When an exported XLSX file contains formulas that don't exist in Excel's native library, the application protects the data integrity by wrapping the unknown syntax in a DUMMYFUNCTION placeholder.
To resolve this, you must rewrite the formula using standard alternative functions. For example, REGEXMATCH can often be replaced by combining SEARCH and ISNUMBER, while complex ARRAYFORMULAs can be replaced by utilizing native dynamic arrays or standard drag-to-fill techniques.
Double-click the cell displaying the DUMMYFUNCTION or #NAME? error, or select the cell and click into the formula bar at the top of the screen.
Highlight and delete the _xludf.DUMMYFUNCTION prefix and the unsupported Google-specific formula text.
Type an equal sign (=) and reconstruct the desired logic using supported nested functions. Depending on the goal, you may need to combine IF, ISBLANK, AND, CONCAT, COUNTIF, and IFERROR functions.
Press the Enter key to execute the updated formula. If replacing an ARRAYFORMULA, you may need to click and drag the fill handle (the small square at the bottom-right corner of the cell) down the column to apply the calculation to the remaining rows.

Manage Spreadsheets Seamlessly with WPS Office
Avoid compatibility headaches and subscription fees when working with complex spreadsheets. WPS Office is a highly compatible, robust alternative to Microsoft Office that flawlessly handles standard XLSX files and advanced functions.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office installer and follow the on-screen instructions.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your downloaded Google Sheets XLSX file directly.
- 3. Edit Formulas: Use the highly compatible formula engine to rewrite and calculate your complex data effortlessly.

Frequently Asked Questions
What does _xlfn or _xludf.DUMMYFUNCTION mean in my spreadsheet?
These prefixes indicate that the spreadsheet contains a formula or function native to another application (such as Google Sheets) or a newer software version that your current desktop spreadsheet application does not recognize.
How can I fix the #NAME? error caused by DUMMYFUNCTION?
You need to manually edit the affected cell, remove the unsupported function text, and rewrite the mathematical or logical operation using standard, universally supported functions like IF, VLOOKUP, INDEX, or MATCH.
Is there a way to make ARRAYFORMULA work in Excel?
Excel does not have a direct equivalent to the ARRAYFORMULA function. However, newer versions support dynamic arrays natively, meaning you can often type the array calculation directly, or simply write a standard formula and drag the fill handle down to apply it to the entire range.
Can I prevent DUMMYFUNCTION errors when exporting from Google Sheets?
Yes, you can prevent this by auditing your Google Sheets file before export and replacing Google-exclusive functions with universally supported standard spreadsheet formulas before downloading it as an XLSX document.




