If you work with Google Sheets™ across multiple files, you have almost certainly run into the IMPORTRANGE authorisation problem. Every time a spreadsheet pulls data from another file using =IMPORTRANGE(), Google requires the connection to be manually approved — one by one. For teams managing dozens or hundreds of linked sheets, this quickly becomes a serious maintenance headache.
ImportRanger solves it in one click.

What ImportRanger does
✅ Authorise all IMPORTRANGEs in your spreadsheet at once — ImportRanger scans every cell for IMPORTRANGE formulas and authorises each pending connection automatically. What used to take minutes of clicking now takes seconds.
✅ Authorise by active tab only — scope the action to just the sheet tab you are currently working on, useful when you only need to unblock one part of a file.
✅ See every connection in one place — the Connections list shows every IMPORTRANGE in your file grouped by source spreadsheet, with its status (authorised, pending, or broken), the range it pulls from, a direct link into the source file, and the exact cell in your sheet where the formula lives.
✅ Trace your dependency chain (Solo and Team) — for any connected source, open a visual tree showing which spreadsheets that source itself depends on, up to three levels deep. Results are cached so repeat lookups are instant.
✅ Full audit log (Team) — every authorisation is automatically written to a dedicated ImportRanger Data spreadsheet with a timestamp, the user email, the source and target spreadsheet URLs, and a status. Your team gets a complete, searchable history of every connection ever approved.

ImportRanger handles all three IMPORTRANGE formula formats: full spreadsheet URLs, bare sheet IDs, and cell references where the URL lives in another cell. It uses the server-side TextFinder API to locate formulas efficiently even in large sheets with thousands of rows.

Plans
0️⃣ Free — authorise up to 10 unique IMPORTRANGE connections per spreadsheet at no cost. The limit is tracked permanently per spreadsheet.
👤 Solo — unlimited authorisations across all your spreadsheets, plus the dependency tree.
👥 Team — everything in Solo, plus the full audit log written automatically to a dedicated spreadsheet.

Licensing is managed through a Chargebee subscription linked to your Google account email. Your plan is checked automatically when you open the sidebar and can be refreshed at any time. Visit thedatastudents.com/importranger to subscribe.

Privacy
ImportRanger reads only the spreadsheets you work with. It does not access your Google Drive file index, does not store your spreadsheet content on external servers, and does not share your data with third parties. Formula text is processed within your Google Workspace session. The only external call made is to the licensing service to verify your plan.