QUERY, ARRAYFORMULA, SPARKLINE and other Google Sheets functions

Updated November 13, 2026

If you’ve used Google Sheets, its functions work here too, beside Excel’s, and the workbook still saves as .xlsx.

Monthly sales with a sparkline in each row and a QUERY listing the top stores

Some favourites

  • QUERY: sort, filter and summarise a range with one formula, such as =QUERY(A1:E6,"select A, E where E > 3500 order by E desc",1).
  • ARRAYFORMULA: work a formula over a whole range at once.
  • SPARKLINE: a small line or bar chart inside a cell, such as =SPARKLINE(B2:E2).
  • SPLIT and JOIN: break text apart or put it together.
  • REGEXMATCH, REGEXEXTRACT and REGEXREPLACE: match and change text with patterns.
  • COUNTUNIQUE, SORTN, FLATTEN and ARRAY_CONSTRAIN: count, sort and shape ranges.
  • IMPORTRANGE, IMPORTHTML, IMPORTXML and IMPORTDATA: bring in data. See Import data from the web and other workbooks.
  • GOOGLETRANSLATE and DETECTLANGUAGE: see Translate text in cells.

Good to know

  • Excel doesn’t have these functions. If someone opens the workbook in Excel, these cells show an error there. They work again when the file is opened in Cloud Sheets.
  • SPLIT splits on each character you give it by default, as Google Sheets does: =SPLIT("a, b",", ") splits on the comma and on the space. Add FALSE as the third argument to split on the whole text.
  • GOOGLEFINANCE isn’t available.

Was this article helpful?