Excel functions that don't exist in Google Sheets
PIVOTBY, GROUPBY, the CUBE family, AGGREGATE and more are documented for Excel but absent from Google Sheets — importing an .xlsx that uses them leaves broken formulas.
53 functions, from each vendor’s official documentation — with LibreOffice’s status from our executed tests where available. Formulas using these break with #NAME? when a file moves to the other app.
| Function | Category | Also in LibreOffice? |
|---|---|---|
| CALL | Add-in and Automation | No |
| EUROCONVERT | Add-in and Automation | Yes (tested) |
| REGISTER.ID | Add-in and Automation | No |
| CUBEKPIMEMBER | Cube | No (tested) |
| CUBEMEMBER | Cube | No (tested) |
| CUBEMEMBERPROPERTY | Cube | No (tested) |
| CUBERANKEDMEMBER | Cube | No (tested) |
| CUBESET | Cube | No (tested) |
| CUBESETCOUNT | Cube | No (tested) |
| CUBEVALUE | Cube | No (tested) |
| BESSELI | Engineering | Yes, with quirks |
| BESSELJ | Engineering | Yes, with quirks |
| BESSELK | Engineering | Yes, with quirks |
| BESSELY | Engineering | Yes, with quirks |
| AMORDEGRC | Financial | Yes, with quirks |
| ODDFPRICE | Financial | Yes, with quirks |
| ODDFYIELD | Financial | Yes, with quirks |
| ODDLPRICE | Financial | Yes, with quirks |
| ODDLYIELD | Financial | Yes, with quirks |
| INFO | Information | Yes, with quirks |
| ISOMITTED | Information | No (tested) |
| STOCKHISTORY | Information | No (tested) |
| AREAS | Lookup and reference | Yes (tested) |
| DROP | Lookup and reference | Yes (tested) |
| EXPAND | Lookup and reference | Yes (tested) |
| GROUPBY | Lookup and reference | No (tested) |
| PIVOTBY | Lookup and reference | No (tested) |
| RTD | Lookup and reference | No (tested) |
| SORTBY | Lookup and reference | Yes (tested) |
| TAKE | Lookup and reference | Yes (tested) |
| TRIMRANGE | Lookup and reference | No (tested) |
| AGGREGATE | Math and trigonometry | Yes (tested) |
| PERCENTOF | Math and trigonometry | No (tested) |
| BINOM.DIST.RANGE | Statistical | No (tested) |
| FORECAST.ETS | Statistical | Yes (tested) |
| FORECAST.ETS.CONFINT | Statistical | Yes, with quirks |
| FORECAST.ETS.SEASONALITY | Statistical | Yes, with quirks |
| FORECAST.ETS.STAT | Statistical | Yes, with quirks |
| ARRAYTOTEXT | Text | No (tested) |
| BAHTTEXT | Text | Yes (tested) |
| COPILOT | Text | No (tested) |
| DBCS | Text | No (tested) |
| JIS | Text | Yes (tested) |
| NUMBERVALUE | Text | Yes (tested) |
| PHONETIC | Text | No (tested) |
| REGEXTEST | Text | No (tested) |
| TEXTAFTER | Text | Yes (tested) |
| TEXTBEFORE | Text | Yes (tested) |
| TEXTSPLIT | Text | Yes (tested) |
| TRANSLATE | Text | No (tested) |
| VALUETOTEXT | Text | No (tested) |
| FILTERXML | Web | Yes (tested) |
| WEBSERVICE | Web | Documented |
The LibreOffice column shows that "Excel-only" is often really "not-in-Sheets": several of these run fine in LibreOffice Calc per our executed tests.
See the Excel ↔ Google Sheets equivalents table for the documented replacement to use for each. Part of the Excel vs Google Sheets formula compatibility guide.