Gemini in Sheets enables you to simplify complex data, reveal hidden insights, and create custom mini-apps Gemini in Sheets enables you to simplify complex data, reveal hidden insights, and turn your data into interactive mini-apps Enhance data with Gemini Build spreadsheets, visualize data in mini-apps, and fill data in seamlessly. Turn your data into interactive mini-apps Take your data beyond the grid with Sheets canvas . Create custom dashboards, heat maps, Kanban boards, and more, without writing a single line of code. Build and edit spreadsheets with a prompt Simply describe what you need, and Gemini helps synthesize data across your Workspace apps and the web to build or edit your spreadsheets with native formulas, pivot tables, and charts. Auto-populate your tables in moments Fill with Gemini helps you populate tables at scale with summarized, categorized, or new data from your adjacent table. Become a data pro with AI Uncover insights and trends, no matter your skill level. Write and debug formulas effortlessly Gemini keeps your momentum going by writing formulas for you from scratch. And if you encounter a formula error, Gemini explains the issue in plain language and fixes the formula. Get insights from your data Simply ask a question, and Gemini reviews your data to surface key insights and contextual trends. Calculate your optimal business solutions Define your goals and constraints, and let Gemini handle the calculation to solve complex problems directly within your sheet. Tackle business-critical tasks at scale Import, manage, and optimize your datasets. Connect to third-party data sources, right in Sheets Connect to data sources like Asana, HubSpot, Intuit QuickBooks, Salesforce, and more directly from your spreadsheet. Uncover big data insights with Connected Sheets Connected Sheets enables you to access and analyze BigQuery or Looker data right from your spreadsheet without writing a single line of SQL. Open and edit Excel files in Sheets Import Microsoft Excel files into Sheets to unlock powerful collaborative and assistive features, without having to make a copy. Enterprise-grade security you can trust Your data is encrypted by default, and an array of safety measures – like advanced client-side encryption , anti-abuse measures, and privacy controls – keep your data private . Work the way you want, wherever you are Stay productive on the go View, edit, and collaborate in Sheets from your phone, tablet, or desktop. Access your data, even offline

Create, view, and edit spreadsheets without an internet connection, keeping your workflows completely uninterrupted. Control spreadsheet access Easy-to-manage permissions lets you control who can view, comment, or edit your spreadsheets. Stay productive on the go View, edit, and collaborate in Sheets from your phone, tablet, or desktop. Access your data, even offline Create, view, and edit spreadsheets without an internet connection, keeping your workflows completely uninterrupted. Control spreadsheet access Easy-to-manage permissions lets you control who can view, comment, or edit your spreadsheets. Learn why organizations use Sheets Google Workspace with Gemini continues to transform how we work at Globe Telecom. Bringing capabilities like Sheets canvas directly into daily workflows allows our teams to analyze data, streamline processes, and innovate faster—empowering every employee to solve problems and drive productivity securely at scale. Sharing Sheets in the cloud brings many advantages. Apart from the technical aspect, this solution allows us to work simultaneously on the same document, and we can track all changes made with robust version history features, which is necessary due to backup and business continuity issues. This directly impacts on the quality of our services. One of our customer support teams has embraced Gemini to help with data analysis. [...] Now that everyone has access to Gemini, the entire team is empowered to expand their skillset and glean insights from their own analyses instead of exclusively funneling the requests through a single analysis partner. One of my favorite parts of Gemini in Sheets is that it helps me create formulas. I used to have to go to as many as five different sources to figure out how to write the correct formula. Now with Gemini in Sheets I can just type what I need and Gemini will provide the formula perfectly written out and reference relevant cells - this functionality has completely changed the way I work with Sheets. I'm saving time and can better understand how formulas work to make calculations. Google Sheets is our preferred spreadsheet application, giving us a real-time solution for collaboration to activate data-driven decisions. It used to be challenging to keep track of where we were in the process but the Gemini in Sheets feature in Google Sheets has become our secret weapon, allowing us to design step-driven processes with unparalleled flexibility. Now, we have a unified place to build and organize plans, trackers, and timelines, and keep them up to date in real time. Curious about Google Sheets? Take a look at our FAQs to learn more. Anyone with a Google Account can create in Sheets. However, some Gemini in Sheets features are only available on Google Workspace plans. See plans and pricing for organizations or Google Workspace Individual . Anyone with a Google Account can create in Sheets. However, some Gemini in Sheets features are only available on Google Workspace plans. See plans and pricing for organizations or Google Workspace Individual . Yes. You can convert Microsoft Excel spreadsheets into Google Sheets format, or you can directly edit Excel spreadsheets, without having to make a copy. The original file will remain intact. To use Gemini features like Sheets canvas or Fill with Gemini, convert the file to Google Sheets format. Yes. You can convert Microsoft Excel spreadsheets into Google Sheets format, or you can directly edit Excel spreadsheets, without having to make a copy. The original file will remain intact. To use Gemini features like Sheets canvas or Fill with Gemini, convert the file to Google Sheets format. Co-editing means that multiple people can work on the same spreadsheet at the same time, without having to send versions back and forth. Sharing settings allows you to control who can view and edit a spreadsheet, and revision history enables you to revert to earlier versions. Co-editing means that multiple people can work on the same spreadsheet at the same time, without having to send versions back and forth. Sharing settings allows you to control who can view and edit a spreadsheet, and revision history enables you to revert to earlier versions. Sheets is built for complex, enterprise-level tasks. You can manage large spreadsheets with improved processing speeds that make it faster to open, filter, and apply formatting to large spreadsheets. For massive cloud data, Connected Sheets lets you interact with billions of rows of BigQuery or Looker data right inside your grid. Sheets is built for complex, enterprise-level tasks. You can manage large spreadsheets with improved processing speeds that make it faster to open, filter, and apply formatting to large spreadsheets. For massive cloud data, Connected Sheets lets you interact with billions of rows of BigQuery or Looker data right inside your grid. Yes. With Sheets canvas, you can create interactive mini-apps right on top of your data. You can create dashboards, heat maps, and Kanban trackers directly from a simple text prompt without writing any code. Yes. With Sheets canvas, you can create interactive mini-apps right on top of your data. You can create dashboards, heat maps, and Kanban trackers directly from a simple text prompt without writing any code. Manage, visualize and analyze data with Google Sheets Manage, visualize and analyze data with Google Sheets Sign up for productivity, collaboration, and AI updates