A new Google Sheets feature, Sheets canvas transforms rows and columns into interactive dashboards, custom study trackers, seating charts, and more, all with a simple prompt.
Eric Birnbaum
Director, Product Management, Google Sheets
Google Sheets now features Sheets canvas, a tool that uses artificial intelligence to turn your data into interactive, visual mini-apps without any coding. You can simply describe your needs to Gemini, and it will build custom layouts like study trackers or seating charts that sync automatically with your original spreadsheet. To get started, open a sheet and click the Gemini icon to select "create canvas."
• "Bring your spreadsheet data to life with Sheets canvas" turns boring data into interactive apps. • Use simple prompts to let Gemini build custom, visual layouts for your spreadsheets. • Your canvas and spreadsheet stay perfectly synced, so your data is always up to date. • You don't need coding skills to design dashboards, study trackers, or seating charts. • Share your canvas with others easily, just like you would with any regular sheet.
Google Sheets now has a new feature called Sheets canvas that turns boring rows of data into interactive, easy-to-read apps. You just tell AI what you want, and it builds a custom layout for you without any coding. Everything stays perfectly synced, so any changes you make update your original spreadsheet automatically. It’s a great way to organize school projects, sports stats, or event planning without getting overwhelmed.
Spreadsheets are a powerful tool for organizing and understanding data, but staring at hundreds of rows and columns can sometimes feel a bit overwhelming. Whether you’re planning a wedding, tracking school assignments, managing a fantasy football roster, or comparing side hustle income, you want to see what you need to know from your data quickly.
To help get you there, we’re introducing Sheets canvas, a new feature built with Gemini that turns your Google Sheets spreadsheets into custom, interactive "mini-apps." With a simple natural language prompt, you can transform your data into a visual experience that’s easy to understand and even easier to use.
Visualize your data in new ways
Sheets canvas is a dynamic, read-write layer that sits directly on top of your spreadsheet data. This means that you can visually organize, edit, and navigate your data in whatever layout you imagine.
Here is what makes it so powerful.
• No coding required: No formulas or programming required. Just describe what you want — like "create a visual study tracker" — and Gemini builds it for you. • Always in sync: Whether you make changes to your canvas or to your sheet, updates are synced between the canvas and the original sheet in real time. • Easy to adjust: You can continue to polish and refine your Sheets canvas by prompting Gemini to make edits to layout, design, functionality, and more. • Fully collaborative: Since it lives as a tab in Google Sheets, your canvas can be shared with anyone, just like a regular sheet.
See it in action
We designed Sheets canvas to be as flexible as your imagination. Here are a few examples to show how you can start using it today.
1. Stay on top of the school year
For students, managing multiple subjects and deadlines is a full-time job. With Sheets canvas, you can turn a long list of assignments into an interactive study aid. Track progress, set reminders, and visualize the week ahead so you never miss a deadline.
2. Dominate your fantasy football league
Take your fantasy team to the next level by using Sheets canvas to build the ultimate command center for your roster. Create a custom dashboard to track player performance, compare stats side by side, and clearly visualize your path to the championship — all powered by the data in your sheet.
3. Simplify wedding planning
Juggling seating arrangements and meal choices just got infinitely easier. Sheets canvas transforms your guest RSVP data into an interactive seating chart. Just drag and drop guests to their tables, and rest easy knowing your central sheet stays up to date.
Try it now
Sheets canvas is now available globally in English to Google AI Pro and Ultra subscribers . It's rolling out starting today to Google Workspace customers on Business or Enterprise Standard and Plus plans, and to Google AI Pro for Education add-on subscribers.
Ready to see your data in a whole new light? Open a Google Sheets spreadsheet and select the “Create canvas” option in the Ask Gemini side panel to get started. Check out this article for more tips.
Get the latest news from Google in your inbox
Done. Just one step more.
Check your inbox to confirm your subscription.
Read original ↗ Content from Google AI Blog（Primary）