How to Use Gemini to Organise Data in Google Sheets

What is Gemini in Google Sheets?

Gemini in Google Sheets helps you:

• Create and explain formulas
• Organise and clean data
• Generate insights from your data
• Answer questions about your spreadsheet

Note: Gemini features require Google Workspace plans that include Gemini.

Accessing Gemini in Sheets

Side Panel

• Open a Google Sheet
• Click the Gemini icon (sparkle) in the right panel
• Or click Extensions > Gemini

Within Cells

• Select a cell
• Look for Help me organise or similar options
• Or use the side panel to reference specific cells

Getting Help with Formulas

Ask for a Formula

In the Gemini panel:

• "Write a formula to sum column B"
• "How do I calculate the average of cells A1 to A100?"
• "Create a formula that counts cells containing 'Yes'"

Gemini provides the formula and explains how it works.

Explain Existing Formulas

If you have a complex formula:

• Select the cell
• Ask: "What does this formula do?"
• Gemini explains each part

Fix Broken Formulas

• "Why is my formula showing an error?"
• "Fix this formula: =VLOOKUP(A1,B:C,2)"
• Share the error message for targeted help

Organising Data

Cleaning Data

Ask Gemini:

• "How do I remove duplicate rows?"
• "Clean up phone numbers to consistent format"
• "Split full names into first and last name columns"

Formatting

• "How do I format this as currency?"
• "Apply conditional formatting to highlight values over 100"
• "Create a dropdown list in column C"

Sorting and Filtering

• "Sort by date column newest first"
• "Filter to show only sales over $1,000"
• "How do I create a pivot table from this data?"

Analysing Data

Getting Insights

• "What trends do you see in this data?"
• "Summarise the key statistics"
• "What is the highest and lowest value in column B?"

Creating Charts

• "Create a bar chart showing sales by month"
• "What type of chart would best show this data?"
• "How do I add a trend line to my chart?"

Practical Examples

Sales Data

"Calculate total sales by region and show which region performed best"

Employee List

"Count how many employees are in each department"

Financial Data

"Create a formula to calculate year-over-year growth"

Inventory

"Highlight items where stock is below 10 units"

Tips for Better Results

Reference Specific Cells

• "Calculate the sum of A1:A50"
• "Use the data in columns B and C"

Explain Your Data

• "Column A has dates, Column B has sales amounts"
• "This is a list of customers with their purchase history"

Ask Step by Step

For complex tasks, break them down:

• "First, how do I clean up the data?"
• "Now, how do I create a pivot table?"
• "Finally, how do I visualise this?"

Limitations

• Complex multi-step operations may need manual intervention
• May not understand very specific business logic
• Works best with well-structured data
• Some advanced features may not be available

When to Use Traditional Methods

Sometimes built-in features work better:

• Data > Clean up suggestions: For automatic cleaning
• Insert > Chart: For quick chart creation
• Data > Pivot table: For complex analysis

Need Help?

Contact our helpdesk at helpdesk@netlumait.com.au or call 1300 521 162.