Skip to content

Analyse a CSV without uploading it

Short answer

Drop the CSV into the assistant and ask for totals, averages or filtered counts. Aggregates are computed over every row rather than estimated by the model.

Model to use
Any model. The arithmetic is done by the tool, not the model.

Why do it locally

Row-level data is usually the most sensitive file in the folder and the one that most obviously wants an AI tool pointed at it.

How

  1. 01Drag the CSV into the assistant panel.
  2. 02Name columns exactly as they appear: “sum the Overtime_Hrs column”, not “add up overtime”.
  3. 03State filters explicitly: “count rows where Status is Paid and Amount is over 500”.
  4. 04For a comparison between rows, verify the result — comparisons are generated rather than computed.

Where it falls down

  • Merged or stacked header rows confuse column detection.
  • Mixed types in a column — numbers with the odd “N/A” — can skew an aggregate.
  • Asking for a judgement about the data rather than a calculation gets you a model's opinion, not arithmetic.

Other ways people ask this

  • analyse a CSV offline
  • analyse a CSV without uploading
  • How can I analyse a CSV using AI without sending row-level data to a company?

Related