Google introduces new feature for data exploration in Sheets without access

Google Sheets has rolled out a new sharing feature that lets users let others explore data insights without giving them full spreadsheet access. The update was announced on Tuesday by Google’s product team and is available to all paid and free users through the Sheets interface. With the new “Explore only” mode, a sheet owner can create a link that displays charts, pivot tables and summary tables, while the underlying cells, formulas and sheet structure remain hidden.

The move comes as more businesses look for ways to share data with partners, clients and regulators while protecting sensitive information. In the era of remote work and data‑driven decision making, teams often need to share raw numbers but keep the logic that generated them confidential. Google has been adding data‑visualisation tools to Sheets for years, and the new feature builds on that by tightening control over who can see what. It also responds to security concerns that surfaced after several high‑profile data breaches in cloud services.

Under the new sharing settings, owners can toggle “Allow viewers to explore data” and choose whether to expose the Explore panel that auto‑generates charts and insights. The feature is already being tested by a handful of enterprise customers, who report that it speeds up collaboration and reduces the need to create separate dashboards. Analysts note that the ability to share only the visualised data keeps formulas and hidden sheets out of reach, mitigating the risk of accidental data leaks. Some users worry that limiting access might hinder deeper analysis, but Google says the Explore tool can be enabled or disabled on a per‑viewer basis.

Google plans to expand the feature over the next few weeks, adding an API that lets developers embed Explore‑only views into custom dashboards and websites. The company also announced a partnership with Data Studio to allow seamless export of Explore results. The update is expected to roll out to all users by the end of the month, and it could set a new standard for data sharing in cloud productivity suites.