Creating Spreadsheets with Gemini

Generating a Spreadsheet from a Prompt

Gemini can generate complete spreadsheets directly inside Google Sheets using natural language prompts. Instead of building tables manually, you can simply describe the spreadsheet you need, and Gemini will create an organised worksheet with appropriate columns, headings, and data.

Before generating a spreadsheet, you can configure Gemini's access to different information sources. For example, enabling web access allows Gemini to gather relevant information from the internet when creating content. You can also enable Build mode, which gives Gemini permission to make more extensive edits to the current spreadsheet.

When generating information based on external sources, Gemini may ask you to approve the sources it intends to use before creating the spreadsheet. Once generated, you can review the referenced sources, helping you verify the accuracy of the information.

Creating Spreadsheets from Google Drive Files

Gemini can also create spreadsheets using files stored in your Google Drive. By attaching documents such as invoices, reports, or other supported files, you can instruct Gemini to extract key information and organise it into a structured table. This eliminates the need to manually copy information between documents.

Summaries and Visualizations

In addition to creating tables, Gemini can automatically generate useful summaries and visualizations, such as totals, calculated values, and charts, making it easier to analyse your data at a glance.

By combining natural language prompts with information from the web or your own files, Gemini provides a fast and efficient way to create organised, data-rich spreadsheets.