New AI Can Fix Your Spreadsheet Mistakes — But Not All of Them

AI tools are getting better at helping people make charts and graphs from messy data. But a new study shows that while these AIs can spot simple problems like blank cells or wrong numbers, they often overlook trickier errors that can mislead you. For example, an AI might not realize that a date is out of order or that a location is wrong — mistakes that can make your chart tell a completely different story than your actual data.

Researchers tested some of the top AI models (like GPT-5 and Claude Sonnet 4.6) on a real dataset of 911 emergency calls with fake errors added in. They found that the AIs could fix problems like missing values, but they struggled with issues involving time, geography, or meaning. The study even tried using teams of AIs (like having one AI find the problem, another plan the fix, and a third check the work), but the results were still inconsistent.

The big takeaway? AI can save you time by catching some errors, but it’s not perfect. The researchers suggest that AI tools should be more open about their assumptions and ask for human help when things get confusing. In other words, don’t blindly trust an AI-made chart — always take a second look.

This matters because charts and graphs are everywhere: in business reports, news stories, and even social media posts. If the data is wrong, the decisions based on it could be wrong too — whether that’s a company cutting costs or a policymaker making a new law.