Compare
Excel vs Google Sheets
The two share most function names. The differences matter when a file moves between them.
468Shared by name
62Excel only
47Sheets only
Counts come from our index and match an independent July 2026 comparison. A shared name does not always mean identical arguments.
| Excel only | Closest option on Google Sheets |
|---|---|
| AGGREGATE | SUBTOTAL SUBTOTAL covers part of AGGREGATE. It does not ignore errors. |
| AMORDEGRC | No direct match mapped yet |
| AREAS | No direct match mapped yet |
| ARRAYTOTEXT | JOIN Use JOIN or TEXTJOIN with your own delimiter. |
| BAHTTEXT | No direct match mapped yet |
| BESSELI | No direct match mapped yet |
| BESSELJ | No direct match mapped yet |
| BESSELK | No direct match mapped yet |
| BESSELY | No direct match mapped yet |
| BINOM.DIST.RANGE | No direct match mapped yet |
| CALL | No direct match mapped yet |
| COPILOT | AI Both run prompts in a cell. Review prompts and outputs after moving. |
| CUBEKPIMEMBER | No direct match mapped yet |
| CUBEMEMBER | No direct match mapped yet |
| CUBEMEMBERPROPERTY | No direct match mapped yet |
| CUBERANKEDMEMBER | No direct match mapped yet |
| CUBESET | No direct match mapped yet |
| CUBESETCOUNT | No direct match mapped yet |
| CUBEVALUE | No direct match mapped yet |
| DBCS | No direct match mapped yet |
| DROP | No direct match mapped yet |
| ECMA.CEILING | No direct match mapped yet |
| EUROCONVERT | No direct match mapped yet |
| EXPAND | No direct match mapped yet |
| FIELDVALUE | No direct match mapped yet |
| FILTERXML | IMPORTXML IMPORTXML reads from a URL, not from a text value. |
| FORECAST.ETS | No direct match mapped yet |
| FORECAST.ETS.CONFINT | No direct match mapped yet |
| FORECAST.ETS.SEASONALITY | No direct match mapped yet |
| FORECAST.ETS.STAT | No direct match mapped yet |
| GROUPBY | QUERY Rewrite as a select statement with group by. |
| IMPORTCSV | IMPORTDATA IMPORTDATA reads a file at a public URL. |
| IMPORTTEXT | IMPORTDATA IMPORTDATA reads a file at a public URL. |
| INFO | No direct match mapped yet |
| ISOMITTED | No direct match mapped yet |
| JIS | No direct match mapped yet |
| NUMBERVALUE | No direct match mapped yet |
| ODDFPRICE | No direct match mapped yet |
| ODDFYIELD | No direct match mapped yet |
| ODDLPRICE | No direct match mapped yet |
| ODDLYIELD | No direct match mapped yet |
| PERCENTOF | No direct match mapped yet |
| PHONETIC | No direct match mapped yet |
| PIVOTBY | QUERY Use a query with group by and pivot. |
| PY | No direct match mapped yet |
| REGEXTEST | REGEXMATCH Both return TRUE or FALSE. Excel adds an optional case setting. |
| REGISTER.ID | No direct match mapped yet |
| RTD | No direct match mapped yet |
| SINGLE | No direct match mapped yet |
| SORTBY | SORT SORT accepts a sort column or a matching range. |
| SQL.REQUEST | No direct match mapped yet |
| STOCKHISTORY | GOOGLEFINANCE Both return market data. Arguments differ. |
| TABLE | No direct match mapped yet |
| TAKE | ARRAY_CONSTRAIN ARRAY_CONSTRAIN keeps the first rows and columns. Taking from the end needs another approach. |
| TEXTAFTER | REGEXEXTRACT Write a pattern such as "@(.+)$" to capture the text after a delimiter. |
| TEXTBEFORE | REGEXEXTRACT Write a pattern such as "^(.*?)," to capture the text before a delimiter. |
| TEXTSPLIT | SPLIT SPLIT covers column splits. Row delimiters need a different approach. |
| TRANSLATE | GOOGLETRANSLATE Language codes work the same way for most languages. |
| TRIMRANGE | No direct match mapped yet |
| VALUETOTEXT | TO_TEXT TO_TEXT converts a value to text. |
| WEBSERVICE | IMPORTDATA IMPORTDATA reads CSV or TSV at a URL. |
| XMATCH | MATCH Use MATCH with 0 for exact matches. |
| Google Sheets only | Closest option on Excel |
|---|---|
| ADD | No direct match mapped yet |
| AI | COPILOT Both run prompts in a cell. Review prompts and outputs after moving. |
| ARRAY_CONSTRAIN | No direct match mapped yet |
| ARRAYFORMULA | Dynamic arrays Modern Excel spills array results without a wrapper. |
| AVERAGE.WEIGHTED | SUMPRODUCT Use =SUMPRODUCT(values,weights)/SUM(weights). |
| COUNTUNIQUE | COUNTA Use =COUNTA(UNIQUE(range)) in modern Excel. |
| DIVIDE | No direct match mapped yet |
| EPOCHTODATE | No direct match mapped yet |
| EQ | No direct match mapped yet |
| FLATTEN | TOCOL TOCOL also has options to skip blanks and errors. |
| GOOGLEFINANCE | STOCKHISTORY Both return market data. Arguments differ. |
| GOOGLETRANSLATE | TRANSLATE Language codes work the same way for most languages. |
| GT | No direct match mapped yet |
| GTE | No direct match mapped yet |
| IMCOTH | No direct match mapped yet |
| IMLOG | No direct match mapped yet |
| IMPORTDATA | WEBSERVICE Power Query is usually the better route for CSV data. |
| IMPORTFEED | No direct match mapped yet |
| IMPORTHTML | Power Query Use From Web in Get Data. |
| IMPORTRANGE | Power Query Connect to the other workbook through Get Data. |
| IMPORTXML | Power Query Use Get Data for XML sources. |
| IMTANH | No direct match mapped yet |
| ISBETWEEN | AND Use =AND(A2>=low,A2<=high). |
| ISDATE | No direct match mapped yet |
| ISEMAIL | No direct match mapped yet |
| ISURL | No direct match mapped yet |
| JOIN | TEXTJOIN Add a second argument to TEXTJOIN for skipping blanks. |
| LT | No direct match mapped yet |
| LTE | No direct match mapped yet |
| MARGINOFERROR | No direct match mapped yet |
| MINUS | No direct match mapped yet |
| MULTIPLY | No direct match mapped yet |
| NE | No direct match mapped yet |
| POW | No direct match mapped yet |
| QUERY | GROUPBY GROUPBY and PIVOTBY cover grouped totals. Power Query suits larger jobs. |
| REGEXMATCH | REGEXTEST Both return TRUE or FALSE. |
| SORTN | TAKE Combine TAKE and SORT, as in =TAKE(SORT(range,2,-1),5). |
| SPARKLINE | Sparklines feature Excel adds sparklines from the Insert tab, not with a function. |
| SPLIT | TEXTSPLIT Excel treats the delimiter as one whole string by default. |
| TO_DATE | No direct match mapped yet |
| TO_DOLLARS | No direct match mapped yet |
| TO_PERCENT | No direct match mapped yet |
| TO_PURE_NUMBER | No direct match mapped yet |
| TO_TEXT | TEXT Add a format code to TEXT. |
| UMINUS | No direct match mapped yet |
| UNARY_PERCENT | No direct match mapped yet |
| UPLUS | No direct match mapped yet |
Moving a workbook
- Run the file's formulas through the Excel to Sheets Converter.
- Rebuild Excel Tables, Power Query and macros. These do not move as they are.
- Replace VBA with Apps Script, or replace Apps Script with Office Scripts or VBA.
- Check regional separators, dates and any external links after the move.