Google Sheets Formula Library

QUERY Function Basics

QUERY brings SQL-like power to Google Sheets. Filter, sort, group, and aggregate data with a single formula.

ARRAYFORMULA Basics

Write the formula once in the header row. It automatically applies to every row below. No dragging, no copying.

IMPORTRANGE With QUERY

Pull specific data from another Google Sheets file and filter it — all in one formula. The most powerful cross-sheet technique.

FILTER Function in Google Sheets

FILTER returns rows from a range that meet your conditions. Simpler than QUERY for straightforward filtering.

GOOGLEFINANCE Function

Pull real-time stock prices, historical data, and financial metrics directly into your spreadsheet. Build portfolio trackers and watchlists.

Filter Rows with QUERY

Struggling to filter data in Google Sheets? The QUERY function allows you to easily filter rows based on specific criteria, just like SQL.

Group By with QUERY

Grouping data by category and summing values is crucial for analysis. The QUERY function simplifies this process, similar to SQL's GROUP BY.

Sort and Limit QUERY Results

Sorting and limiting your data can help you focus on the most important information. This guide shows you how to achieve that using the QUERY function.

Using ARRAYFORMULA in Google Sheets

Tired of copying formulas down every row? ARRAYFORMULA automates this process, saving you time and effort.

Import and Filter Data

Easily pull data from different sheets and apply filters to focus on relevant information, streamlining your data analysis.

Validate Email Format

Ensuring that email addresses are correctly formatted is crucial for data integrity. Use REGEXMATCH to easily validate email formats in your spreadsheets.

Extract Digits from Text

Struggling to isolate numbers from a text string? Use REGEXEXTRACT to effortlessly pull out all digits from your data.

Split Full Name into First and Last

Struggling to separate names in your spreadsheet? This guide shows you how to efficiently split full names into first and last names using a simple formula.

Unique Sorted Values

Struggling with duplicates in your data? This formula will help you extract a clean, sorted list of unique values effortlessly.

Count Unique Values

Struggling to find the number of distinct entries in your data? This formula will help you count unique values effortlessly.

Create Sparkline Charts

Visualizing data trends can be challenging, but using the SPARKLINE function allows you to create compact charts directly within a cell.

Live Stock Prices in Google Sheets

Easily access live stock prices and historical market data directly in your Google Sheets with the GOOGLEFINANCE function.

Import HTML Tables and Lists

Struggling to get data from a webpage into your spreadsheet? The IMPORTHTML function makes it easy to pull in tables or lists directly.

Using XLOOKUP in Google Sheets

Struggling to find values in your data? XLOOKUP provides a powerful solution with fallback options for missing results.

Using LAMBDA for Custom Functions

Unlock the power of custom functions in Google Sheets by using LAMBDA to streamline your calculations and data processing.

Flatten Columns into List

Struggling to combine data from multiple columns? The FLATTEN function simplifies this by creating a single list from your selected range.

Convert Table to Column/Row

Transforming data from a 2D table into a single dimension can streamline your analysis. This formula helps you achieve that effortlessly.

Query Select with Where

The QUERY function allows you to perform SQL-like operations in Google Sheets, making data manipulation easier and more intuitive.

Group and Pivot Data

Transform your data analysis by using QUERY to group totals by category and pivot to display them in a more insightful format.

Import and Filter Data

Easily combine data from different sheets while applying filters to streamline your analysis and reporting.

Apply IF with ARRAYFORMULA

Tired of dragging formulas down a column? Discover how to apply an IF formula to an entire column at once using ARRAYFORMULA for faster calculations.

SUMIF with ARRAYFORMULA

This guide shows you how to apply SUMIF across multiple rows simultaneously, ensuring your calculations adjust as data changes.

Extract Domain from URLs

Struggling to isolate domains from a list of URLs or email addresses? Use REGEXEXTRACT to simplify your data extraction process.

Clean Non-Numeric Characters

Struggling with unwanted symbols in your data? Use REGEXREPLACE to easily clean your text cells and retain only numeric values.

Split Text to Columns

Struggling with text in a single cell? Use the SPLIT function to separate it into multiple columns effortlessly.

Sum Across Sheets

Easily aggregate data from different tabs in Google Sheets using IMPORTRANGE and QUERY functions to streamline your reporting.

Conditional Sum by Date

Summing values based on specific date ranges can be challenging, but this formula simplifies the process for current month, last 30 days, or specific quarters.

Using XLOOKUP in Sheets

XLOOKUP simplifies data retrieval in Google Sheets, making it easier to replace the older VLOOKUP function with enhanced capabilities.

Live Stock Prices in Sheets

Easily track stock prices and financial metrics directly in your Google Sheets with the GOOGLEFINANCE function, streamlining your investment analysis.

Create Sparkline Charts

Sparkline charts provide a quick visual representation of data trends directly within a cell. This guide shows you how to customize them effectively.

Using Named Ranges

Named ranges simplify your formulas, making them easier to read and maintain, especially in large spreadsheets.

Sort Unique Values

Struggling with duplicate values? This guide shows you how to dynamically sort and list unique entries from a column in Google Sheets.

Count Cells with Specific Text

Struggling to count occurrences of a word or phrase in your data? Use the COUNTIF function with wildcards to easily achieve this.

Handle IMPORTRANGE Errors

When using IMPORTRANGE, loading errors can disrupt your workflow. Wrapping it in IFERROR allows you to show a custom message while data loads.

Automatic Language Translation

Struggling with language barriers in your data? Use the GOOGLETRANSLATE function to convert text from one language to another effortlessly.

Using Checkboxes in Formulas

Checkboxes in Google Sheets can simplify task management by allowing you to count, sum, or trigger actions based on TRUE/FALSE values.