Built an a tool that analyzes huge Excel files with interactive visuals — ChatGPT couldn’t handle it so I made my own thing

Hi all, this started because chatgpt + claude completely choke on large csv/xlsx files. I was trying to analyze some big excel files (like 10k+ rows) and every time I fed it into an LLM, it would either cut off the context or start making up stuff.

So I ended up building a custom AI chat that uses python under the hood — not just one prompt, but an actual orchestrated set of AI agents:

It processes and chunks the data
Detects statistical anomalies (spikes, drops, weird segment shifts)
Then uses AI to summarize it in actual human terms like:“Revenue dropped 30% in the West region compared to last week” “Support tickets for enterprise customers doubled on March 6th”
Best of all it uses interactive visualisation to do it.

So I ended up building a custom AI chat that uses python under the hood — not just one prompt, but an actual orchestrated set of AI agents:

It processes and chunks the data
Detects statistical anomalies (spikes, drops, weird segment shifts)
Then uses AI to summarize it in actual human terms like:“Revenue dropped 30% in the West region compared to last week” “Support tickets for enterprise customers doubled on March 6th”
Best of all it uses interactive visualisation to do it.

Anomaly AI

AI Data Analyst for Large Spreadsheets

AI Data Analyst for Large Spreadsheets