Google Sheets Formula Library
Copy common Google Sheets formulas — lookups, QUERY, array formulas and aggregations.
Disclaimer: This tool is for general informational and estimation purposes only and is not professional financial, tax, accounting or legal advice. All figures are estimates — verify with a qualified professional before making decisions. Read the full disclaimer.
About Google Sheets Formula Library
Google Sheets Formula Library is a free Google Workspace tool that lets you build the exact formula you need without memorising the syntax — no guesswork, no docs. Copy the formula and paste it straight into Gmail, Sheets, Calendar or Apps Script. It runs entirely in your browser with no sign-up and no installs, so your data stays private.
How to use Google Sheets Formula Library
- 1Open Google Sheets Formula Library — it loads instantly and runs entirely in your browser.
- 2Fill in the fields with your own values; the output updates live as you type.
- 3Review the generated formula in the preview area.
- 4Copy the formula and paste it straight into Gmail, Sheets, Calendar or Apps Script.
Why use Google Sheets Formula Library?
- ✓Generates a valid formula in seconds — no copy-pasting from docs
- ✓100% client-side: your inputs never leave your browser
- ✓Free and unlimited — no account, no trial, no credit card
- ✓Works on desktop and mobile; copy or download the formula instantly
Frequently asked questions
Is Google Sheets Formula Library free?+
Yes. Google Sheets Formula Library is completely free with no account, no trial and no usage limits. ToolJolt is supported by unobtrusive ads, not paywalls.
Where do I paste the output from Google Sheets Formula Library?+
Click Copy, then paste the formula into Gmail, Sheets, Calendar or Apps Script. Each tool's preview shows exactly what to add and where, so you can drop it in and save without reading the docs.
Is my data private?+
Completely. Google Sheets Formula Library runs 100% in your browser (client-side). Nothing you type is uploaded to a server, so your data stays on your device.
Do I need to sign up or install anything?+
No. There's nothing to install and no sign-up — just open the page and start. It works on desktop and mobile.
Does this need access to my Google account?+
No. The tool builds the link, formula or snippet locally in your browser. You only use your account when you paste the result into the Google product itself.
Can I use the output commercially?+
Yes. The configuration, code or files you generate are yours to use in personal and commercial projects without attribution.
Related Platform tools
Gmail HTML Signature Builder
Gmail HTML Signature Builder — build a ready-to-paste config or snippet in seconds. 100% client-side, no sign-up.
● LiveGoogle Sheets QUERY() Builder
Google Sheets QUERY() Builder — build a ready-to-paste config or snippet in seconds. 100% client-side, no sign-up.
● LiveGoogle Calendar Event Link Generator
Google Calendar Event Link Generator — build a ready-to-paste config or snippet in seconds. 100% client-side, no sign-up.
● LiveGoogle Forms Prefill Link Generator
Google Forms Prefill Link Generator — build a ready-to-paste config or snippet in seconds. 100% client-side, no sign-up.
● LiveApps Script Trigger Builder
Apps Script Trigger Builder — build a ready-to-paste config or snippet in seconds. 100% client-side, no sign-up.
● LiveGmail HTML Table Inserter
Turn CSV into inline-styled HTML tables that paste cleanly into Gmail.
● Live