Effortless Data Structuring with Gemini AI in Google Sheets

Published On Sat Sep 28 2024
Effortless Data Structuring with Gemini AI in Google Sheets

Gemini can now turn your messy data into fancy tables in Google ...

Gemini AI in Google Sheets can turn data into colorful, eye-catching tables without manual formatting. Users can automatically structure large datasets with prompts in the side panel for ease of use. The feature is rolling out to users between now and October 17 in both Rapid Release Domains and Scheduled Release Domains.

Organize and Structure Data Effortlessly

Gemini AI can now help users organize and structure their data in Google Sheets. The omnipresent AI will turn data into rich Google Sheets tables with a few prompts in the Gemini side panel. It's a feature update Google showed off at Google I/O, and now it's finally here. The new tables are more than mere plain text ranges. These are colorful, eye-catching tables with all the data structured and organized. No formatting required.

This update lets users automatically structure their data into a more usable format. It is particularly useful for anyone working with a large dataset, or who needs to turn unorganized data chaos into something manageable. Using it is simple.

Using Make to Sync Object Data with Google Sheets

How to Use Gemini AI in Google Sheets

1. Click on the Gemini star button on the top right of Google Sheets.

2. Click the Create a table option.

3. Choose the kind of table you want, or input your own prompt.

4. Review the prompt and press Enter when ready.

Best Google Gemini AI Prompts for Business (Ultimate Guide for ...)

5. Enjoy your new table.

The Gemini side dialogue box suggests ways for you to prompt it to create your table. It suggests which lines you should change in a prompt to customize it to your liking, so you don't need to get overwhelmed with trying to figure it out. Do it a few times and it will become second nature.

Enhanced Features and Updates

Google introduced a "convert to table" feature in August, which turned data into a barebones plain text table. But this wasn't what Google had shown off at I/O back in May, where Gemini had created a beautiful and highly-organized table with a bunch of data. That impressive feature has finally arrived.

These new Gemini powers are already rolling out to users in Rapid Release Domains. The feature will start rolling out to Scheduled Release Domains on October 17, 2024. It should take about 15 days to fully roll out for each release domain, including Google Workspace customers, Education accounts, and those with a Google One premium subscription.

Google Sheets

Further Enhancements with Gemini AI

Google has started rolling out Gemini-generated smart replies for Gmail, which are more detailed and have more context than its old version of smart replies. Snap has entered into an expanded partnership with Google Cloud to power generative AI experiences within Snapchat's My AI chatbot. The chatbot will leverage the multimodal capabilities of Google's Gemini AI to enable the chatbot to understand different types of information, like text, audio, images, and videos. Gemini is powering the Google Lens-like features that Snapchat announced at its annual Snap Partner Summit last week.

Google launches Gemini—a powerful AI model it says can surpass GPT ...

Conclusion

Google is continuously enhancing its AI technologies to provide more intuitive and efficient solutions for its users. With Gemini AI in Google Sheets, organizing and structuring data has never been easier. Stay tuned for more updates and features powered by Google's innovative AI capabilities.