Google Sheets Finally Gets Microsoft Excel’s One Click Tables

Making tables in Google Sheets has never been easier. The search engine giant has just enabled one-click tables in Sheets, a feature that has existed in its biggest rival app Microsoft Excel for years.

If you have a bunch of data divided into rows and columns that need to be in a table, all you have to do is select all your data, go into formatting options among the tabs at the top, and select the new “Convert to table.” This will put your data into a little island of filters and sorting options.

GIF showing the new table creation feature in Sheets.

Once you create a table in Sheets, it will automatically generate filters for each column and add visual row separators, eliminating the need to manually select and shade every other row. This update also includes auto-formatted column types, filters, and simplified drop-down menu creation.

Google’s new feature resembles the AI-generated tables showcased at its I/O developer conference this week, but it’s geared more toward power users and doesn’t require Gemini integration.

Sheets will also introduce a table menu that allows you to create specific filter combinations for the entire table or adjust the data range it covers. Additionally, Google is adding a new view option called “Create group by view,” which lets you organize data into groups based on column filters. For example, you can group records by priority levels such as priority one, priority two, and priority three.

GIF showing the new “group by” option.

The update also includes table templates designed for everyday tasks like project management, inventory management, event planning, and more.

This is a feature that has been requested by Google Sheets users for years and should come in handy for those who regularly need to create tables in Google Workspace. Self-contained tables not only save time but also give them a neat color-coded look without any effort.

One-click tables will roll out gradually to all users. Some users will get it by May 30 while some may have to wait until June 6.

Follow ProPakistani on Google News & scroll through your favourite content faster!

Support independent journalism

If you want to join us in our mission to share independent, global journalism to the world, we’d love to have you on our side. If you can, please support us on a monthly basis. It takes less than a minute to set up, and you can rest assured that you’re making a big impact every single month in support of open, independent journalism. Thank you.

Get Alerts

Follow ProPakistani to get latest news and updates.

ProPakistani Community

Join the groups below to get latest news and updates.