Formula Explorer

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.

Now with support for the LET function, Formula Explorer breaks down assigned variables step-by-step, helping you understand and evaluate complex, reusable logic with clarity.

Starting from version 1.1.3, Formula Explorer provides analysis for Google Sheets in all major locales. Detection of special functions is now supported in English, French, German, Spanish, Italian, and Russian.

➤ 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.

Formula Explorer requests access to your Sheets data to evaluate formulas. This access is necessary to determine the sheet's locale and calculate intermediate values within formulas. 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 and Privacy Policy.

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

Boost your Google Sheets efficiency with Formula Explorer!