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?
=AVERAGEIFS(J:J,H:H,"Sara Kowal")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
- 01Upload a CSV or Excel file, or open the sample sales sheet.
- 02Choose Ask your data and type a question.
- 03Read the answer and the explanation of how it was reached.
- 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.