Skip to content

Google Sheets google functions

Google functions in Google Sheets, explained with live examples.

7 google functions in Google Sheets2 documented in depth so far, the rest indexed below and landing every week.

Documented google functions

Syntax, examples, and the equivalent — ready now.

All Google Sheets google functions

The full set — deep dives on the way.

ARRAYFORMULA
Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.
GOOGLEFINANCE
Fetches current or historical securities information from Google Finance.
GOOGLETRANSLATE
Translates text from one language into another
QUERY
Runs a Google Visualization API Query Language query across data.
SPARKLINE
Creates a miniature chart contained within a single cell.

More Google Sheets function categories