Google Sheets articles
Guides and tutorials for Google Sheets. Learn the formulas and techniques that professionals actually use.
Google Sheets QUERY function
QUERY is the most powerful function in Google Sheets. It uses SQL-like syntax to filter, sort, group, and transform your data.
Google Sheets IMPORTRANGE
Pull live data between spreadsheets with IMPORTRANGE. Combined with QUERY, it's the closest thing to a database in Google Sheets.
The Formula Genius blog covers tutorials, how-to guides, and best practices for Excel, Google Sheets, SQL, and regex. Every technique is explained with real-world examples you can use right away.
Need a specific formula?
Describe what you need in plain English. Formula Genius generates and explains a formula draft, with checks for supported formulas.