SheetSense

Ask questions about a CSV file

Upload a CSV or Excel file to the SheetSense workspace and type a question such as "which sales rep has the highest average order?". The answer comes back with how it was worked out and, when useful, a formula and a pivot table setup you can use to confirm it on the full sheet.

Files are parsed in your browser. For a question, SheetSense sends the column names and an even sample of up to 200 rows to the AI, and keeps the first 5,000 rows and 50 columns of larger files. Because the answer is based on a sample, treat it as a fast first read and verify with the formula it provides.

Worked example: highest average order by rep

Sales sheet: column H is Sales rep and column J is Revenue. The question is: which sales rep has the highest average order?

Check in a sheet (one rep)
=AVERAGEIFS(J:J,H:H,"Sara Kowal")
Check in pandas (all reps)
import pandas as pd

avg = sales.groupby("sales_rep")["revenue"].mean()
avg.sort_values(ascending=False).head(1)

The pandas line ranks every rep by average revenue per order and returns the top one. The sheet formula checks a single rep, so run it for the named rep and compare it with the answer.

How it works

  1. 01Upload a CSV or Excel file, or open the sample sales sheet.
  2. 02Choose Ask your data and type a question.
  3. 03Read the answer and the explanation of how it was reached.
  4. 04Run the verifying formula on the full sheet before you rely on the number.

Common questions

Can I clean the data too?
Yes. The workspace can rewrite a column, split one into several, or tag rows with categories. Every change is shown as a before and after preview and only written when you click Apply.
How large can the file be?
Up to 15 MB. The first 5,000 rows and 50 columns are kept.
Is my file private?
Sheets are private to your account. The AI receives only what the action needs: the selected column for cleaning, and column names plus a sample of rows for questions.

Try it on your own formula

The Formula Translator is free for 5 formulas a day, with no account.