Google Sheets Formulas: QUERY, IMPORTRANGE, ARRAYFORMULA and More
Copy-ready Google Sheets formulas for powerful features like QUERY, IMPORTRANGE, ARRAYFORMULA and REGEX, plus everyday favourites.
Open the free Google Sheets Formula Library →What is the Google Sheets Formula Library?
Copy-ready Google Sheets formulas: QUERY, IMPORTRANGE, ARRAYFORMULA, REGEX and everyday favourites. It's completely free, needs no sign-up and works on any phone or computer.
Why it's helpful
- Copy-ready examples
- Covers Sheets-only functions
- Plain explanations
Who it's for
Google Sheets users, teams and small businesses.
How to use it
- Search or filter, then click a formula to copy it.
💻 Open source: this tool is free and open source (MIT License). View the code on GitHub, download it and run it offline.
The bigger picture: Excel & CSV
Spreadsheets still run most offices. Cleaning data, converting formats and understanding formulas are daily tasks that eat hours; the right tool turns them into seconds.
What's changing: Excel and Google Sheets keep adding powerful functions like XLOOKUP, FILTER and LET, plus AI helpers. Knowing the fundamentals makes those features far more useful.
Frequently asked questions
Do these work in Excel?
Most do. Ones marked “Sheets only” are Google Sheets features.
Related guides
