Bring your spreadsheet data to life with Sheets canvas

Bring your spreadsheet data to life with Sheets canvas

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.

Director, Product Management, Google Sheets

Your browser does not support the audio element.

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."

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.

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.

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.

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.

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.

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.