Why AI won't solve your Excel problem

4 min read

"Can't we just use ChatGPT to automate this?"

Every business leader is currently thinking about Artificial Intelligence. And they should. But for many mid-sized companies, starting with AI is like putting a Ferrari engine into a carriage with wooden wheels. It might go fast for a second, but it will eventually fall apart.

Here is why your "AI project" should probably be a "Digitalization project" first.


1. AI needs data, not chaos

Imagine you have 47 Excel files, each with different formats, typos, and "notes" in random cells. If you feed this into an AI, you will get automated chaos.

AI is excellent at recognizing patterns. But if your pattern is "inconsistency," the output will be inconsistent. To benefit from AI, you first need a System of Record—a single source of truth where data is structured, validated, and clean.

First build the database. Then build the intelligence.


2. 80% of your problems are "Dumb"

Most inefficiencies in mid-sized businesses don't require complex neural networks. They require basic logic:

  • "If an order is over €10k, notify the CEO."
  • "If a document is missing, don't allow a status change."
  • "Calculate the commission based on this fixed percentage."

These are deterministic processes. They have a clear "Right" and "Wrong" answer. AI is probabilistic—it gives you a "best guess." For your accounting, production planning, or contract management, you don't want a "best guess." You want a result that is 100% correct, 100% of the time.


3. The "Shadow Work" Trap

Many companies use AI as a "band-aid" for bad processes. They have a staff member spend 4 hours a day copying data from one old system to another, and they want an AI to do the copying.

The better solution? Integrate the systems. A professional API connection is faster, cheaper, and more reliable than any AI trying to "read" a screen or a PDF.


When AI does make sense for SMBs

Once you have a solid, custom software foundation, AI becomes a powerful multiplier. Here are three areas where it actually delivers value:

1. Unstructured Data Extraction

If you receive hundreds of different-looking invoices or PDF contracts, an AI can "read" them and suggest values for your system. But a human (or a rule-based system) still needs to verify and save them into a structured database.

2. Intelligent Search (RAG)

Instead of searching for a file name, you can ask your system: "Show me all projects from 2023 that had a delay in the delivery phase." The AI searches your entire documented history and gives you a summary.

3. Predictive Maintenance / Analytics

If you have years of clean data from your production or sales, AI can help identify trends that a human might miss. "Based on the last 5 years, we will likely have a bottleneck in department X next month."


The Roadmap to AI

If you want to introduce AI in your company, follow these steps:

  1. Standardize: Turn your "Excel habits" into a documented process.
  2. Digitalize: Build a custom system that enforces this process and captures clean data.
  3. Integrate: Make sure your tools talk to each other automatically.
  4. Augment: Now add AI features on top of your clean data to automate the "smart" tasks.

Conclusion

AI is a tool, not a strategy. If your foundation is made of spreadsheets and manual workarounds, AI will only make your mistakes faster.

I help companies build the digital foundation they need to actually be "AI-ready." No hype—just systems that work.

Let's talk about your foundation

Still fighting manual processes?

Modernizing your business is a journey. If you need a technical partner to navigate it, I'm here.