AI for spreadsheets: what it can do for your business, and when it isn't enough

You run the business from six spreadsheets, and someone spends every morning copying order emails into rows. Only one person really knows how the master sheet works. AI for spreadsheets promises to take some of that weight off your team, and parts of it deliver.

This plain-English guide covers the AI options in Excel and Google Sheets and how to use them safely. It also shows how to tell when the spreadsheet itself is the problem.

What AI for spreadsheets actually means

AI for spreadsheets means assistants built into or added onto Excel and Google Sheets. You ask in plain language for formulas, summaries, charts, clean-up or categorisation, and the assistant builds them for you.

Inside the spreadsheet, this AI comes in two forms. One is an assistant that builds and edits the workbook from plain-language requests. The other is an AI function you type into a cell, the same way you would type any formula.

Outside the spreadsheet, other add-ons and standalone tools exist. Compare them against the criteria in this guide before you rely on one for daily work.

In the US at least, most small businesses are still early with any of this. The [Census Bureau AI use survey](https://www.census.gov/library/stories/2026/05/ai-use-businesses.html) found overall AI usage hovered between 17% and 20% of US employer firms, December 2025 to May 2026. The US Census Bureau also reported that less than 20% of firms with four or fewer employees were using AI.

Those are US figures, and we found no comparable South African number. Read them as a rough signal only: if you haven't started, you aren't behind.

The useful way to think about AI in a spreadsheet is as help with the job the sheet does. A sheet exists to track orders or stock, and AI earns its place when that tracking takes less of your team's time. We apply the same idea to AI agents, which we build as digital staff that handle the work itself.

What to look for in an AI spreadsheet tool

Before you pay for any AI for spreadsheets, judge it on the time it saves and how far you can trust its numbers. Model names and technical specs matter far less to an owner than the five questions below.

• It works where your data already lives, in Excel or Google Sheets, without exporting files.
• It handles your volume, because some tools cap how many cells run per batch or per month.
• It shows its work, so you can see the formula or the source row behind each answer.
• It has clear pricing on the plan you already pay for.
• It handles your data in a way you are comfortable with, especially customer and supplier details.

Behind all five sits accuracy, because a fast wrong answer costs more than a slow right one. A NIST evaluation plan, drawing on its Generative AI Profile (AI 600-1), treats this problem as a named generative AI risk called confabulation. [NIST's confabulation definition](https://ai-challenges.nist.gov/uassets/7) describes it as "the production of confidently stated but erroneous or false content."

In a spreadsheet, confabulation looks like a formula that runs cleanly and returns the wrong total. It can also look like a confident summary of a column that skipped half the rows. Neither error announces itself, which is why the "shows its work" question above matters so much.

The main AI options for Excel and Google Sheets

Most owners should start with the AI already inside the software they pay for. If your business runs on Microsoft 365, that means Copilot in Excel. If it runs on Google Workspace, that means Gemini and the AI function in Sheets.

Add-on AI for spreadsheets comes second, once you know what the built-in tools can't do for you. Plans and features change often, so treat what follows as a guide and check the live pages before you buy.

Microsoft Copilot in Excel

Copilot is built into Excel for Microsoft 365. [Microsoft's Copilot getting-started guide](https://support.microsoft.com/en-us/excel/copilot/get-started-with-copilot-in-excel) says Copilot in Excel helps you build and edit workbooks. You ask in plain language, and Microsoft lists help with formulas, charts, PivotTables and quick insights into your data.

It needs an eligible Microsoft 365 or Copilot licence, and what you get varies by licence. Check what your current plan includes before you assume you have it, as we couldn't confirm South African pricing or availability.

Microsoft is unusually frank about the limits. [Microsoft's Copilot in Excel FAQ](https://support.microsoft.com/en-us/excel/copilot/frequently-asked-questions-about-copilot-in-excel) says Copilot "can sometimes make mistakes, misinterpret information, or produce inaccurate results." Microsoft's page also tells users to "Review, edit, and verify anything Copilot creates before you rely on it."

The same FAQ advises against using Copilot for decisions in sensitive areas such as finance. For an owner, that means Copilot can draft your cash-flow formulas, but a person should check them before anyone acts on the numbers. Even the vendor sets that expectation, which is a healthy place to start.

Does AI replace Excel? Copilot works inside Excel, so your workbooks and formulas stay where they are. The AI speeds up the work in the file without replacing it.

Gemini and the AI function in Google Sheets

Google Sheets offers an AI function you type into a cell, the same way you would type a formula. The function handles text jobs like categorising customer comments by theme. It can also summarise long entries into a single line.

There are limits worth knowing before you plan around it. [Google's AI function guide](https://support.google.com/docs/answer/15877199?hl=en) says the feature requires "an eligible Google Workspace or Google AI plan." Google also states that "only the first 350 selected cells with AI functions will be generated" in a run.

Google's guide adds that "Responses are limited to text," and AI functions can't be nested inside each other. Limits like these matter for a business with thousands of order rows. At 350 cells a run, a 3,000-row order sheet needs nine separate runs to fill one column.

Is it free? That depends on your plan. As of October 2026, [Google Workspace AI usage limits](https://knowledge.workspace.google.com/admin/generative-ai/workspace-with-gemini/about-ai-usage-limits) lists "No access" to the Sheets AI function on Business Starter.

On the same Google page, Business Standard and Business Plus get 5,000 AI function uses per month. AI Expanded Access gets 25,000 per month. Limits change, so check the live page and confirm the feature works in South Africa before you rely on it.

ChatGPT and other add-ons

General-purpose chat assistants such as ChatGPT can help you draft formulas or work through a file you share with them. Plan features and limits change, so check OpenAI's current plan details before relying on it for business data.

Other add-ons and standalone tools exist too. Compare them against the criteria in this guide before you commit your order sheet to one.

Each of these tools solves a task inside the sheet. None of them changes how the work reaches the sheet in the first place, which is a separate problem we come back to below.

Quick comparison: which option fits which business

The table sums up the main options using only what the vendors publish. Where no official limit was confirmed, the table says what to check instead.

Option	Works in	How you use it	Limits to know	Best fit
Copilot in Excel	Excel for Microsoft 365	Plain-language requests that build and edit the workbook	Needs an eligible Microsoft 365 or Copilot licence; Microsoft says to verify output	Businesses already on Microsoft 365
Gemini and the AI function in Sheets	Google Sheets	The AI function typed into cells	Eligible plan required; 350 selected cells per run; text-only responses; monthly caps by plan (October 2026)	Google Workspace users sorting or summarising text columns
ChatGPT and other chat assistants	A separate chat	Ask for help drafting formulas or working through a file you share	Plan features and limits change; check OpenAI's current plan details	Drafting formulas and one-off questions
Other add-ons and standalone tools	Varies by tool	Varies by tool	Compare them against the criteria in this guide	Gaps the built-in tools don't cover
BI platform with AI	A separate platform that pulls from many sources	Dashboards and reports built on connected data	Steeper learning curve for a small team	Businesses reporting across several systems

If you're unsure, pick the row that matches the software you already pay for. Running a short test there costs you an afternoon, which beats a new subscription you might not need.

How to use AI in your spreadsheet, step by step

Using AI for spreadsheets well comes down to a short routine, and it works with any of the tools above. The first and last steps take the most care, and they're the ones people tend to rush.

1. Tidy the data so each row holds one record under a single header row. Unmerge any merged cells before you start.
2. Pick the tool you already pay for, so you can test without a new subscription.
3. Write a specific prompt that names the columns and the output you want.
4. Test the prompt on 5–10 rows and check every result by hand.
5. Apply the prompt to the full range once the test rows come back right.
6. Check the results against the source, such as the original order emails or invoices.

On step 3, specific beats clever. Compare "Put Wholesale or Retail in column D, based on the customer name in column B" with "sort my customers." The first names the input column and the output column, so the tool knows where to look and where to write.

On step 4, a small test shows you how the tool reads your data before it touches thousands of rows. If three of your ten test rows are wrong, fix the prompt or the data first.

Step 6 is the one you can't skip. [Panko's spreadsheet error research](https://arxiv.org/pdf/1602.02601), a 2015 review by Raymond Panko of the University of Hawai'i, reported errors in 94% of 85 audited operational spreadsheets. The same review found that reviewers in experiments caught about 60% of errors on average.

Those audits date from the 1990s to 2001 and covered mostly corporate models, so they say nothing about AI error rates. They do show that spreadsheets built by people go wrong often, and that a quick look misses a lot. AI can speed up the work, and Microsoft's own FAQ still tells you to check what it produces.

AI spreadsheet tools vs BI platforms

AI spreadsheet tools work inside the file, at the level of cells and rows. They clean up entries and write formulas in the place your team already works.

BI platforms sit outside the spreadsheet and pull data from many sources into dashboards and reports. They give a wider view of the business, with a steeper learning curve for a small team.

In our experience, a live dashboard that fills itself often matters more than either. For one manufacturing business, we automated the step where order emails were copied out by hand. Each email is now read and captured automatically, and the order lands on a live dashboard that replaced the printed sheet.

Nobody prints or retypes orders anymore, and the team works from one view of what's coming in. You can see how this works in our [software for manufacturers](https://smileandwhistle.com/industries/manufacturing).

Where AI in a spreadsheet stops helping

AI for spreadsheets makes each file faster to work in. It doesn't join up six of them, and it can't capture the WhatsApp message that never reached the sheet.

When work goes missing between those places, the cause usually sits in the processes and systems around your people. That's the view we've formed working inside small and medium businesses, and it shapes the rest of this section.

The work that feeds the spreadsheet

In the businesses we work with, much of the spreadsheet effort goes into copying things in, like order emails and customer requests. AI inside the sheet can't help with that, because the data hasn't arrived yet.

Automation reads and captures that information as it arrives, so the rows fill themselves. When you [automate the repetitive admin](https://smileandwhistle.com/automation), your team stops re-keying and starts working from current numbers.

AI agents go a step further and handle the questions and admin around the data. For a Smile & Whistle client's 100-mile trail race, one of our [AI agents that work like staff](https://smileandwhistle.com/ai-agents) handles around 20 emails a day. A person used to do that by hand, and the change freed the five organisers to focus on the race.

Signs you've outgrown spreadsheets

There's no official threshold for outgrowing spreadsheets, so these signs are our judgment from working with owners. If several sound familiar, the spreadsheet has likely become the bottleneck.

• Several sheets track the same thing, and they rarely agree.
• One person understands the master file, and work stalls when they're away.
• Stock or jobs get lost between one update and the next.
• Staff re-key details from email or WhatsApp into the sheet.

Spreadsheet mistakes also carry real costs, and South Africa has public examples. The European Spreadsheet Risks Interest Group collects press reports of these failures in one archive.

The [EuSpRIG spreadsheet horror stories](https://eusprig.org/research-info/horror-stories/) archive includes a 2019 South African case where R40m in pension overpayments stemmed from a "hard-coding error." Another entry, from 2017, describes an Eskom fine first put at R2.2bn that "should have been R722m."

Both cases involve large organisations, so read them as examples only. The lesson for a smaller business is that one wrong cell can travel a long way before anyone notices.

From spreadsheet chaos to one clear system

A logistics company was running its whole operation across multiple spreadsheets and kept losing track of inventory in its warehouses. We built a custom platform around exactly how they work, including their vehicles, hubs and clients.

Before	After
Operations spread across multiple spreadsheets	One custom platform built around how the business runs
Warehouse inventory kept going missing	Nothing gets lost now

The business now runs with clarity instead of confusion. You can read the [logistics company's spreadsheet story](https://smileandwhistle.com/case-studies/events-logistics) for the full picture.

The platform is also ready for AI agents and automation to be added on top when the business wants them. That's the point of a [custom platform built around you](https://smileandwhistle.com/platforms), because it grows with the operation and the client owns it.

FAQ

Short answers to common questions about AI for spreadsheets. Plans and limits change, so check the vendor pages linked above for the latest detail.

Can ChatGPT create spreadsheets?

General-purpose chat assistants such as ChatGPT can help you draft formulas or work through a file you share with them. Plan features and limits change, so check OpenAI's current plan details before relying on it for business data.

Is Google Sheets AI free?

It depends on your plan, and as of October 2026 Google lists no AI function access on Business Starter. Business Standard and Business Plus get 5,000 uses a month.

What AI is replacing Excel?

None of the main AI tools replace Excel, because Copilot works inside it. When a business outgrows spreadsheets altogether, the usual next step is a system built around how it operates.

What is the best AI tool for Excel?

For most businesses on Microsoft 365, the best AI for Excel to start with is Copilot, because it works inside the workbook you already use. It needs an eligible licence, and Microsoft says to verify everything it creates.

What is the best AI for Google Sheets?

The AI function in Sheets is the natural starting point for Google Workspace users, as long as your plan includes it. Other add-ons and standalone tools exist, so compare them against the criteria in this guide if you need more.

Can AI analyze data directly in Excel or Google Sheets?

Yes, Copilot in Excel and the AI function in Sheets both work on your data in place. Other add-ons and standalone tools exist, so compare them against the criteria in this guide.

What is the difference between AI spreadsheet tools and BI platforms?

AI spreadsheet tools work inside one file at the cell and row level. BI platforms pull from many sources into dashboards and reports, with a steeper learning curve.

Ready to stop running the business from spreadsheets?

You don't need to know which tool you want before we talk. Tell us how your business runs today and where things get lost, and we'll tell you honestly what we'd do about it.

We're built in South Africa and work with owners across the country. If you'd like to see the kind of work involved first, browse [more of what we build](https://smileandwhistle.com/case-studies).

[Let's talk](https://smileandwhistle.com/#contact)