AI for Excel and spreadsheets: formulas, analysis and checks
AI for Excel writes formulas from a description, explains other people’s formulas, cleans data, builds pivot tables and charts, and writes macros. Its weak spot is the calculation itself: the vendors, Yandex, Microsoft and Anthropic, explicitly ask you not to trust AI with calculations without checking. Below: what built-in assistants and chats can do, how to set the task so the formula works in Russian-language Excel, and how to check the result. Word, PDFs and scans have a separate article.
We build a personal AI assistant in Telegram, MAX and the browser, and it builds spreadsheets too. More about it at the end.
What AI can do in spreadsheets
| Sample task | |
|---|---|
| Formula from a description | “Total sales for each manager for September” |
| Explain a formula | “What does this formula do and why does it return an error?” |
| Data cleanup | “Find duplicates in the INN column, don’t delete anything, list the rows” |
| Pivot table and chart | “Pivot by region and month, with a line chart next to it” |
| Analysis | “Calculate it with code and show the code: which three regions brought in 80% of revenue?” |
| Macro or script | “A VBA macro: split rows into sheets by the Branch column” |
| Table from a photo or PDF | “Copy the table from the photo and highlight numbers you’re unsure of” |
| Finished file | “Build an Excel file: an order tracking template with total formulas” |
Where AI makes mistakes in spreadsheets
The main problem is arithmetic. The vendors say so themselves:
- Yandex, in the Yandex Tables help: “Do not use AI functions for mathematical calculations.”
- Microsoft, in its FAQ about Copilot in Excel, advises against relying on it for decisions in sensitive areas such as finance.
- Anthropic does not recommend its Claude for Excel add-in for audit-critical calculations without checking.
Hence the rule: ask not for a number but for a formula or a calculation in code. Excel itself will recalculate a formula, and code can be read and rerun. ChatGPT and Claude analyze spreadsheets with Python code, so ask them to show that code and their assumptions.
On typical questions the best models have almost caught up with experts; on complex financial models, not yet. You can see this in the SpreadsheetBench test: 912 real questions from Excel forums. In 2024 the best model solved about 18% of the tasks and experts 71%; by October 2026 the best result was 70%. In the second version of the test, with financial models (June 2026), the best model solves 35% of the tasks. The more critical the spreadsheet, the stricter the check.
Where else data gets lost:
- Large files. Google says Gemini may miss connections and details in large files. OpenAI says complex formulas also slow processing down, even when the file is within the limit.
- Several tables on one sheet and blank separator rows. OpenAI advises: headers in the first row, one row per record.
- Merged cells and hidden rows. Our advice: unmerge cells and unhide everything before uploading.
- Tables in photos and scans. OpenAI warns that ChatGPT may not extract exact values from table images reliably.
Built-in assistants: Excel, Google Sheets, Yandex Tables
What the assistants inside spreadsheet apps can do, according to their help pages as of October 20, 2026:
| What it does | What to keep in mind | |
|---|---|---|
| Copilot in Excel | Formulas across several sheets, pivot tables, charts, conditional formatting | Included in Microsoft 365 subscriptions; the number of AI requests depends on the plan. The =COPILOT() function was retired as of September 14, 2026 |
| Gemini in Google Sheets | Tables, formulas, pivot tables, charts and insights in the side panel; the =AI() function in a cell | Requires a Google AI or Workspace plan. =AI() processes up to 350 cells at a time |
| Yandex Tables | The =ИИ function (Russian for “AI”): categorize, extract data, fix errors, suggest a formula | Without a plan, 50 requests a month. The help pages do not mention pivot tables or charts via AI |
| ONLYOFFICE | The =AI() function, an AI agent: pivot tables, filters, charts | The plugin is free; you connect your own model. Since version 10.0 it is installed separately |
| MyOffice | Pivot tables, sorting, charts on request | For organizations |
An example from the Yandex help: =ИИ("Determine the purchase category: Groceries, Cafés, Transport, Utilities or Other?"; A2). Functions like this are good for text in cells: categories, sentiment, summaries. You cannot use them to calculate totals: Yandex asks you not to use them for calculations and not to combine them with other functions in one formula.
Chats and add-ins: which accept an Excel file and return a finished one
| Accepts | Returns | |
|---|---|---|
| ChatGPT | XLSX, XLS, CSV up to ~50 MB; on the free plan, 3 uploads a day | In analysis, a CSV table and charts as images; a finished XLSX, according to OpenAI’s help, in ChatGPT Work |
| Claude | XLSX and CSV | A finished XLSX with working formulas, including on the free plan |
| Gemini | Up to 10 files of 100 MB each | A table from the answer, exported to Google Sheets |
| Alice AI | Does not accept XLSX in chat; only DOC, DOCX, PDF, TXT | Text in the chat |
| GigaChat | Does not accept XLSX or CSV in the web chat; only documents (TXT, PDF, DOCX) | Text in the chat |
You can give a spreadsheet to a service that does not accept XLSX as text or a screenshot. For calculations this is worse: numbers from an image are recognized with errors.
If you want AI to work right inside the workbook, there are add-ins, the so-called “AI agents for Excel”:
- ChatGPT for Excel and Google Sheets is a panel inside the spreadsheet, available on the free plan as well. OpenAI advises making a copy of the file before you start and warns that VBA macros are only partly supported.
- Claude for Excel changes input values while keeping formulas linked, and cites cells. Paid plans only; it does not support macros.
- Copilot Agent Mode: Copilot carries out a multi-step task in the workbook on its own.
- Stand-alone formula generators: many do not say who owns them or which model they use. Before uploading work data there, find out whose service it is.
How to set the task: Russian-language Excel
AI models often answer with a formula in English and with commas between arguments. In Russian-language Excel the functions have Russian names and the separator is usually a semicolon, so such a formula returns an error.
- VLOOKUP is ВПР, XLOOKUP is ПРОСМОТРX (the last letter is a Latin X), SUMIF is СУММЕСЛИ, SUMIFS is СУММЕСЛИМН.
- The argument separator depends on the regional settings in Windows; in Microsoft’s Russian examples it is a semicolon: =ВПР("Иванов";B2:E7;2;ЛОЖЬ), which in English Excel is =VLOOKUP("Ivanov",B2:E7,2,FALSE).
- Decimals use a comma: 1,2 rather than 1.2.
Microsoft advises naming the columns and ranges to work with; OpenAI, the sheets, columns and formulas you need. A full sample task:
“I use Excel 365 in Russian, so write function names in Russian, with a semicolon as the separator. The ‘Sales’ sheet: A is the date, B the manager, C the region, D the amount in rubles; headers are in the first row, data goes down to row 1,250. On the ‘Totals’ sheet I need total sales for each manager for September 2026. Give one formula for cell B2 that I can drag down, and explain it in two sentences. Do not change the source data. If any dates are stored as text, tell me which rows.”
For a macro, add the version and the system: “Excel 365 on Windows, code comments in Russian, first tell me what the macro will change.” Run it on a copy of the file. VBA macros do not work in Excel for the web, and Google Sheets uses Apps Script instead.
A general five-part task template is in the article AI assistant for work.
How to check a formula and a conclusion
Make a copy of the file before any AI edits.
A formula or code, not a number. Do not accept a number from a chat without the calculation.
Check three to five rows by hand: the first, the last and one from the middle.
Edge cases: empty cells, zeros, text instead of a number, dates stored as text.
Control totals: the pivot table total equals the SUM of the source column, and the row count before and after cleanup matches (COUNTA).
Drag the formula down and see whether the range has shifted: where $ signs are needed and where they are not.
Do not hide errors with IFERROR until the formula has been checked.
Ask the AI to show its steps: which rows it took and what it left out.
The point about dates is not a trifle. In 2016, researchers found gene names that Excel had turned into dates in one in five papers with attached gene lists, 704 out of 3,597: for example, SEPT2 became “2-Sep.” Excel still turns anything that looks like a date into a date, so check this too after AI edits.
What data not to upload
Spreadsheets almost always contain personal data: a CRM export, a staff list, a payroll sheet, a client database with phone numbers. Before uploading:
- replace full names with “Client 001” and remove people’s phone numbers, emails, passport details and INN taxpayer numbers; keep the lookup table on your side;
- remember that removing names is not the same as anonymizing: a person can be recognized by a combination of city, job title and amount;
- in a bank statement, keep the date, amount and category: payment descriptions can contain full names and counterparties’ account numbers;
- share a copy of the sheet you need, not the whole workbook: hidden sheets and columns go along with the file;
- prices, margins and the client database may be trade secrets of your company or your client.
Accountants’ tasks, such as reconciliations, tax office requests, and 2026 deadlines and rates, are covered in the article AI for accountants.
Which documents should never be uploaded: see the article AI for documents; where to turn off training on your data: see the article AI assistant for work.
Spreadsheets in Telegram: a personal assistant
A built-in assistant is handy when you are already in Excel. If you prefer to type a task on your phone and need spreadsheets every week, an assistant that remembers your templates helps.
We build a personal AI assistant in Telegram, MAX and the browser. Send it an Excel file, a photo of a table or a voice message: “put together the weekly sales report, like last time.” It sends back finished spreadsheets as files and works with Google Sheets and Google Docs. It accepts files up to 20 MB, a Telegram limit. Say “remember: Russian function names, semicolon as the separator,” and the rule stays.
Answers come from Claude, an AI model by Anthropic; voice messages are transcribed and images are drawn by OpenAI. Model training on your conversations is turned off, but the rules from the section on data apply here too. It can make mistakes as well, so check the numbers with the checklist above. The assistant does not transfer or pay money, and it never writes to your clients on its own: it prepares the text, and you send it.
The price is 5,000 ₽ (about $62) a month, paid monthly in rubles, with no long-term contract. Our trial bot in Telegram will do your first task for free, right in the chat. If this is your first subscription and you change your mind within the first month, we will refund the full payment, no questions asked. Full terms are on the home page.
Sources
- Accuracy and errors: Yandex Tables, AI functions (in Russian), Copilot in Excel FAQ, Claude for Excel, SpreadsheetBench, ChatGPT, data analysis, Gemini, files, genes and Excel, 2016.
- Built-in assistants: Copilot in Excel, retirement of the COPILOT function, Copilot tips, Gemini in Sheets, the AI function in Google Sheets, ONLYOFFICE, MyOffice (in Russian).
- Chats and add-ins: ChatGPT, file uploads, ChatGPT for Excel and Google Sheets, Claude, creating files, Alice AI, files (in Russian), GigaChat FAQ (in Russian).
- Russian-language Excel: functions by category (in Russian), separators in formulas, macros in Excel for the web. Data: Federal Law No. 152-FZ (in Russian).
- All links checked on October 20, 2026. Service names are trademarks of their owners. We are not partners or representatives of these companies: we use Anthropic and OpenAI models as a regular customer and mention the names only to describe the services. Summaries of laws are as of the article date and are not legal advice.