Skip to content

Google Sheets google functions

Google functions in Google Sheets, explained with live examples.

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

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.
DETECTLANGUAGE
Identifies the language used in text within the specified range.
GOOGLEFINANCE
Fetches current or historical securities information from Google Finance.
GOOGLETRANSLATE
Translates text from one language into another
IMAGE
Inserts an image into a cell.
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