Using AI to Analyze Data

You have a spreadsheet full of data and a question -- "which customers are within 30 minutes of our warehouse?" or "show me a chart of sales by region" -- but translating that question into formulas, cell references, and chart configurations takes time.

GeoSheet includes Geovani, a built-in AI assistant that reads your data, understands your request, and executes multi-step operations directly in the spreadsheet. You describe what you want in plain English, and Geovani writes the formulas, creates the charts, and performs the analysis.

---

Worked Example: Analyzing Store Locations

You have a sheet with store data:

Step 1: Open Geovani

Click the Geovani button (floating circle, bottom-right corner) to open the chat panel.

Step 2: Ask a question

Type:

"Geocode all the store addresses in column B and create a map showing their locations."

Geovani will:

1. Read the data in column B to identify the addresses
2. Write =GEOCODE(B2) formulas in a new column for each address
3. Create a map chart displaying all the geocoded points

Step 3: Ask follow-up questions

The conversation continues with context, so you can build on previous results:

"Now calculate the distance from each store to our warehouse at 500 W Madison St, Chicago."

Geovani adds a column with =DISTANCE() formulas for each store.

"Which stores are within a 30-minute drive of the warehouse?"

Geovani computes =DRIVE_TIME() for each store and highlights or filters the results.

"Create a bar chart comparing annual revenue by region."

Geovani creates a bar chart from columns C and D.

---

What Geovani Can Do

Data operations

• Read cell values and understand your data structure
• Write values, formulas, and formatting to cells
• Add, rename, and reorganize sheets
• Sort and filter data

Formulas

• Write single formulas or fill entire columns
• Use any of GeoSheet's 140+ functions, including spatial formulas
• Explain what a formula does if you are unfamiliar with it

Spatial analysis

• Geocode addresses to coordinates
• Calculate distances and drive times
• Generate routes and isochrones
• Check point-in-polygon containment
• Find nearest neighbors

Charts and visualization

• Create bar, line, pie, scatter, and map charts
• Configure chart series, labels, and styling
• Pin charts to a side panel for persistent display

Map control

• Zoom, pan, and fit the map to specific bounds
• Set map view to a location
• Switch between map tile styles

---

Tips for Effective Prompts

Be specific about locations. Instead of "analyze the data," say "calculate the distance from each customer in column A to the warehouse in cell B1."

Reference columns and cells. Geovani understands your sheet structure, but explicit references reduce ambiguity: "sum column C" is clearer than "add up the numbers."

Ask for one thing at a time for complex operations. Geovani handles multi-step requests well, but if the result is not what you expected, break it into smaller requests.

Use follow-ups. After Geovani creates a column of distances, you can say "now sort by that column" or "highlight rows where the distance is over 100 km." Each message builds on the previous context.

---

How It Works

Geovani is powered by Claude (via AWS Bedrock) with 40+ specialized tools that can read and write to your spreadsheet. When you send a message:

1. Geovani reads relevant cells to understand your data
2. It plans the operations needed to fulfill your request
3. It executes tools -- writing formulas, creating charts, controlling the map -- directly in your spreadsheet
4. It responds with a summary of what it did

Geovani operates within your spreadsheet's permissions. It can read and modify the current spreadsheet but cannot access other spreadsheets or external data beyond what GeoSheet's built-in services (geocoding, routing) provide.

Each organization receives AI credits monthly (amount depends on your plan). Each Geovani interaction uses credits based on the complexity of the request. See Billing & Subscriptions for details.

---

Example Prompts

---

Next Steps

• Geovani AI Assistant -- full reference for Geovani's capabilities and tools
• Map Data in a Spreadsheet -- manually create maps (when you do not need AI)
• Formulas -- learn the formulas Geovani writes so you can modify them yourself
• Time-Based Data Analysis -- use Geovani with Time Warp for temporal analysis