Google has announced a long-awaited update to Google Sheets, introducing one-click table creation for easier data organization and analysis.
According to Google, this feature, a staple of Microsoft Excel for years, allows users to quickly convert a block of data into a self-contained table with filters, sorting rules, and visual formatting.
"As a person who's maintained a shared budget spreadsheet in Google Sheets for about a decade and who would have loved not to have to create all of my filters and sort piece by piece, I'm excited," said a long-time Google Sheets user.
This sentiment is echoed by many users who have been requesting this feature for years.
Google's new tables resemble the AI-generated tables showcased at its I/O developer conference but cater more to power users and do not require Gemini integration. To create a table, users can simply select a block of data and click Format > Convert to the table.
Sheets will then automatically generate filters for each column, add visual row separators, and format column types for enhanced readability. Additional features include a table menu for creating filter combinations, adjusting data ranges, and creating "group by view" options to group records by column filters.
The update also introduces table templates designed for everyday tasks like project management, inventory management, and event planning. While the feature is not yet available to everyone, Google expects a gradual rollout, with some users gaining access by May 30th and full availability by June 6th.