Google Sheets functions that don't exist in Excel
QUERY, ARRAYFORMULA, IMPORTRANGE, GOOGLEFINANCE, the REGEX family… these work only in Google Sheets. Export the file to .xlsx and every cell using them fails.
47 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? |
|---|---|---|
| AI | AI | No |
| ARRAY_CONSTRAIN | Array | No |
| FLATTEN | Array | No |
| EPOCHTODATE | Date | No |
| IMCOTH | Engineering | No |
| IMLOG | Engineering | No |
| IMTANH | Engineering | No |
| SORTN | Filter | No |
| ARRAYFORMULA | No | |
| GOOGLEFINANCE | No | |
| GOOGLETRANSLATE | No | |
| QUERY | No | |
| SPARKLINE | No | |
| ISDATE | Info | No |
| ISEMAIL | Info | No |
| COUNTUNIQUE | Math | No |
| ADD | Operator | No |
| DIVIDE | Operator | No |
| EQ | Operator | No |
| GT | Operator | No |
| GTE | Operator | No |
| ISBETWEEN | Operator | No |
| LT | Operator | No |
| LTE | Operator | No |
| MINUS | Operator | No |
| MULTIPLY | Operator | No |
| NE | Operator | No |
| POW | Operator | No |
| UMINUS | Operator | No |
| UNARY_PERCENT | Operator | No |
| UPLUS | Operator | No |
| TO_DATE | Parser | No |
| TO_DOLLARS | Parser | No |
| TO_PERCENT | Parser | No |
| TO_PURE_NUMBER | Parser | No |
| TO_TEXT | Parser | No |
| AVERAGE.WEIGHTED | Statistical | No |
| MARGINOFERROR | Statistical | No |
| JOIN | Text | No |
| REGEXMATCH | Text | No |
| SPLIT | Text | No |
| IMPORTDATA | Web | No |
| IMPORTFEED | Web | No |
| IMPORTHTML | Web | No |
| IMPORTRANGE | Web | No |
| IMPORTXML | Web | No |
| ISURL | Web | No |
Portable alternatives exist for many of these — FILTER/SORT/UNIQUE for much of QUERY, native spilling instead of ARRAYFORMULA — see the comparison pages for migration patterns.