Sheets Function

IMPORTRANGE Function: Import Data from Another Google Sheet

About the IMPORTRANGE FunctionOverview of IMPORTRANGEImport Data from Another Google SheetGoogle Sheets Function=IMPORTRANGE( spreadsheet_url, range_string )Sum...

2024.12.21

Sheets Function

GOOGLETRANSLATE Function: Translate Text into a Specified Language in Google Sheets

About the GOOGLETRANSLATE FunctionOverview of GOOGLETRANSLATETranslate Text into a Specified LanguageGoogle Sheets Function=GOOGLETRANSLATE( text, source_langua...

2024.12.21

Sheets Function

IMPORTFEED Function: Import External RSS or ATOM Feeds Using Google Sheets

About the IMPORTFEED FunctionOverview of IMPORTFEEDRetrieve RSS/Atom FeedsGoogle Sheets Function=IMPORTFEED( URL, , , )Overview The IMPORTFEED function retrieve...

2024.12.21

Sheets Function

IMPORTDATA Function: Import External Web Data into Google Sheets

About the IMPORTDATA FunctionOverview of IMPORTDATAImport CSV or TSV FilesGoogle Sheets Function=IMPORTDATA( URL )Summary The IMPORTDATA function retrieves data...

2024.12.20

Sheets Function

QUERY Function: Perform SQL-like Data Operations in Google Sheets

About the QUERY FunctionOverview of QUERYFilter and Manipulate Data Using SQL-like QueriesGoogle Sheets Function=QUERY( data_range, query, )Summary The QUERY fu...

2024.12.20

Sheets Function

ARRAYFORMULA Function: Apply Formulas Across Ranges in Google Sheets

About the ARRAYFORMULA FunctionOverview of ARRAYFORMULAApply Formulas to Multiple Cells at OnceGoogle Sheets Function=ARRAYFORMULA( range or formula )Summary Th...

2024.12.20

Sheets Function

IMPORTXML Function: Extract XML Data from Web Pages in Google Sheets

About the IMPORTXML FunctionOverview of IMPORTXMLExtract Specific Data from Web PagesGoogle Sheets Function=IMPORTXML( URL, XPath Query )Summary The IMPORTXML f...

2024.12.20

Sheets Function

REGEXEXTRACT Function: Extract Text Using Regular Expressions in Google Sheets

About the REGEXEXTRACT FunctionOverview of REGEXEXTRACTText Extraction Using Regular ExpressionsGoogle Sheets Function=REGEXEXTRACT( text, regex )Summary The RE...

2024.12.20

Sheets Function

REGEXMATCH Function: Determine if Text Matches a Regular Expression in Google Sheets

About the REGEXMATCH FunctionOverview of REGEXMATCHPattern Matching Using Regular ExpressionsGoogle Sheets Function=REGEXMATCH( text, regex )Summary The REGEXMA...

2024.12.20

Sheets Function

FLATTEN Function: Convert Rows and Columns into a Single Column List in Google Sheets

About the FLATTEN FunctionOverview of FLATTENConvert Data from a Range into a Single ColumnGoogle Sheets Function=FLATTEN( range_or_value )Summary The FLATTEN f...

2024.12.20

Sheets Function

ISURL Function: Validate Text as a URL in Google Sheets

About the ISURL FunctionOverview of ISURLCheck if a Value is a Valid URLGoogle Sheets Function=ISURL( value )Summary The ISURL function checks whether a specifi...

2024.12.20

Sheets Function

ISEMAIL Function: Validate Email Address Format in Google Sheets

About the ISEMAIL FunctionOverview of ISEMAILCheck if a Value is a Valid Email AddressGoogle Sheets Function=ISEMAIL( value )Summary The ISEMAIL function checks...

2024.12.20

Sheets Function

SORTN Function: Extract and Sort Top N or Unique Values in Google Sheets

About the SORTN FunctionOverview of SORTNSort Data and Extract the Top N EntriesGoogle Sheets Function=SORTN( range, N, , , , ... )Summary The SORTN function so...

2024.12.20

Sheets Function

IMPORTHTML Function: Import HTML Tables and Lists in Google Sheets

About the IMPORTHTML FunctionOverview of IMPORTHTMLImport Tables or Lists from Web PagesGoogle Sheets Function=IMPORTHTML( URL, Query, Index )Summary The IMPORT...

2024.12.20

Sheets Function

SPARKLINE Function: Create Inline Mini Graphs in Google Sheets

About the SPARKLINE FunctionOverview of SPARKLINECreate Simple Graphs Within CellsGoogle Sheets Function=SPARKLINE( data_range, )Summary The SPARKLINE function ...

2024.12.20

Sheets Function

SPLIT Function: Split Text in Google Sheets by Specified Delimiters

About the SPLIT FunctionOverview of SPLITSplit Text Using DelimitersGoogle Sheets Function=SPLIT( text, delimiter, , )Summary The SPLIT function divides a strin...

2024.12.20

Sheets Function