Google Sheets Formula Library

Copy-ready Google Sheets formulas: QUERY, IMPORTRANGE, ARRAYFORMULA, REGEX and everyday favourites.

How to use

  1. Search or filter, then click a formula to copy it.

FAQ

Do these work in Excel?

Most do. Ones marked “Sheets only” are Google Sheets features.

Open Google Sheets Formula Library · All free tools