Changelog

Several quality-of-life improvements to the formula bar and formula editing experience.

You can now reference ranges from other sheets mid-formula without losing your place.

GeoSheet spatial cells now speak WKT and GeoJSON in both directions — you can get data out as standard formats, and paste standard formats back in.

A batch of smaller improvements and bug fixes shipped alongside this month's larger features.

IMPORTRANGE is more useful when you can see it working. This update adds three new signals that make your live data connections visible without having to open any panel.

MAP and FILTER results now spread across as many cells as the result needs, instead of compressing into a single cell. Drop the formula in once, and the values fan out into the surrounding range — the same way IMPORTRANGE has worked for ranges since April.

Map charts in GeoSheet just got a major upgrade. We rebuilt the underlying renderer on top of WebGL — the same browser-level GPU technology that powers modern web maps — so the same chart types you've been using now feel substantially faster on rich spatial data, and pick up new tricks along the way.

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.

GeoSheet now ships a full suite of Location Analytics formulas that turn any POINT cell with history into a motion-aware data source. Combined with Time Warp, you can track speed and heading in real time, detect geofence entries, measure dwell time inside service areas, and reconstruct entire trips retroactively.

GeoSheet now has seven new formulas for analyzing location data over time. Drop a LOCATION cell that tracks a user's GPS, and these formulas let you derive motion, geofencing, and history insights directly in your spreadsheet.