The best free AI tool for Excel in 2026 is ChatGPT. Its free plan lets you upload a spreadsheet (up to about 50 MB, 3 file uploads a day), ask questions about it in plain English, and get formulas, charts and cleaned data back. If you want an AI that works inside your workbook, the ChatGPT for Excel add-in became available on all plans in May 2026. For quick formulas and VBA without uploading your data, GPTExcel’s free tier is the fastest option.

Below is the full ranking, what each free plan really includes (checked on the official pages on 16 November 2026), and the honest answer to a question many people get wrong: is Microsoft Copilot in Excel free? (Short answer: no, not on the free web version.)

How we ranked these free AI Excel tools

We only counted what you can do without paying. Each tool was scored on four things:

Quick comparison: best free AI tools for Excel (2026)

Rank Tool Best for Free plan Cheapest paid plan
1 ChatGPT (+ ChatGPT for Excel) Analysing whole spreadsheets, formulas, charts 3 file uploads/day, spreadsheets ~50 MB, data analysis with limits Go, $8/month (US)
2 Claude Explaining complex formulas and messy workbooks Upload .xlsx (500 MB/file) with code execution on; usage limits not published Pro, $17/month billed yearly
3 GPTExcel Formula, VBA, SQL and regex generators 50 credits/month + 5 free tool runs a day, files up to 5 MB Pro, $9/month
4 Better Analyst (formerly Formula Bot) Dashboards and analysis from a data source 10 chat messages + 100 AI credits/month, 1 data source Pro, $20/month billed yearly
5 Excel’s built-in Flash Fill Splitting, joining and reformatting columns offline Free in Excel 2016–2024 and Microsoft 365 None needed

1. ChatGPT: the best free AI for Excel overall

ChatGPT is the most capable free option because it can actually read your file. On the free tier you can upload a spreadsheet and ask things like “Which region had the biggest drop in sales from Q2 to Q3?” or “Remove duplicate customers and give me a clean file back.” OpenAI’s help centre lists the free limits: 3 file uploads per day for free users, with spreadsheets capped at about 50 MB. File uploads and data analysis have their own usage limits on the free tier, so a long session can run out.

The bigger news for Excel users is the ChatGPT for Excel add-in. It launched in beta for paid plans in March 2026 and, according to OpenAI, became generally available across all plans on 5 May 2026. It works inside the workbook: it builds and updates models, cites the cells it used, and traces and fixes errors, and it asks permission before it edits anything. OpenAI does not publish separate free-plan caps for the add-in, so expect it to share your normal free limits.

How to analyse an Excel file with ChatGPT for free

  1. Remove anything private (names, emails, IDs) or replace it with sample values.
  2. Open ChatGPT, click the + button and upload your .xlsx or .csv file.
  3. Describe the result you want, not the method: “Make a monthly sales summary by product with a bar chart.”
  4. Ask for the Excel formula too: “Give me the formula I can paste into column F to do this myself.”
  5. Download the cleaned file or chart, and spot-check 3–4 numbers against the original.

Pros: reads real files, explains its steps, creates charts and new files, add-in now open to all plans.
Cons: only 3 uploads a day free; you are uploading your data to a cloud service; limits are not published in exact numbers.

If you like ChatGPT but want to compare other free chatbots, see our ranking of the best free ChatGPT alternatives.

2. Claude: best for explaining complicated formulas

Claude is excellent at the part of Excel most people dread: understanding a workbook someone else built. Paste a nested formula like =IFERROR(INDEX(B:B,MATCH(1,(A:A=H2)*(C:C="Paid"),0)),"") and it will break it down piece by piece, then suggest a cleaner XLOOKUP or FILTER version.

On the free plan, Anthropic’s pricing page includes “create and edit files with code execution”, and the help centre says you can upload files up to 500 MB, up to 20 per chat. Excel files need the code execution and file creation setting turned on. Anthropic doesn’t publish a number for free messages; you get a usage allowance that resets over time.

One thing to know: the Claude for Excel add-in (which edits pivots, conditional formatting and data validation directly in your sheet) is only available on Pro, Max, Team and Enterprise plans, not on Free. It also doesn’t support macros or VBA.

Pros: clear, patient explanations; handles big files; great at rewriting old formulas.
Cons: the in-Excel add-in is paid only; free usage limits aren’t published.

3. GPTExcel: best free AI formula and VBA generator

If you don’t want to upload your spreadsheet at all, GPTExcel is the tool to bookmark. You describe what you need (“sum column C when column A is ‘North’ and the date in B is this month”) and it returns a formula you can paste. It also has generators for VBA, Office Scripts, Google Apps Script, SQL and regex.

The GPTExcel pricing page lists the free plan as 50 credits a month plus 5 free tool runs every day (after that each run costs 1 credit), with file uploads up to 5 MB and 10 files per chat. Pro costs $9 a month for roughly 3,000 credits.

Try this prompt in GPTExcel

“Excel formula: in column D, show ‘Late’ if the due date in B is before today and column C is empty, otherwise show ‘OK’.” You should get something like =IF(AND(B2<TODAY(),C2=""),"Late","OK"). Always test a generated formula on 3–4 rows you can check by hand.

Pros: no data upload needed; 5 free runs every day; covers VBA and scripts.
Cons: it writes formulas, it doesn’t analyse a full workbook as well as ChatGPT or Claude.

4. Better Analyst (formerly Formula Bot): best for quick dashboards

Formula Bot was one of the first AI Excel tools, and it has now rebranded. Its pricing page says “Formula Bot is now Better Analyst”, with the same account. The focus has moved from single formulas to connecting a data source and asking questions, then turning the answers into an AI dashboard.

The free plan on betteranalyst.com/pricing includes 10 chat messages and 100 AI credits a month, 1 data source and 1 AI dashboard. Pro is $20 a month billed yearly ($30 month to month) with unlimited chat and 3,000 credits.

Pros: turns a spreadsheet into a shareable dashboard; familiar to old Formula Bot users.
Cons: 10 free messages a month is tight; better as a trial than a daily free tool.

5. Excel’s built-in Flash Fill: the free “AI” you already have

Before you open any chatbot, try the pattern tool that’s already in Excel. Flash Fill watches what you type and fills the rest of the column when it senses a pattern. It works in Excel 2016, 2019, 2021, 2024 and Microsoft 365, runs on your own computer and never uploads your data.

How to use Flash Fill

  1. Say column A has full names like “Sara Khan”. In B2, type just “Sara”.
  2. Move to B3 and press Ctrl + E.
  3. Excel fills every first name in the column. It works the same way for joining columns, pulling out email domains or reformatting phone numbers.

Microsoft 365 subscribers also get Analyze Data (formerly Ideas), which answers plain-English questions about a table and suggests charts and pivot tables. It’s listed as a Microsoft 365 subscriber feature, so it isn’t part of the free web version.

Pros: free, offline, private, instant.
Cons: pattern-only; it can’t write formulas or explain anything.

Is Microsoft Copilot in Excel free?

No. Excel for the web is free to use, but Copilot in Excel is not included in it. According to Microsoft’s Copilot in Excel FAQ, you need a Microsoft 365 Personal or Family subscription with an AI credits plan, a Microsoft 365 Premium subscription, a Microsoft 365 Copilot licence, or an eligible business plan. Microsoft 365 Basic has no AI features. Copilot also only works on files saved to OneDrive with AutoSave on.

Also note that the preview =COPILOT() worksheet function was retired: Microsoft says it is no longer available in Excel from 14 September 2026. If you see older tutorials using it, they won’t work any more.

If you need a free spreadsheet app instead of paying for Microsoft 365, our guide to the best free Microsoft Office alternatives compares the options.

What about Gemini in Google Sheets?

Gemini inside Google Sheets (formula help, the =AI() function, “Help me organize”) needs an eligible Google Workspace plan or a Google AI Pro or Ultra subscription; it isn’t part of a free personal Google account. The free Gemini app can take uploaded files (up to 100 MB, 10 per prompt) and make charts from a spreadsheet, so it’s a reasonable backup if you’ve used your 3 daily ChatGPT uploads.

Tips to get better results from any AI Excel tool

Students who use spreadsheets for assignments can pair these with the tools in our list of the best free AI tools for students, and if your numbers end up in a pitch, see the best free AI presentation makers.

FAQ: free AI tools for Excel

Can ChatGPT analyse Excel files for free?

Yes. Free users can upload spreadsheets and ask ChatGPT to analyse them. The limits are 3 file uploads per day and roughly 50 MB per spreadsheet, and data analysis has its own usage limit on the free tier.

Is there a free AI that writes Excel formulas?

Yes. GPTExcel gives you 5 free tool runs a day plus 50 credits a month, and ChatGPT and Claude will both write and explain formulas on their free plans if you describe your columns clearly.

Is Copilot in Excel free?

No. Copilot in Excel needs Microsoft 365 Personal or Family with an AI credits plan, Microsoft 365 Premium, or an eligible business plan. The free Excel for the web doesn’t include it.

What happened to the =COPILOT() function?

Microsoft retired it. The preview function is no longer available in Excel from 14 September 2026.

Can Claude read Excel files on the free plan?

Yes, you can upload .xlsx files once code execution and file creation are turned on. The Claude for Excel add-in that works inside your workbook needs a Pro plan or higher.

Is it safe to upload my spreadsheet to an AI tool?

Treat it like sending the file to an outside company. Remove or mask personal and financial data first, check your employer’s policy, and use offline tools such as Flash Fill for anything confidential.

Conclusion

For most people, the best free AI tool for Excel is ChatGPT: upload the file, ask in plain English, and get formulas and charts back. Use Claude when you need a slow, clear explanation of someone else’s workbook, GPTExcel when you only need a formula or VBA snippet, and Flash Fill whenever the job is just reformatting a column. Skip paid Copilot until the free tools stop being enough.

Want your business website and content to show up when people search for tools like these? Get a free SEO audit from SSA Agency and we’ll show you what to fix first.

Leave a Reply

Your email address will not be published. Required fields are marked *