Google Workspace has announced an upgrade to its spreadsheet software that could make the tool more useful than ever before.
In its battle to take on great rival Microsoft Excel, the company’s Google Sheets platform has enjoyed a number of recent updates to help users get more from their data.
This includes so-called “smart chip” technology, which lets users quickly access information or data from other Google Workspace files, bringing the likes of Slides, Docs and Gmail even closer together for the ultimate collaboration tool.
Following an initial rollout in February 2023, Google Sheets has already seen an initial smart chips upgrade, taking the form of richer experiences, including extra functionality when posting YouTube clips in a spreadsheet, further expansions have now been announced.
Going forward, the company says users will be able to quickly extract information from smart chips to give your work extra detail or analysis, pulling in information from people, file and event chips. It will also allow users you to pull out metadata associated with specific smart chips into its own cell, all whilst maintaining a connection with the chip it was extracted from.
The company gave the example of making it easier to keep track of a set of documents, as well as who owns them and details such as creation time or who last modified the file, which can now be done by extracting those fields from the relevant file chips.
“Smart chip data extraction allows you to track and organize data more easily, and also perform deeper analyses using data that is derived from smart chips,” a Google Workspace update blog post announcing the change read.
“Useful actions include using file chips to understand when a document was last updated or using people chips to sort and filter employees based on job location to best delegate region specific tasks.”
The feature is rolling out now for users on Rapid Release domains, with a wider release scheduled for June 14.
The ability to extract data already stored in chips will be available to all Google Workspace customers and users with personal Google Accounts, but some limits on extracting all available data will be placed on the latter, along with users with Google Workspace Essentials Starter, Business Starter, Frontline Starter, Frontline Standard, and Nonprofits accounts.