Job 13 · Not yet tested
Which AI analyses my spreadsheet correctly?
Spreadsheet tools on one messy 5,000-row CSV. Five answers are computed before the run. One chart is specified.
People who will trust a number from a file only if it matches the file.
The standard test
Pack 0.1.0 · specified · Messy 5,000-row CSV
Messy 5k-row CSV, 5 known answers + chart
Setup
One CSV with messy types, blanks, and a few traps. Five questions have answers computed independently first. A sixth request asks for one comparison chart. Invented figures count against output quality even if the prose is fluent.
Inputs
The CSV and the six requests. No cleaned version on the side.
Time limit
One wall-clock cap for every tool in the job. The number is published with the pack before the first run and does not move between tools.
What we record
- Answers correct
- Invented figures
- Chart matches the request
- Time
- Cost
- Version
- Plan
How the FitScore is built
FitScore = weighted average × 20, rounded to the nearest integer. The weighted average is the sum of (criterion score × weight) divided by 100.
- Output quality30
- Reliability15
- Cost and free tier15
- Speed10
- Setup friction10
- Agent, API, and MCP support10
- Privacy and data10
5 excellent · 4 good · 3 usable · 2 poor · 1 fails. Full method.
Candidates
Candidates for Data analysis. This order is the launch list, not a ranking. No FitScores are published.
Version and plan recorded when a test is published
Version and plan recorded when a test is published
Version and plan recorded when a test is published
Version and plan recorded when a test is published
Version and plan recorded when a test is published
Version and plan recorded when a test is published
Questions this page answers
- Which AI analyses my spreadsheet correctly?
- FitForTool has not published a FitScore for this job. The launch candidates are ChatGPT data analysis, Claude analysis, Julius AI, Gemini in Google Sheets, Microsoft Copilot in Excel, and Hex. Each one is listed as not yet tested. A ranking is published only after every tool in the comparison has had the same test pack run, and a person has reviewed the result. Until that page shows a FitScore, there is no winner.
- How will FitForTool test data analysis?
- Messy 5k-row CSV, 5 known answers + chart. One CSV with messy types, blanks, and a few traps. Five questions have answers computed independently first. A sixth request asks for one comparison chart. Invented figures count against output quality even if the prose is fluent. We record answers correct, invented figures, chart matches the request, time, cost, version, and plan. Those notes are then scored from 1 to 5 on seven shared criteria. The pack has been specified and has not been run.
- Can a vendor pay to rank higher on this job?
- No. FitForTool does not sell position or score. A sponsorship, if we run one later, is labelled and sits outside the ranked list. An affiliate link is disclosed and does not change order. A vendor may ask for a retest, and we rerun the same pack. Sponsors do not see the result before it is public.
- What does "Not yet tested" mean?
- The tool is a candidate for this job. There is no published hands-on run, so there is no FitScore, no criterion score, and no rank. Research-only is a different label, used when we have read the docs and still have not run the pack. Neither label is a score.