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