Google Sheets only functions
All 13 functions in this category
QUERYQuery a dataset using SQL-like syntax to filter, sort, and extract specific rows and columns that match your conditions.ARRAYFORMULAARRAYFORMULA applies a single formula to an entire array or range, automatically filling results into multiple cells.IMPORTRANGEIMPORTRANGE retrieves a specified range of cells from another Google Sheet and displays it in the current sheet.IMPORTHTMLFetches HTML tables or lists from a webpage and returns them as a 2D array, useful for importing public data without manual copying.IMPORTXMLIMPORTXML extracts and returns specific data from XML or HTML documents by evaluating an XPath query against the content at a URL.IMPORTDATAImports delimited data from a URL and returns it as a range of cells in your spreadsheet, parsing content automatically for immediate use.IMPORTFEEDIMPORTFEED imports items from RSS and Atom feeds into a spreadsheet, parsing structured feed data into rows and columns.GOOGLEFINANCEGOOGLEFINANCE retrieves real-time and historical financial data from Google Finance, including stock prices, volume, and market metrics for any ticker.GOOGLETRANSLATETranslates text between languages using Google's translation service, with automatic source language detection when not specified.DETECTLANGUAGEDETECTLANGUAGE returns the ISO 639-1 language code of input text, enabling language-based filtering and analysis of multilingual support tickets.SPARKLINESPARKLINE displays a miniature chart within a cell to visualize data trends and patterns without taking up extra space.FLATTENFLATTEN converts a 2D range into a single column, automatically removing empty cells and combining multiple ranges vertically.REGEXMATCHTests whether a text string matches a regular expression pattern; returns TRUE for matches and FALSE for non-matches.
Also relevant here
These live in another category but come up constantly in Google Sheets only work.