Google Sheets functions
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 change between the two. Each page has live examples and a graded exercise in Sheets mode.
Sheets-only and Sheets-specific
QUERY | Runs a SQL-like query over a range: select, where, group by, order by, label. | Sheets only |
|---|---|---|
ARRAYFORMULA | ARRAYFORMULA lets one formula work on whole ranges instead of single cells. | Sheets only |
FILTER | FILTER returns the rows of a range that meet the conditions you give it. | Different in Excel |
SORT | SORT returns a range sorted by one or more columns and leaves the original data where it is. | Different in Excel |
SPLIT | SPLIT breaks text into pieces at a delimiter and puts each piece in its own cell to the right. | Sheets only |
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 | COUNTUNIQUE counts how many different values appear in a range, ignoring blank cells. | Sheets only |
REGEXMATCH | REGEXMATCH checks whether text contains a match for a regular expression and returns TRUE or FALSE. | Sheets only |
REGEXEXTRACT | REGEXEXTRACT pulls out the part of the text that matches a regular expression. | Sheets only |
REGEXREPLACE | REGEXREPLACE replaces every part of the text that matches a regular expression. | Sheets only |
TO_TEXT | TO_TEXT converts a number into text. | Sheets only |
Functions that work the same way
These behave the same in Google Sheets as in current Excel, so our 129-function library covers them. A few of the most used: