| ARRAYFORMULA | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| QUERY | No Excel equivalent. Rebuild with FILTER, SORT, GROUPBY (365) or Power Query. |
| IMPORTRANGE | Use a workbook link or Power Query in Excel. |
| IMPORTHTML | Excel: Data → From Web (Power Query). |
| IMPORTXML | Excel: Power Query, or WEBSERVICE + FILTERXML. |
| IMPORTDATA | Excel: Data → From Text/CSV. |
| IMPORTFEED | No Excel equivalent. |
| GOOGLEFINANCE | Closest: STOCKHISTORY or the Stocks data type in Excel 365. |
| GOOGLETRANSLATE | Microsoft 365 has a TRANSLATE function; older versions do not. |
| DETECTLANGUAGE | No Excel equivalent. |
| SPARKLINE | Excel: Insert → Sparklines (a feature, not a function). |
| FLATTEN | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| SPLIT | Converts only supported literal delimiters, with explicit empty-item options. Other argument combinations are preserved. |
| JOIN | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| COUNTUNIQUE | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| ISBETWEEN | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| REGEXMATCH | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| REGEXEXTRACT | Excel supports it only in Microsoft 365, and the regex flavor differs (RE2 vs PCRE2). |
| REGEXREPLACE | Excel supports it only in Microsoft 365, and the regex flavor differs (RE2 vs PCRE2). |
| TO_TEXT | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| TO_PERCENT | In Excel this is a number format, not a function. |
| TO_DATE | In Excel this is a date format, not a function. |
| EPOCHTODATE | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| ISEMAIL | Not in Excel. Approximate with ISNUMBER(SEARCH("@",value)). |
| ISURL | No Excel equivalent. |
| ISDATE | Excel: use ISNUMBER(DATEVALUE(value)). |
| ARRAY_CONSTRAIN | Excel 365: TAKE(array, rows, cols). |
| SORTN | Excel 365: combine TAKE(SORT(range), n). |
| POW | Same as Excel POWER. |
| ADD | Rewritten as (a+b). |
| MINUS | Rewritten as (a-b). |
| MULTIPLY | Rewritten as (a*b). |
| DIVIDE | Rewritten as (a/b). |
| UMINUS | Rewritten as (-a). |
| TEXTSPLIT | Converts only supported literal delimiters, with explicit empty-item options. Other argument combinations are preserved. |
| TEXTBEFORE | Not in Sheets. Use LEFT(A1,FIND(delim,A1)-1) or REGEXEXTRACT. |
| TEXTAFTER | Not in Sheets. Use MID+FIND, REGEXEXTRACT, or INDEX(SPLIT(...),2). |
| REGEXTEST | Array, blank, formatting or option semantics may differ. The original is preserved for review in the destination app. |
| TAKE | Not in Sheets. Use ARRAY_CONSTRAIN or QUERY … LIMIT. |
| DROP | Not in Sheets. Use OFFSET or QUERY … OFFSET. |
| EXPAND | No Sheets equivalent. |
| GROUPBY | Sheets: QUERY(range, "select A, sum(B) group by A"). |
| PIVOTBY | Sheets: use a pivot table or QUERY. |
| AGGREGATE | Not in Sheets. Use SUBTOTAL, or filter errors with IFERROR. |
| WEBSERVICE | Sheets: IMPORTDATA or IMPORTXML. |
| FILTERXML | Sheets: IMPORTXML(url, xpath). |
| STOCKHISTORY | Sheets: GOOGLEFINANCE. |
| RTD | No Sheets equivalent. |
| DATEDIF | Check supported units and month-end or leap-year boundaries in the destination app. |
| CONCAT | Excel CONCAT takes ranges; Sheets CONCAT takes exactly two values. The & operator is safer. |