
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...

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...

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...

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...

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...

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...

What Are the Differences Between Google Sheets and Excel? Can Google Sheets Replace Excel?
Comparison Between Google Sheets and ExcelFeatureGoogle SheetsMicrosoft ExcelPricingFree to use (requires a Google account)Paid (Microsoft 365 subscription or o...

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...

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...

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...

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...

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...

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...

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...

Can VBA Be Used in Google Sheets? Here’s the Answer and Alternatives
Can VBA Be Used in Google Sheets?VBA (Visual Basic for Applications) from Microsoft Excel cannot be directly used in Google Sheets. This is because Google Sheet...

Differences Between Google Apps Script and JavaScript in Google Sheets
Differences Between Google Apps Script and JavaScriptGoogle Apps Script is based on JavaScript but differs in several key aspects, which are outlined below:Exec...