cognisheets.com

Inspect Google Sheets formula structures in a user-friendly pop-up window. Enhance your workflow with precision.

Latest Version

Version

1.1.2

Update

November 24, 2024

Size

1.14MiB

Developer

cognisheets.com

Formula Explorer Extension

Easily understand any formula in Google Sheets with Formula Explorer's convenient pop-up window. Simply press Ctrl+Q or click the extension icon to reveal it. After analysis, Formula Explorer breaks down the formula step-by-step, showing you the calculation process and corresponding values.

Formula Explorer helps you trace precedents effortlessly. Precedent cells are highlighted in blue, and selecting a row takes you directly to that cell. Explore each layer of the formula calculation within the same window, navigating with your mouse or keyboard arrows. Click anywhere in the formula itself to quickly jump to the element and its value.

Handle even the trickiest formulas with ease. Formula Explorer makes it easy to analyze complex calculations. Logical functions (IF, IFS, CHOOSE) show active branches in bold, while VLOOKUP, OFFSET, INDEX, and INDIRECT functions display their target locations.

➤ Formula Explorer on Google Sheets: Inspect formula structures. Debug formula calculations. Enhance your workflow with precision.

• See all referenced ranges and cells - save time, avoid errors
• Quickly jump to precedent cells using up / down arrow keys - effortlessly trace formula dependencies
• Navigate through formula layers using left / right arrow keys - drill down and understand complex calculations
• Click elements of the formula itself to quickly jump to the element and its value - analyze intermediate values
• Easy access and close - open the pop-up window with Ctrl+Q and close with Esc
• Navigate the entire tool without using your mouse - from opening the window to exploring formulas, everything can be done with just keyboard shortcuts for a distraction-free experience
• Seamlessly integrates with Google Sheets' native design - enjoy a smooth experience with a UI and visual style that feels like a natural extension of Google Sheets
• Intuitive design for all users – if you're accustomed to formula analysis tools in Excel, you'll feel right at home with Formula Explorer. It provides a seamless, familiar experience that fits naturally into your Google Sheets workflow without the need to adjust to a new interface.

After installing the Formula Explorer extension, you'll be prompted to log in with your Google account on first use. A free license will be automatically activated upon login.

We adhere to the principle of least privilege and do not request access to your Google Sheets data during login. Formula Explorer will only request access to your data when performing formula evaluations. This access is necessary to retrieve intermediate values within the formula tree.
If access is not granted, Formula Explorer will still display the structure of the formula and allow you to navigate to precedent cells that do not require evaluation. However, the values will not be displayed.

We prioritize your data privacy and do not access, edit, store, or share any content from your Google Sheets. For more details, see our Security Policy at https://www.cognisheets.com/legal/security and Privacy Policy at https://cognisheets.com/legal/privacy.html.

Formula Explorer is running in BETA and is FREE to use.

Boost your Google Sheets efficiency with Formula Explorer!

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx", "manifest_version": 3, "name": "Formula Explorer", "version": "1.1.2", "description": "Inspect Google Sheets formula structures in a user-friendly pop-up window. Enhance your workflow with precision.", "background": { "service_worker": "background.js" }, "key": "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEArItMAfgQzfDx0UzeFvFb9OyX5GWXyPrVnrhyKOf1i4J9nsf2oj6V9yMhb+AgWymscO4q/OAE8+QZ16lcer/tdn1Qc663AdEfMVPyCi55rjG1uPIhWXcKijvY3xr/1pIhcX9kDrwuUDvUga7W53OmQSz/WgcqtrO2D2tWRZKcZkgtSE2WA7/r/nwo6a/urY+dhO/0Q0YfH5ptTnYDO7b+47PE5j1vK1uEr6i+hSw+z2X8Jz8gExKJzBmtcZFD1mtAfgdHP1P8srkHPGKsp4vVtIjtR37DJZKaBVOACmp5PBILGg9tYtrFPIE1UU5PGxC1DFvlmP8sU+aEw1JtmY1kowIDAQAB", "action": { "default_title" : "Open Formula Explorer (Ctrl-Q)", "default_icon" : { "16": "assets/icon16.png", "32": "assets/icon32.png" } }, "icons": { "48": "assets/icon48.png", "128": "assets/icon128.png" }, "web_accessible_resources": [ { "resources": ["index.html", "assets/logo.svg"], "matches": [""] } ], "content_scripts": [ { "matches": ["https://docs.google.com/spreadsheets/*"], "js": ["content.js"] } ], "permissions": [ "activeTab", "scripting", "identity", "storage" ], "host_permissions": [ "https://docs.google.com/spreadsheets/*", "https://formula-explorer.cognisheets.com/api/*", "https://accounts.google.com/o/oauth2/revoke/*" ], "commands": { "_execute_action": { "suggested_key": { "default": "Ctrl+Q", "mac": "Command+Q" } } }, "oauth2": { "client_id": "241014300902-e4mr4t7dpves5e7ga4777c4364fk1idu.apps.googleusercontent.com", "scopes":[ "https://www.googleapis.com/auth/userinfo.email" ] }}

Download CRX(1.14MiB)