Create a Sheets canvas

Feature availability

• This feature is available in English and in the US.
• It's available in Gemini Alpha, which is available for work and school accounts only. Your administrator controls access to Gemini Alpha work and school accounts. If you can't find this feature, your administrator may not have Alpha features enabled for your organization.
• Only Google AI Ultra and Google AI Pro personal accounts are eligible.
• It's supported for Google Workspace Experiments, which is a trusted tester program for personal accounts to try new AI features. Learn more about Workspace Experiments.

Canvas may not be available if:

• You’re using the Sheets app on your mobile device.
• The data size of the tab is too large. Try reducing the amount of data on that tab.
• The ability to download, copy, and/or print is disabled in Sheets.
• You’re using a file stored in third-party storage or offline documents. You can only use canvas for files stored in Google Drive.

To convert spreadsheet data into interactive visual layouts in Google Sheets, use canvas with Gemini. This will build custom interfaces to manage and update information. Examples include:

• Dashboards
• Heat maps
• Kanban boards
• Custom, interactive visualizations

Create a canvas

To create a new canvas in Google Sheets:

1. On your computer, open a spreadsheet in Google Sheets.
2. Choose how you want to create your canvas. From the:
   • Side panel: Click Tools Create canvas .
   • Menu bar: Click Insert Create a canvas .
   • Bottom bar: Click Canvas menu Create a canvas.
3. In the prompt box, ask Gemini to build the interactive visualization. Example visualizations include:
   • Kanban boards:
     • Group tasks by status or category.
     • Drag and drop items to update progress in real time.
   • Gallery views: Display information in a card-based layout. You can sort and filter the data as needed.
   • Calendars: Plot campaign launch dates. Edit dates and create new events directly within the interface.
   • Dashboards: Perform data analysis on metrics, such as:
     • Pricing
     • Stock
     • Valuations
4. Optional: To make changes to your data after the canvas is generated, enter another prompt.
   • Example: "Convert this dashboard into dark mode."

Tips:

• Canvases only use data from a single Sheet tab.
• To find the underlying data on a canvas, click View data.
• To find existing canvases, use the bottom bar menu.

Manage your data in canvas

Important: The canvas provides a read-write interface for your spreadsheet data. If you have edit access, you can edit, delete, or add data directly within the canvas as an alternative to the grid view. If you have comment or view access, you can’t modify the canvas.

1. To change the name of your canvas, click the toolbar.
2. Enter a new name.
3. To save changes, click outside the toolbar.
   • Or, you can press Enter.
4. To manage your spreadsheet data, you can add, edit, or delete data directly in the canvas interface.
5. To remove the canvas, in the top toolbar, click Delete canvas .
   • If you don’t want to delete the canvas, you can keep it for future use.
6. To find the underlying data, click View data.
7. To exit the canvas, click any other tab in the spreadsheet.

Give feedback on generated suggestions

Google Workspace with Gemini is constantly learning and may not be able to support your request.

If you get a suggestion that’s inaccurate or that you feel is unsafe, you can let us know by submitting feedback. Your feedback can help improve AI-assisted Workspace features and broader Google efforts in AI.

Because feedback may be human readable, do not submit data that contains personal, confidential, or sensitive information.

• To submit feedback, in any suggestion, click More Send feedback.
• To provide general feedback on this feature, at the top, click Help Help Sheets improve.
• To report a legal issue:
  • Create a request.
  • Click Send feedback Report an issue.
  • Click Suggest an idea Legal Help.

Learn about Workspace Experiments feature suggestions

• Workspace Experiments feature suggestions don’t represent Google’s views, and should not be attributed to Google.
• Don’t rely on Workspace Experiments features as medical, legal, financial or other professional advice.
• Workspace Experiments features may suggest inaccurate or inappropriate information. Your feedback makes Workspace Experiments more helpful and safe.
• Don’t include personal, confidential, or sensitive information in your prompts.
• Google uses Workspace Experiments data and metrics to provide, improve, and develop products, services, and machine learning technologies across Google.
• Your Workspace Experiments Data may also be read, rated, annotated, and reviewed by human reviewers. Importantly, where Google uses Google-selected input (as described in the Privacy Notice) to generate output, Google will aggregate and/or pseudonymize that content and resulting output before it is viewed by human reviewers, unless it is specifically provided as part of your feedback to Google.

How Workspace Experiments data in canvas is collected

When you use canvas in Sheets, Google uses and stores the following data:

• Prompts you enter or select.
• Generated content.
• Google Workspace content that you have access to that’s referenced to generate content (both Google-selected input and user-provided input).
• Your feedback on the Gemini in Sheets side panel.

To understand how this data is used, review the Google Workspace Experiments Privacy Notice and Terms for Personal Accounts.

Related resources

• Get started with Google Workspace Experiments
• Google Workspace Experiments Privacy Notice & Terms for Personal Accounts
• Tables in Google Sheets with Gemini (Workspace Experiments)