Google Sheets

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

QUERY Function: Query Syntax and Examples in Google Sheets

The QUERY function in Google Sheets is a powerful tool for filtering, sorting, and aggregating data flexibly within a spreadsheet. This article provides a list ...

2024.12.20

Sheets Topics

REGEXREPLACE Function: Replace Text Using Regular Expressions in Google Sheets

About the REGEXREPLACE FunctionOverview of REGEXREPLACEText Replacement Using Regular ExpressionsGoogle Sheets Function=REGEXREPLACE( text, regex, replacement )...

2024.12.20

Sheets Function

Google Sheets Regular Expressions: Examples with REGEXREPLACE Function

By using the REGEXREPLACE function in Google Sheets, you can easily perform text replacement based on regular expressions. This article explains nearly all comm...

2024.12.20

Sheets Topics

GOOGLEFINANCE Function: Retrieve Stock Prices, Exchange Rates, and Other Financial Data in Google Sheets

About the GOOGLEFINANCE FunctionOverview of GOOGLEFINANCERetrieve Real-Time or Historical Stock DataGoogle Sheets Function=GOOGLEFINANCE( ticker, , , , )Summary...

2024.12.20

Sheets Function

JOIN Function: Google Sheets’ Unique Function to Combine Cell Range Values with a Specified Delimiter

About the JOIN FunctionOverview of JOINCombine Multiple Values with a Specified DelimiterGoogle Sheets Function=JOIN( delimiter, array or list of values )Summar...

2024.12.20

Sheets Function