Gemini in Google Sheets can now help you build spreadsheets and fill in missing data

Google is upgrading Gemini in Google Sheets, and it can now help build and edit entire spreadsheets and automatically fill in missing data. In addition, Sheets is getting a new feature that helps users tackle advanced optimization problems that would normally require complex formulas or models.

Google says that generating or editing spreadsheets in Google Sheets is now easier than ever with Gemini. You can now use simple natural language prompts like “organize my upcoming move to Chicago. Create a checklist for packing by room, a contact list for utilities and a spreadsheet to track moving company quotes from my inbox,” and Gemini will automatically create the entire project from scratch by referencing information from your emails and files.

If you have an existing spreadsheet, you can also populate it with tables, dashboards, and more by simply describing what you need. Most notably, Gemini can now fill in missing data in tables with the new “Fill with Gemini” option that can “generate custom text, categorize data and summarize data or access real-time information from Google Search.”

For example, Google says if you’re filling out college applications and have a tracker for your application details with column headers for things like due date, tuition, etc., for multiple schools, Gemini fill can populate the columns based on information from the web by simply dragging down on the column.

For enterprise users, Gemini in Sheets can now handle complex analytical tasks. Powered by research from Google DeepMind and Google Research OR-Tools, this feature helps users solve problems that typically require advanced formulas or third-party tools using simple natural language prompts. Google illustrates this with an example where Gemini optimizes weekly employee scheduling to maximize profit while balancing staff availability and required skills.

The new features are rolling out globally in US English to Google AI Pro and Ultra subscribers, as well as enterprise users on the Gemini Alpha business plan.