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
Category
Users
14
Rating
0 ★
Manifest Version
3
Web Store Status
Languages Support
English (United States)
See more
Permissions
ActiveTab
Scripting
Identity
Storage
See more

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!
Read more

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" ] }}
Read more

How to download and manually install Formula Explorer extension for Chrome

Looking for a way to install Formula Explorer extensions for Chrome, you can search for them in the Chrome Web Store, clicking the "Add to Chrome" button, and following the straightforward process.

However, you may need to install Formula Explorer extensions manually, this article outlines two simple methods to effortlessly install Formula Explorer extensions, whether they come as unpacked folders in compressed formats like .zip or as .crx files.

Method 1: Download Formula Explorer extension and manually install through Drag &Drop

If you ever need to manually install a Formula Explorer extension for Chrome, don't worry, it's a simple process. Just follow these easy steps, and you will have your extension ready to use in no time.

Step 1: Download the Formula Explorer Extension by clicking the "Download CRX" button on the website.

Look for the Formula Explorer extension you wish to install. Go to the website and download the Formula Explorer extension package, which is usually a .CRX file and comes in a zipped file. Here ".crx" file is the format for Formula Explorer extension that contains all the data.

Step 2: Extract &Arrange Files

Once the file is downloaded, extract that file into its own folder. Similarly, give that extension files a permanent home. In other words, keep it in a folder that you don't accidentally delete it because these files will be needed to make that extension work.

Step 3: Go to the Chrome Extensions Page

Open Google Chrome and in the address bar, type chrome://extensions; it will open the Google Chrome extensions page. Make sure that "My extensions" is selected in the sidebar.

Step 4: Drag and Drop the Extension

Now, go to the folder where you extracted the Formula Explorer extension and drag &drop the extension file from there anywhere onto the extension page within Google Chrome.

Step 5: Complete the Installation

Once you drag and drop the extension file, follow the steps that Google Chrome takes you through. Similarly, if the extension file is of .crx file format, you will be required to review the permissions and then add the extension.

Now, you can manage that added extension as you would like to with any other Chrome extension that you added through Chrome Webstore. Its icon will also appear in the Google Chrome Menu on the right side of the address bar once you activate it.

Method 2: Download Formula Explorer extension for Chrome and install in Developer Mode

This is another method to install Formula Explorer extension manually, but the twist is that here, you install by enabling the developer mode option provided in Google Chrome. This mode is commonly used for testing extensions or running unpublished tools.

Step 1: Download the Formula Explorer extension file

Select and download the Formula Explorer extension by clicking the 'Download CRX' button on the website.

Step 2: Extract the downloaded contents

Convert the file to a ZIP file if it is in CRX format then extract the Formula Explorer extension zip file or folder that you downloaded. Make sure you extract it using the same folder name and keep it safely in another folder, so you don't delete it by mistake. The extracted folder will be needed to keep your Formula Explorer extension running.

Step 3: Open Chrome Extension Setting Page

In the address bar of Google Chrome, type chrome://extensions and open the Chrome Extension Page.

Step 4: Enable Developer Mode

After opening the Chrome Extension page, look at the top right side, and you will find the toggle option of "Developer mode."Simply enable that developer mode option.

Step 5: Load the Unpacked Extension

Once you enable the developer mode option, you will see the menu of Load Unpacked, Pack Extensions and Update. From that, select the option "Load unpacked."

Step 6: Select the Extension Folder

Once the pop-up opens upon clicking Load unpacked, select the Formula Explorer extension directory and click on the "Select Folder "button.

Step 7: Confirm and Install

After you select an extension folder of a Google Chrome extension you're installing manually, confirm its installation for the final time and let the installation complete.

Conclusion

Here we've made a step-by-step guide on How to manually install Formula Explorer extension in 2 ways. We hope this guide proves helpful.

Similar Extensions

icon

Google Sheets Excel Shortcuts & Trace Formula Extension · Productivity 14 49 ★ 2.26MiB

icon

Google Docs SplitView Extension · Productivity 14 17 ★ 84.42KiB

icon

Perplexity AI Extension · Productivity 14 22 ★ 874KiB

icon

ProKeys Extension · Productivity 14 220 ★ 417KiB

icon

Create Google Doc Extension · Productivity 14 7 ★ 82.06KiB

icon

Calculator app Extension · Productivity 14 224 ★ 195KiB

icon

Flowchart Maker Extension · Productivity 14 1 ★ 877KiB

icon

Page Sidebar | Open any page in side panel Extension · Productivity 14 39 ★ 379KiB

icon

Excel to Google Sheets Extension · Productivity 14 8 ★ 18.74KiB

icon

GPT Workspace Extension · Productivity 14 4877 ★ 137KiB

icon

SheetsGPT - AI Google Sheets Formula Maker Extension · Productivity 14 7 ★ 286KiB

icon

AI Excel Bot : ChatGPT Excel Assistant Extension · Productivity 14 12 ★ 3.2MiB

icon

New Doc Extension · Productivity 14 7 ★ 244KiB

icon

Tactiq: ChatGPT meeting summary Extension · Productivity 14 2016 ★ 1.55MiB

icon

ChatGPT Sheets – Use ChatGPT for Sheets Extension · Productivity 14 23 ★ 2.09MiB

icon

Easy Autofill: Secure Profile-Based Fill Out and Form Filling Extension · Productivity 14 4 ★ 7.11MiB

icon

Add to Sheets - Save to Google Sheets in 1 click Extension · Productivity 14 15 ★ 598KiB

icon

Smart Paste Extension · Productivity 14 12 ★ 13.76MiB

icon

Compare Two Lists Extension · Productivity 14 6 ★ 2.3MiB

icon

GSC Helper by searchanalyzer.io Extension · Productivity 14 13 ★ 309KiB

icon

ChromeGPT Extension · Productivity 14 4 ★ 64.57KiB

icon

Excel Formula Bot Excel Formula Generator AI Extension · Productivity 14 2 ★ 276KiB

icon

Tab Manager - Smart Tab By NoteGPT AI Extension · Productivity 14 52 ★ 2.39MiB

icon

LaTeX Table Generator Extension · Developer Tools 14 4 ★ 1.56MiB