SheetPeek — see what your formula is looking at

Description

Select a cell and instantly see the actual values behind its references. Stop jumping between sheets. Stop jumping between sheets to check what a formula is pointing at. Click a cell in Google Sheets and SheetPeek shows, right next to it, the actual values behind every reference in the formula, with the column header, so you know what you're looking at. WHAT YOU SEE • Every range the formula refers to, grouped by "other sheets" and "this sheet" • The real values in those ranges (first rows), plus the header of that column • Single-cell references shown big, so the number you need is readable at a glance • IMPORTRANGE targets are listed, so you know a value comes from another file WORKS WITH VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIF/SUMIFS, COUNTIFS, QUERY, IFERROR wrappers, whole-column ranges (A:A), cross-sheet references with quoted names. Anything written in A1 notation. NO EXPLANATIONS. JUST THE DATA. SheetPeek doesn't try to explain your formula. It shows you what the formula is looking at, so you can judge it yourself in one second. PRIVATE BY DESIGN • No account, no sign-in, no OAuth screen • No server. Values are read inside your own browser session, from the spreadsheet you already have open • Nothing is sent anywhere. The extension has no analytics and collects no data • Only runs on docs.google.com/spreadsheets HOW TO USE Open any Google Sheet Click a cell that contains a formula The SheetPeek panel shows what that formula refers to Drag the panel by its title bar to move it. Double-click the title to reset its position. Click the minus sign to collapse. LIMITS (HONEST LIST) • Reacts to the selected cell, not to mouse hover • Contents of other files (IMPORTRANGE) can't be read, only the target is listed • Named ranges are not resolved yet • Whole-column ranges show the first 200 rows Language: English and Japanese (follows your browser language).

Details & SEO