I don't why she swallowed a fly
Sorry, but while I agree with the diagnosis, the proposed solution reminds me of the old rhyme (sung forever in my mind by Burl Ives) of the old woman who swallowed a fly.
What you actually describe is a failure to enforce the data model and the solution for this would be to help users to model the data they want so that this can be enforced and deviations immediately raise errors.
Spreadsheets are great for ad hoc reports but absolutely terrible for storage and workflows, so anything that uses them should remove all processing from Excel, leaving it to be a GUI for looking at tabular data. It's very good at this, which explains its enduring popularity.
From a programmer's perspective we think it should be easy to define the schema, implement whatever workflows are required and forget it. But decades of experience have shown us that many business are unable to do something like define a schema (and let's leave out some of the trickier questions of data types and indices), though they can come agonisingly close. We do now have the tools that give users more expressive power, I'm thinking here of the combination of Jupyter notebooks and Pandas. How about at adding some kind of iterative process allowing them to specify the schema by answering business questions? This allows them to bring their knowledge of the situation to the table rather than hoping ML will spot random anomalies. AI could certainly help suggest questions and drive a graph that would lead to the right kind of schema.