Google Sheets’ new formatting feature has Excel switchers excited
Google has now added a way to create easily formatted tables in Sheets with one click, something Excel has had for years. Now, if you have a block of data that you’d like to quickly turn into its own little island of filters and sorting rules, that’s fully possible (or will be soon, depending on where you are in Google’s rollout queue). Hooray!
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. And judging by a little cursory searching, I’m not alone — people have been asking for self-contained tables like this for years.
What Google has created here looks a little bit like the AI-generated tables from its I/O developer conference this week but perhaps a little more power user-focused, and you don’t need its Gemini integration. If the new feature has hit your account already, you can try it by selecting a block of data and clicking Format > Convert to table.
Once you’ve done that, Sheets will automatically create filters for each column and add visual separators for your rows, so you don’t have to manually select every other row and turn it gray. The change also comes with automatically formatted column types, filters, and easier drop-down menu creation.
It’ll also add a table menu so you can create specific combinations of filters for the whole table or adjust the range of data it covers. Google says this update also includes a new kind of view option labeled “Create group by view” that lets you put data in groups separated by their column filters — so if you have a filter for priority level, you can group records by priority one, priority two, priority three, and so on. There are also table templates tuned for “everyday tasks like project management, inventory management, event planning and more.”
The new tables feature hasn’t hit everyone yet. As is typical for Google, it will be rolling out gradually. Some will have it by May 30th, and everyone else should have it by June 6th.
Google has now added a way to create easily formatted tables in Sheets with one click, something Excel has had for years. Now, if you have a block of data that you’d like to quickly turn into its own little island of filters and sorting rules, that’s fully possible (or…
Recent Posts
- US outlines its $5 billion Genesis Mission to boost science with AI
- Top Red-Light Therapy Deals at Nordstrom’s Anniversary Sale (2026)
- Tesla’s revenues are bouncing back, but profits are still weak
- Price-hiked iPads are a little cheaper right now
- OpenAI sued over ChatGPT health advice that almost killed a pastor
Archives
- July 2026
- June 2026
- May 2026
- April 2026
- March 2026
- February 2026
- January 2026
- December 2025
- November 2025
- October 2025
- September 2025
- August 2025
- July 2025
- June 2025
- May 2025
- April 2025
- March 2025
- February 2025
- January 2025
- December 2024
- November 2024
- October 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023