AI Spreadsheet Tools, Scored: Google Still Recommends a Dead One

The best AI spreadsheet tool depends on where your data already lives: Claude for Excel for financial models, Microsoft 365 Copilot for Excel-native teams, Shortcut for agentic edits to the workbook you already have, Gemini for Google Sheets, Quadratic and Sourcetable for Python-and-SQL analysis, and Grist if you want it free or self-hosted. Skip Rows, which Google’s AI Overview still recommends two months after its own maker announced the product would fully wind down on May 31, 2026.

Updated August 2026. Every price below was read off the vendor’s own pricing page on July 30, 2026; Rows, Quadratic and the live SERP were re-read on August 5, and the whole table was re-read again on August 6 when three tools were added.

The ten at a glance

Scores are our judgment on documented evidence, not a benchmark.

The AI spreadsheet Google recommends most is dead

Search “ai spreadsheet” and Google’s AI Overview sorts the field for you: Copilot and Gemini under “Native Ecosystems,” Formula Bot under “Dedicated Add-ons & Web Apps,” and, under “Data Enrichment & Scraping,” Rows AI next to Numerous.ai. Four of those five are fine. Rows published its own obituary in February.

On February 22, 2026, Rows’ founders announced Superhuman had agreed to acquire the company, and wrote that they planned to “gradually sunset the Rows product over the next three months, with Rows.com fully winding down on May 31, 2026.” That date passed two months ago. On August 5, 2026, rows.com/pricing still renders Plus at $8 per user per month and Pro at $79 plus $8 per user per month, with working Get Started buttons, under a banner reading “Rows joined Superhuman.” The annual column is still live too, at $6 per user per month and $59 plus $6 (verified Aug 5, 2026).

There’s a second tell. On the same day, Rows had dropped out of the organic top eight for “ai spreadsheet” altogether, and Google’s AI Overview was still naming it. The ranking system quietly demoted the product; the answer layer didn’t notice.

We didn’t put a card in, so we can’t say whether checkout completes. What is verifiable: a product with an announced end-of-life is still on sale, and Google’s AI still recommends it.

Nobody independent is refereeing this category

That mistake survives because nothing is checking it. On August 6, 2026 we pulled the other half of the demand, “best ai for excel spreadsheets 2026”, the query where reviews are supposed to live. We pulled it twice, independently, the same day. Both came back the same. The top ten: gptforwork, findanomaly.ai, kuse.ai, getelyxai.com, an r/vibecoding thread, a Medium post, julius.ai, a YouTube video, knack.com, lumichats.com.

Seven of those ten are products with something to sell, and four of them hand themselves a place in their own ranking. Anomaly ranks ten Excel AI tools and slots Anomaly in at two. Elyx ranks the best Excel AI tools and opens with Elyx. Julius ranks nineteen and puts itself second. Knack ranks ten and takes the top spot outright.

Then there’s the fifth one. Google’s answer box on that query, the text above the results that most people read instead of clicking, is lifted from gptforwork’s own blog, which names GPT for Work first among the tools it recommends. The vendor isn’t just ranking. The vendor is the answer.

No Wirecutter here, no PCMag, not even Zapier. The closest thing to a disinterested voice on page one is a Reddit thread from August 2025, quoted further down this page. That empty referee slot is why this page exists, and it’s why a dead product can keep collecting recommendations for two months.

How we scored this (and what we didn’t do)

We have not run a quarter-close on ten spreadsheet AIs, and any page claiming it did should show you the workbook.

Here is the actual method. We opened every vendor’s pricing page on July 30, 2026 and wrote down what it said, promotional asterisks included, then read all ten again on August 6. We read each vendor’s own documentation for what its tool refuses to do, which is where the useful admissions live. We recorded the live SERP and AI Overview three times across a week, and the review-intent SERP twice on the last day. And we read both Reddit threads where people who do this for a living argue about it, 124 comments between them.

The comparison that would actually settle this is one workbook, every tool, identical prompts. It needs artifacts we don’t have yet, so we haven’t claimed it.

Ratings are ours, no vendor saw a draft.

Best for financial models: Claude for Excel

Anthropic’s add-in is the only tool here built for people whose spreadsheets are the deliverable. It answers questions about a workbook with clickable citations down to the cell, changes an assumption while preserving the formula dependencies underneath it, traces a #VALUE! to its source, and fills a DCF template from an uploaded 10-K.

It’s also blunt about its limits. Anthropic’s documentation lists data tables, macros and VBA as unsupported, calls the add-in “not recommended” for final client deliverables without human review, and carries a prompt-injection warning no competitor matches: use it only with trusted workbooks, because Anthropic’s own testing found cases where a poisoned template could make Claude exfiltrate or corrupt data.

There’s no separate SKU: it comes with Claude Pro at $17 per user per month on annual billing ($200 up front) or $20 monthly, Max from $100, Team seats $20 annually, Enterprise $20 per seat plus API-rate usage (verified Jul 30, 2026). Its Microsoft Marketplace listing sits at 2.8 stars across 165 ratings.

Skip it if your workflow runs on macros or VBA, or you need audit logs. On Free, Pro, Max and Team plans, observability and auditability aren’t available for the add-in at all.

Best AI for Excel if you already pay Microsoft: Copilot

Copilot’s advantage is position rather than intelligence. It’s in the Home ribbon of the file you already have open, writes formula columns, cleans duplicates and inconsistent formats, and builds charts and reports without an export step.

Two things Microsoft’s own “AI in Excel” page won’t tell you. It never states a price; it tells you to go sign up for Microsoft 365 Copilot. And its instructions require the file to sit on OneDrive or SharePoint, excluding anyone working off a local drive or a client’s network share.

The real number takes digging. Copilot Business is an add-on, not a plan: $21 per user per month paid yearly, promoted at $18, or $25.20 on monthly commitment, and it needs an eligible Microsoft 365 Business plan underneath (verified Jul 30, 2026). The $18 is a first-year promotion expiring September 30, 2026, so budget for $21. Bundled: Business Standard with Copilot $23.50 yearly, Premium $32.

Skip it if your files live on a local disk, or Excel was the only app you wanted it in: you’re buying a licence spanning Word, PowerPoint, Outlook and Teams either way.

Best AI-native grid: Quadratic

Quadratic redesigned the spreadsheet instead of bolting a chat pane onto one. Python, SQL, JavaScript and formulas run in one grid, wired straight to Postgres, Snowflake, QuickBooks or Plaid, with an MCP server and scheduled tasks. Its analysis lands as code in cells you can open and correct, the difference between an answer and a black box.

Pricing is published and legible: free Personal tier, Pro $18 per user per month billed annually with $20 of monthly AI credits, Business $36 with $40 of credits, Enterprise custom (verified Aug 5, 2026). You buy seats and metered AI, so heavy months cost more than the sticker.

It also picks up the kind of endorsement money doesn’t obviously buy. In the r/vibecoding thread below, the reply that engages hardest with the problem, and has nothing to sell, talks the poster out of in-sheet AI entirely, then names Quadratic by URL as one of the “newer tools and environments that blur that line a bit.” In the r/dataanalysis thread, a second unaffiliated commenter reports starting on Claude and moving to Quadratic. Two threads, eleven months apart, two people with no stake naming the same product.

Skip it if the workbook has to go back to a client in .xlsx with every macro intact. Quadratic is a new home for your data, not a visitor to the old one.

Best agent for the workbook you already have: Shortcut

Every complaint in both Reddit threads below points at the same hole: the models are good, but they aren’t in the file. Shortcut is the tool built directly into that hole. It runs on the web and desktop, and — the part that matters — as an Excel plugin and a Google Sheets plugin, so the agent works on the workbook already sitting in your OneDrive rather than on an export of it.

It is also the most expensive seat on this page by a distance. Free gives you 20 credits a week. Pro is $100 a month billed annually. Teams is $320 a month plus $100 per seat, also annual (verified Aug 6, 2026). Shortcut says a message “typically takes 2-15 credits,” which is unusually candid metering disclosure and also a warning: a heavy Thursday is a real invoice. It badges SOC 2 Type II, GDPR and CCPA, and says it doesn’t train on your data.

There is demand here the rest of this category hasn’t noticed. “Shortcut ai for excel” gets 390 US searches a month on its own — more than most of these products’ branded terms combined.

Skip it if you open a spreadsheet on Tuesdays. At $100 a month you’re paying consultant rates for a part-time habit, and Claude Pro at $17 does most of it.

Best free tier that isn’t a demo: Sourcetable

Sourcetable gives away more than anything here that isn’t open source: 50 AI credits a month on the free plan, full A1-style formula referencing, charts, connectors, and files up to 10GB. Pro is $29 per user per month for 2,000 credits and Max is $100 for 6,000 (verified Aug 6, 2026). Top-up credits start at $10 and, unusually, never expire — the opposite of the monthly-evaporation model everyone else runs. Students and faculty get 50% off.

It answers the Reddit rule directly, too: Python, SQL, pandas, scikit-learn and matplotlib run against your data, so the tool executes rather than predicts. Sourcetable claims SOC 2 Type 2, HIPAA and PCI compliance and says the models aren’t trained on your data. Its claims, its page.

Skip it if the deliverable is the workbook itself. Sourcetable is somewhere you go; the twelve colleagues who edit your file every week are not coming with you.

Best free spreadsheet you can actually own: Grist

Grist is the value answer and it isn’t close. The hosted free plan gives you unlimited documents at 5,000 records each, Python formulas, per-cell access rules and real-time collaboration. The Community edition is open source on GitHub and costs nothing to self-host, and any organisation under $1 million in total annual income can request a free activation key for the fuller edition. If you have ever wanted a spreadsheet nobody can take away from you or shut down in three months, this is it — a pointed contrast with the tool at the bottom of this page.

Read the AI line carefully. Free includes 100 AI Assistant credits for the lifetime of the account, not per month. Pro at $8 per user per month annually ($10 monthly) moves that to 100 a month, Business at $24 gets 2,000, and top-ups run $10 a month for 500 credits or $29 for 2,000 (verified Aug 6, 2026).

Skip it if AI is why you’re shopping. Grist is an excellent free spreadsheet-database with AI attached, and its free AI budget is gone by lunchtime on day one.

Best if you live in Google Sheets: Gemini

If your company already runs on Google Workspace, the first move is to stop shopping. Gemini in Sheets structures raw data, builds visualisations and answers questions about a range, with no install and no second bill.

One tier detail decides whether you have it: Google’s own comparison table marks Gemini in Sheets unsupported on Business Starter and supported from Business Standard upward (verified Jul 30, 2026). Starter customers get Gemini in Gmail and nothing in the spreadsheet.

We can’t give you the dollar figure honestly: Google’s pricing page geolocates, and it served us Polish pricing twice, zł 63 per user per month for Business Standard, including on the /intl/en_us/ path. The tier requirement is fact; the USD price is flagged, not guessed.

Skip it if your analysis is heavier than your spreadsheet. Gemini in Sheets is a good assistant and a poor analyst, it won’t touch Power Query or array-formula work, and the bluntest verdict on it in the r/dataanalysis thread below is “utter trash,” from an analyst who now has Gemini CLI write the Python instead. Ours is the kinder read; his is the one to weigh if Sheets is where your hard work happens.

Best free option for one-off jobs: Formula Bot

Formula Bot is where the free tier genuinely wins on narrow jobs, in a way Grist’s doesn’t. It converts a PDF or bank statement into rows, generates Excel and Sheets formulas, writes SQL, regex, VBA and Apps Script, and answers questions about an uploaded file, with no plugin and no Microsoft 365 subscription.

Paid tiers are Starter $18 a month for 250 messages and 2,500 AI Actions, Max $29 per user, Enterprise $149 (verified Jul 30, 2026). The one card the page won’t render for a crawler is the free one, so treat “free” as confirmed to exist, unconfirmed in its limits.

Skip it if you want AI inside your grid. This is a separate web app that hands things back, and your spreadsheet stays where it was.

Cheapest bulk AI in a grid you own: Numerous.ai

For one job, running a prompt down 500 rows to categorise, extract or clean, Numerous.ai is still the cheapest sane answer. It installs into Google Sheets and Excel, exposes a single =AI() function, needs no API key, and caches duplicates so the same input isn’t billed twice.

There is no pricing page: numerous.ai/pricing redirects to the homepage, where all three cards, Personal, Pro and Enterprise, show $10 per month billed annually, link to the identical Stripe checkout, and list word-for-word identical features (verified Jul 30, 2026). The copy still says “ChatGPT” where a 2026 vendor would say “models.”

Skip it if you need a support relationship or a roadmap. At $10 a month with a seven-day trial it’s cheap enough to test this afternoon, thin enough that you shouldn’t build a process on it.

Don’t buy: Rows

Rows was good: 2.2 million people ran 17 billion spreadsheet functions through it, by its own count, and its live-data integrations were the best here. Its team now works on Coda inside Superhuman; the product it left behind is still billing (verified Aug 5, 2026).

Skip it if: no. Skip it. It’s here so you recognise the name when an AI answer recommends it, and close the tab.

What the accountants on Reddit actually say

Two threads, eleven months apart, ask this question and land in the same place.

The older one is r/vibecoding: AI Tool which works best with spreadsheets (Excel 365 & Google sheets), posted August 17, 2025 by a financial modeller and accountant. Small, and still unanswered: 20 points and 74 comments when we read it on August 5, 2026. He’d tried every mainstream model, “All available versions of GPT, Claude, Gemini, deepseek, perplexity pro etc etc,” and found that “none of them is efficient enough to tackle complex spreadsheet tasks (e.g. array formulas, multi-sheets data structure, pivot tables, Power Query, VBA, Google app script etc).”

Its most considered reply says general models “are usually not actually built into the spreadsheet you’re using, which causes issues,” and that “direct in-sheet AI isn’t quite there in Excel/Sheets yet for most complex scenarios.” Two other replies are pitches. One of them handles it properly: gptforwork.com does formulas, pivots, VBA and Apps Script but “Cannot do PowerQuery,” followed by the four words that make a comment usable, “Disclosure: I’m the founder.” The other comes from an account named after the product it’s recommending and points readers at its own profile for a signup link, with no disclosure at all. Read that thread with your guard up.

The newer one was posted on June 16, 2026, and Google files it in a Discussions box on the exact query this page targets: r/dataanalysis, What is the best AI tool for working with spreadsheets (Excel & Google Sheets)?, 50 comments and 9 points at 67% upvoted when we re-read it on August 6, 2026. Weight it accordingly: this is a lightly-voted thread whose worth is in three or four specific replies, not in a crowd verdict. A small-business owner doing his own books reports that ChatGPT and Claude aren’t “as good as advertised for intensive Excel work,” and names the same failure points: embedded models, complex sheet structure, pivot tables. He later edited the post to say he settled on Powerdrill and Julius AI, two tools this page doesn’t cover — worth knowing before you take the thread as a vote for anything.

Its top comment, at 13 points, defends our own first pick and attaches a technique: “I don’t think you can get any better than Claude for excel,” provided you first hand it a markdown file describing the workbook, because doing that means “you are removing a huge chunk of the ‘thinking’ it has to do.” The room is harder on everything else. One analyst calls Gemini in Google Sheets “utter trash” and now has Gemini CLI write Python that produces the Excel file instead. Copilot draws the thread’s only straight fight: “Copilot is fantastic” against the poster’s “my experience with copilot is that it’s much more prone to error than other tools.”

There’s a second technique worth stealing, buried three points down where nobody will find it: stop letting the model touch the formatted sheet. “Export the raw data to CSV and let the AI work on that with code, then keep the formatting and pivot tables as a separate presentation layer.” The poster’s answer to whether that breaks on formatted tables — “yeah, all the time” — is why the same commenter adds an intermediate cleaning tab and pulls data as close to the source as possible. Unglamorous, and it works today with tools you already pay for.

One more thing the thread does better than the SERP above it. A Querri employee turned up to recommend Querri and opened with “Small disclosure: I’m part of the Querri team,” then spent most of the comment explaining which half of the problem their product doesn’t solve. Four vendors on the review-intent SERP put themselves in their own rankings without saying a word. The Reddit thread has better disclosure hygiene than Google’s first page.

The buying rule comes from a commenter the poster immediately endorsed. The tools that survive a complex workbook “have an actual execution environment,” so they “can run the formulas and check the outputs instead of just predicting what the formula should be.” That is the category in one sentence. A spreadsheet is the one place AI can’t be approximately right, so pay for the machinery that checks its own work: code you can open, or a citation that points at the cell. If the thing you’re actually missing is the analysis rather than the assistant, no add-in closes that gap — start with AI for business operations instead.

FAQ

Can I use AI to make spreadsheets?

Yes. Copilot in Excel and Gemini in Google Sheets build tables, formulas and charts inside the app you already use, and Formula Bot and Quadratic generate a sheet from a prompt or a PDF. Check every formula: none is reliable enough to skip review.

Is there a free AI for Excel?

Sourcetable’s free plan includes 50 AI credits a month, the most generous here (verified Aug 6, 2026). Formula Bot’s free tier writes formulas, VBA and PDF-to-Excel conversions, Quadratic and Grist both have free plans, and Shortcut gives 20 credits a week. Copilot in Excel is not free: it needs the $21 add-on.

Which is the best AI tool for spreadsheets?

Claude for Excel for financial modelling, because its answers cite specific cells and it preserves formula dependencies when it edits. Microsoft 365 Copilot if you already pay Microsoft, Shortcut if you need an agent inside your existing files, Gemini if you’re on Workspace Business Standard or above, Quadratic or Sourcetable if your analysis outgrew formulas.

How much does an AI spreadsheet tool cost?

Between $0 and $149 per user per month. Grist, Sourcetable, Quadratic, Formula Bot and Shortcut all have free tiers. The mid-market runs $8 to $29: Grist Pro $8, Numerous.ai $10, Claude Pro $17, Quadratic Pro $18, Copilot Business $21, Sourcetable Pro $29. The ceiling is Shortcut Pro and Sourcetable Max at $100, Formula Bot Enterprise $149 (verified Aug 6, 2026).

What is the best AI spreadsheet generator?

Formula Bot and Grist both turn a plain-English prompt into a working file, and Quadratic will build one in-app. Treat the output as a first draft — the structure is usually right and every formula still needs auditing before anyone makes a decision on it.

Does any AI handle Power Query, VBA and macros?

Not well, as of July 2026. Anthropic lists data tables, macros and VBA as unsupported in Claude for Excel, and the founder of GPT for Work says his add-in cannot do Power Query. Formula Bot writes VBA as text but doesn’t run inside your file.

Changelog

• 2026-08-06 — Editorial QA of the ten-tool page. A second pair of hands re-checked the hook and it held for the fourth time: rows.com/pricing still sells Plus at $8 and Pro at $79 + $8 under the Superhuman banner, sixty-seven days past the wind-down date its own founders published. Grist, Shortcut and Sourcetable were re-priced against their own pages and every figure matched, including the one most likely to be wrong — Grist’s free AI allowance really is 100 credits for the lifetime of the account, not per month. The review-intent SERP was pulled again and the section built on it was rewritten to what came back: seven of the top ten results are companies with something to sell, four of them award themselves a place in their own ranking, and Google’s answer box on the query is lifted from a vendor’s blog. One claim about that page’s AI Overview could not be reproduced and was cut rather than left standing. Both Reddit threads were re-read line by line, which turned up four vote counts read off the wrong column and two quotes that had drifted a word from what the commenter actually typed; all six are fixed. The r/dataanalysis poster’s own edit — he settled on two tools this page doesn’t cover — is now in the piece, because leaving it out made the thread look more like a vote for our top pick than it is.
• 2026-08-06 — Expansion pass. Three tools added after a fresh keyword and SERP sweep found real demand the page wasn’t serving: Shortcut (an agent that runs as an Excel and Sheets plugin — “shortcut ai for excel” alone draws 390 US searches a month), Sourcetable (the most generous free AI tier here that isn’t open source) and Grist (free, open-source, self-hostable). Every price on the page was re-read on the vendor’s own site the same day; nothing moved. Rows re-confirmed live for the third time, still selling under the Superhuman banner, with a new detail — its privacy-policy link now resolves to grammarly.com. A second SERP was captured on “best ai for excel spreadsheets 2026”, the review-intent query, and it produced the other half of this page’s argument: four of the top seven results are AI vendors ranking their own listicles, three of them placing themselves inside their own rankings. The r/dataanalysis thread’s exact post date was pinned at last (June 16, 2026) along with its real score, 7 points at 63% upvoted, and the page now says plainly that it’s a lightly-voted thread. Two additions from it: the CSV-and-presentation-layer technique, and a vendor employee who disclosed their affiliation before pitching — better hygiene than Google’s first page manages. Keyword block resolved: the overview quota that ran out on July 30 recovered, and it shows the suggestions endpoint had understated difficulty badly (“best ai for excel” is SD 48, not 24; “ai tools for excel” is SD 37, not 20). Primary keyword unchanged, though its own difficulty drifted from SD 32 to SD 39 in a week.
• 2026-08-05 — Editorial QA. The page’s central claim was re-checked by a second pair of hands and it survived: rows.com/pricing was fetched independently and still sells Plus and Pro under the Superhuman banner, and an independent US pull of Google’s AI Overview still names Rows AI, with Rows absent from the organic results in the same pull. Quadratic’s prices re-confirmed to the cent. Both Reddit figures were corrected downward to what the thread showed on the day (20 points, 74 comments, not 21 and 73), one quote was restored to its exact wording, and a second thread was added: an r/dataanalysis discussion Google itself files under “ai spreadsheet”, where the top comment defends Claude for Excel, an analyst calls Gemini in Sheets “utter trash”, and the sharpest buying rule on this page gets stated by someone who does the work. Gemini’s anti-pick now carries that verdict. Its 7.5 score does not move on one user report; that call is left to a human.
• 2026-08-05 — Re-verification pass. The contradiction holds: rows.com/pricing still sells Plus and Pro under the Superhuman banner, and Google’s AI Overview still names Rows AI. Both had shifted, though. The AI Overview restructured its list, so that section was rewritten to match it; and Rows has now dropped out of the organic top eight while staying AI-Overview-cited, which sharpens the point. Quadratic re-confirmed unchanged. Claude, Numerous.ai and Formula Bot served nav-and-footer only this time, so their prices stay stamped July 30 rather than re-dated. Google Workspace USD pricing retried through a US residential proxy: the page ships no prices in its HTML, so it stays flagged rather than filled.
• 2026-07-30 — Page created. Every price read live on the vendor’s own page; the one figure we couldn’t verify (Google serves geo-localised Workspace pricing) is flagged, not filled. Confirmed that Rows’ own blog set a full wind-down for May 31, 2026 while its pricing page still sells plans two months later, and that Google’s AI Overview still recommends it. SERP state recorded for “ai spreadsheet”: ten AI Overview references, six of them vendor pages, and seven vendor pages in the organic top eight, with no independent ranked comparison anywhere. Primary keyword set from scratch: “ai spreadsheet”, 590/mo, SD 32, $19.51 CPC.

---

Independent, no paid placements. We verify every price on the vendor’s own site and stamp the date, we publish who should skip each tool, and we keep this changelog public. See how we score AI tools and our independence charter. More categories on the AI tools index, every verified price on the pricing index. Related: AI coding assistants, AI accounting software, AI tools for accountants.