Changelog
Back to All
Added

IMPORTRANGE — pull live data from one GeoSheet into another

28 days ago by ReadMe API

GeoSheet now supports IMPORTRANGE, a formula that lets a sheet pull live data from any other GeoSheet you have access to. Build a single source of truth once and reference it from anywhere — values stay fresh automatically and the source owner stays in control of who's reading.

How it works

Drop an IMPORTRANGE formula into any cell:

=IMPORTRANGE("Customers", "A1:E200")
=IMPORTRANGE("Q3 Sales", "Summary!B2:D50")

The first argument is the source GeoSheet (by name or URL). The second is the range you want — a single cell, a rectangle, or a named tab. The values stream into your sheet starting from the formula cell. Update the source, and consumers refresh on their own — no manual sync, no copy-paste, no stale numbers.

What this enables

  • One source of truth, many GeoSheets. Maintain a master list of customers, locations, products, or KPIs in one place. Every regional, team, or scenario sheet pulls from it. Edit once, propagate everywhere.
  • Roll-ups across teams. Each team owns its own GeoSheet; a parent dashboard pulls from all of them with a few IMPORTRANGE formulas. No shared editing, no merge conflicts.
  • Reusable spatial data. Because this is GeoSheet, the values you import keep their type. Pull a column of geocoded POINT cells into a new sheet and immediately drop them on a map, build a TRADEAREA, or feed them to GEOFENCE — no re-geocoding, no re-formatting.
  • Layered analysis. Chain references freely: a "raw data" sheet feeds a "cleaned" sheet feeds a "summary" sheet. Each layer stays its own document, owned by whoever should own it.

Always fresh

Imported ranges refresh in the background while the consumer sheet is open, so values stay in step with the source without manual intervention. Cells show #PENDING briefly on first load and update silently from there. Updates typically arrive within about a minute of the source being edited.

Source-side governance

Open the Referenced by panel on any GeoSheet to see which other GeoSheets are pulling data from it. If you need to cut a connection — for example, after a doc is shared too widely or moves out of scope — you can revoke a consumer directly from the panel. Revoking is a hard cut: the consumer's IMPORTRANGE cells flip to #REF immediately and the source values stop flowing through, so the consumer sheet will visibly break wherever those cells are used. Restoring the reference brings live values back. The panel exists so you always know who's reading from your data and can take action without coordinating across docs.

Try it

Pick a sheet with data you reference often, open another GeoSheet, and type =IMPORTRANGE("— autocomplete will show the formula. Two sheets, one formula, and you're connected.