Show All Formulas
Show formulas in Google Sheets™ from every tab, on one list you can search
Built by Better Sheets · Free on the Google Workspace Marketplace · No account needed
What Show All Formulas does
Show All Formulas shows every formula in your Google Sheets™ spreadsheet on one tab: the tab, the cell, the formula, the result it shows right now and the formula in R1C1 form. Search your formulas, find every VLOOKUP or broken reference, then click any cell address to jump straight to that formula.
- ✅ One click: open Extensions, then Show All Formulas, then Show all formulas.
- ✅ Every cell address is a link. Spot a formula you want to fix, click its cell and you land right on it, on the right tab. No hunting through tabs and rows.
- ✅ Every tab at once. View → Show formulas in Google Sheets™ only shows the formulas of one tab, in the cells, and hides the results.
- ✅ Search formulas: press Ctrl+F to find every VLOOKUP, QUERY, IMPORTRANGE or #REF! in the file.
- ✅ Spot the odd one out: an R1C1 column shows each formula the same way for every row it was copied to, so a formula someone changed by hand stands out.
- ✅ Copy the whole Formula column to document a sheet, hand it to a teammate, or paste it into an AI chat to have it explained.
- ✅ Run it again any time to refresh the list. Your other tabs are never changed.
How Show All Formulas uses your Google data
- Adds a menu in Google Sheets™ with one job: show every formula in the spreadsheet you are working in.
- Reads the formulas and the values they show on each tab, and writes the list to a tab called All Formulas. It does not change any other tab.
- Runs entirely inside Google Sheets™. It does not send your spreadsheet data anywhere else.
Google permissions it asks for
| See and change the spreadsheet it is installed in | https://www.googleapis.com/auth/spreadsheets.currentonly |
| Show its menu and sidebar inside Google Sheets™ | https://www.googleapis.com/auth/script.container.ui |
Full details: Show All Formulas Privacy Policy · Terms of Service
Privacy Policy
Last updated: November 17, 2026
This policy explains what Show All Formulas, a free Google Sheets™ add-on made by Better Sheets, does with your information. Show All Formulas is published by Better Sheets (Andrew Kamphey), contact [email protected].
What Show All Formulas does
Show All Formulas lists every formula in the spreadsheet you are working in on one tab, called All Formulas: the tab, the cell, the formula and the result it shows.
Google data it accesses
- The spreadsheet you use Show All Formulas in, and only that spreadsheet. It reads the formulas and the values they show on each tab, and writes the list to the All Formulas tab. It does not change any other tab.
- It cannot see any other spreadsheet or file in your Google Drive.
How that data is used
Your spreadsheet data is used only to build the list you ask for, at the moment you click List all formulas. All of the work runs inside Google's own servers (Google Apps Script) under your Google account.
What we store, share or sell
- Better Sheets does not collect, store, log or transmit your spreadsheet contents, file names or email address. Nothing is sent to Better Sheets' servers or to any other third party.
- We do not sell, rent or share your data, and we do not use it for advertising.
- We do not use your Google data to train or improve AI or machine-learning models.
- Show All Formulas uses no cookies, analytics or tracking inside the add-on.
How your data is protected
- Least access. Show All Formulas asks only for access to the spreadsheet you are working in (the
spreadsheets.currentonlypermission) and to show its menu (script.container.ui). It cannot open, list or change any other file in your Google Drive, and only acts when you click its menu. - No storage outside Google. Your data is processed only inside Google Apps Script while you run the add-on. Better Sheets has no server, database or log that receives your spreadsheet data, so there is no copy of it that could be leaked or breached.
- Encrypted in transit and at rest. All requests between your browser, the add-on and Google use HTTPS (TLS). Your spreadsheet stays in your own Google Drive, which Google encrypts at rest.
- Google-managed sign-in. Authorization uses Google OAuth. Show All Formulas never sees or stores your password and does not keep tokens.
- Restricted developer access. The add-on's code and Google Cloud project are owned by a single Better Sheets account protected with two-step verification. Nobody at Better Sheets can view your spreadsheets through the add-on.
- Problems. If we learn of a security issue affecting Show All Formulas, we will fix it and tell affected users without undue delay. Report security concerns to [email protected].
Google API Services User Data Policy
Show All Formulas' use and transfer to any other app of information received from Google APIs will adhere to the Google API Services User Data Policy, including the Limited Use requirements.
Keeping and deleting your data
The All Formulas tab is part of your spreadsheet. Delete the tab at any time. Because Better Sheets keeps no copy of your data, there is nothing for us to delete. To remove the add-on's access, uninstall it from Google Sheets (Extensions → Add-ons → Manage add-ons) or remove it at myaccount.google.com/permissions.
Children
Show All Formulas is not directed at children under 13.
Changes
If this policy changes, the new version will be posted on this page with a new "Last updated" date.
Contact
Questions about privacy: [email protected]
Terms of Service
Last updated: November 17, 2026
These terms apply to Show All Formulas, a free Google Sheets™ add-on made by Better Sheets (Andrew Kamphey). By installing or using Show All Formulas you agree to them.
1. The service
Show All Formulas lists the formulas in a Google Sheets spreadsheet on a tab in that spreadsheet. It is free. There is no account to create.
2. Your content
You keep all rights to your spreadsheets, including the All Formulas tab the add-on writes.
3. Acceptable use
Do not use Show All Formulas to break the law, to break Google's terms, or to interfere with Google's services.
4. No warranty
Show All Formulas is provided "as is", without warranties of any kind. The list shows the spreadsheet at the moment you ran it; run it again after you change formulas.
5. Limitation of liability
To the fullest extent the law allows, Better Sheets is not liable for any indirect, incidental or consequential damages, or for lost data or profits, from using or not being able to use Show All Formulas.
6. Changes and ending the service
We may update Show All Formulas or these terms, or stop offering the add-on. Updated terms will be posted on this page with a new date. You can stop using Show All Formulas at any time by uninstalling it.
7. Privacy
See the Show All Formulas Privacy Policy.
8. Governing law
These terms are governed by the laws of the State of Florida, United States.
9. Contact
Support
Questions, bugs or ideas for Show All Formulas: email the developer, Andrew, at [email protected]. Replies usually come within two business days.
Common questions
- Where is my list? On a tab called All Formulas at the end of your spreadsheet. Show All Formulas opens it for you when it finishes.
- How do I update the list? Run Extensions → Show All Formulas → Show all formulas again. It rewrites the All Formulas tab with what is in the spreadsheet now.
- Does it change my other tabs? No. It only reads them. The All Formulas tab is the only tab it writes to.
- Why does an array formula show up once? Google Sheets™ stores an array formula in the one cell where you typed it, so that is the cell Show All Formulas lists.
Google Sheets™ is a trademark of Google LLC.