# Google Sheets functions that differ from Excel

> Most formulas work the same way in Google Sheets and Excel. These are the ones that don't: functions only Sheets has, and functions whose arguments differ.

Source: https://spreadsheetpractice.com/google-sheets/functions · Updated October 29, 2026

| Function | What it does | Availability |
|---|---|---|
| [QUERY](https://spreadsheetpractice.com/google-sheets/query) | Runs a SQL-like query over a range: select, where, group by, pivot, order by, label. | Sheets only |
| [IMPORTRANGE](https://spreadsheetpractice.com/google-sheets/importrange) | Pulls a range from another spreadsheet, once the two files are connected. | Sheets only |
| [GOOGLEFINANCE](https://spreadsheetpractice.com/google-sheets/googlefinance) | Stock and currency data: a price now, or a table of history. | Sheets only |
| [ARRAYFORMULA](https://spreadsheetpractice.com/google-sheets/functions/arrayformula) | ARRAYFORMULA lets one formula work on whole ranges instead of single cells. | Sheets only |
| [FILTER](https://spreadsheetpractice.com/google-sheets/functions/filter) | FILTER returns the rows of a range that meet the conditions you give it. | Different in Excel |
| [SORT](https://spreadsheetpractice.com/google-sheets/functions/sort) | SORT returns a range sorted by one or more columns and leaves the original data where it is. | Different in Excel |
| [SPLIT](https://spreadsheetpractice.com/google-sheets/functions/split) | SPLIT breaks text into pieces at a delimiter and puts each piece in its own cell to the right. | Sheets only |
| [JOIN](https://spreadsheetpractice.com/google-sheets/functions/join) | JOIN combines the values in one or more rows or columns into a single piece of text, with a delimiter between each value. | Sheets only |
| [COUNTUNIQUE](https://spreadsheetpractice.com/google-sheets/functions/countunique) | COUNTUNIQUE counts how many different values appear in a range, ignoring blank cells. | Sheets only |
| [REGEXMATCH](https://spreadsheetpractice.com/google-sheets/functions/regexmatch) | REGEXMATCH checks whether text contains a match for a regular expression and returns TRUE or FALSE. | Sheets only |
| [REGEXEXTRACT](https://spreadsheetpractice.com/google-sheets/functions/regexextract) | REGEXEXTRACT pulls out the part of the text that matches a regular expression. | Sheets only |
| [REGEXREPLACE](https://spreadsheetpractice.com/google-sheets/functions/regexreplace) | REGEXREPLACE replaces every part of the text that matches a regular expression. | Sheets only |
| [TO_TEXT](https://spreadsheetpractice.com/google-sheets/functions/to-text) | TO_TEXT converts a number into text. | Sheets only |

Functions that work the same way in both (XLOOKUP, SUMIFS, IFERROR, UNIQUE and more) are in the [Excel functions list](https://spreadsheetpractice.com/functions).

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
