Google Sheets Functions

ARRAYFORMULA wraps a formula and applies it to every cell in a range at once, so you don't need to copy formulas down.

DETECTLANGUAGE tells you what language a piece of text is written in.

GOOGLEFINANCE pulls live stock prices, currency rates, and historical market data into your spreadsheet.

GOOGLETRANSLATE translates text in a cell from a source language to a target language.

IMAGE inserts a picture from a URL into a spreadsheet cell and lets you control its size and cropping.

IMPORTRANGE imports a range from another Google Sheets file by its spreadsheet URL and a range reference.

QUERY lets you run SQL-like commands on your spreadsheet data. Filter, sort, aggregate, pivot — all in one formula. It's the Swiss Army knife of Google Sheets data manipulation.

REGEXEXTRACT pulls out the part of a text that matches a regular expression pattern.

REGEXMATCH returns TRUE if the text matches a regular expression pattern, otherwise FALSE.

REGEXREPLACE searches text for a pattern and replaces matching parts with new text.

SPARKLINE draws a tiny chart in a cell from a range of numbers, with options for line, bar, column, and win/loss charts.