ChatGPT for Excel: How to Analyze Business Data
Yes. ChatGPT for Excel works inside Microsoft Excel. There is an official ChatGPT add-in for both Excel and Google Sheets that sits in a sidebar in your workbook, so you can ask for changes in plain language and see the result in the sheet. You can also just upload an Excel or CSV file into ChatGPT on the web and ask questions about it. Both work, and which one you pick depends on whether your work lives inside the spreadsheet or not.
This is handy for the sort of sheet every small business keeps: a sales log, a list of leads, a stock sheet. This post shows you how to set it up, a worked example on a messy monthly sales sheet with the exact prompts, how to check the answers before you trust them, what the free and paid plans allow, and what you must never paste into it.
Key takeaways
ChatGPT works in Excel two ways: the official add-in inside the sheet, or uploading a file to ChatGPT on the web.
Best uses: cleaning a messy sheet, summarizing sales, and building a quick chart.
Always check the numbers: verify two figures by hand and ask it to show its working before you act.
Protect data: strip customer names, payment details and ID numbers before you upload.
Can ChatGPT work inside Excel?
Two ways, and they are different.
Inside the sheet (the add-in). ChatGPT for Excel and Google Sheets is an official add-in. It opens as a sidebar in your workbook. You type what you want in plain words, it edits the sheet, and it explains what it changed. It links its answers to the cells it used and asks before making changes, so you can check each step.
On the web (upload a file). You open ChatGPT in your browser, upload a CSV or Excel file, and ask questions. ChatGPT reads the file and answers, builds simple charts, and writes summaries you can paste elsewhere. Nothing is installed.
Use the add-in when you live in Excel or Sheets all day. Use the upload method when you just want a quick read of one file and do not want to install anything.
How to add ChatGPT to Excel or Google Sheets
For Excel: open your workbook, go to Home, then Add-ins, search for ChatGPT, and add it. You then see ChatGPT in the ribbon above your workbook. Open it and sign in with the OpenAI account that has your plan.
For Google Sheets: open a sheet, go to Extensions, then Add-ons, then Get add-ons, search for ChatGPT, install it, open it, and sign in.
OpenAI says the Excel and Google Sheets add-in is available globally, including for Free, Go, Plus, Pro, Business and Enterprise users, so an Indian user on any plan can install it.
Upload a file or use the add-in: which to pick
A simple way to decide:
Pick the add-in if you edit the same workbook often, want ChatGPT to change cells for you, and care about keeping your formulas and formatting intact. It previews changes and lets you revert.
Pick file upload if you have a one-off question about a file, want a quick summary or chart, and do not need ChatGPT to edit the original. It is faster to start and installs nothing.
For most shop owners doing a monthly review, file upload is the easier entry point. For a bookkeeper or anyone maintaining a live model, the add-in saves more time.
Clean a messy sales sheet in three prompts
Say you keep a monthly sales sheet with 12 rows, one per product, and the usual mess: a few duplicate rows, "Mumbai" spelled three ways, blank cells, and amounts stored as text. Here is how to clean it.
Prompt 1, clean up. "Clean this sheet. Remove duplicate rows, standardize the city names to one spelling each, fix amounts that are stored as text so they are numbers, and tell me exactly what you changed."
Prompt 2, summarize. "Summarize this sales data. Give me total sales, the top three products by revenue, the bottom three, and anything that looks unusual."
Prompt 3, chart. "Make a bar chart of revenue by product, highest to lowest, with the product names and rupee values labelled."
OpenAI's own guidance is to start with the decision you are trying to make, give the context (what the columns mean, the time period), and ask for an approach rather than just a number. A good frame is "I am trying to decide what to restock next month, based on this sales sheet." That keeps the answer focused on your decision.
Find what sold and what did not
Once the sheet is clean, the useful questions are about action, not totals.
Ask: "Which products are falling month on month?" "Which three products make most of my revenue?" "Which products sell well but have thin margin?" if your sheet has a cost column.
You can also ask it to compare two months. Upload both, then: "Compare October and September. Which products grew, which fell, and by how much in rupees and percent?" For more ways AI earns its place in a small business, see AI for business in India.
The point is not a prettier table. It is a shortlist of three decisions you can act on this week: restock these, stop stocking those, push this one in your next WhatsApp offer. If you want ChatGPT to also draft that offer or other business text, my ChatGPT prompts for business post has ready templates, and there are more no-cost options in my roundup of free AI tools for Indian small businesses.
Check the numbers before you trust them
ChatGPT can get numbers wrong, so never act on a figure you have not spot-checked. Here is a five-point routine worth running every time.
1. Pick two numbers and verify them by hand. Add one column yourself. If the total matches, good. If not, stop.
2. Ask it to show its working. "Show the formula or the steps you used to get that total." OpenAI's guidance suggests exactly this: ask it to show assumptions and formulas.
3. Check the row count. "How many rows did you use?" If it used 10 rows and your sheet has 12, it missed data.
4. Watch for invented rows. If a summary mentions a product that is not in your sheet, discard the whole answer and start again.
5. Tell it the rules. OpenAI recommends setting ground rules: do not treat a correlation as a cause, flag missing data, and point out anything that looks off.
Do this and ChatGPT becomes a fast first-pass analyst. Skip it and you risk making a stock decision on a made-up number.
What the free and paid plans allow
The add-in itself is available on every plan, Free included. What changes with the plan is how much you can do. OpenAI's help page states that Free and Go include limited usage access, while Plus and Pro include access subject to the plan's usage limit. So heavier use sits on the paid plans.
Two real limits from OpenAI to know: you can upload up to 20 files per message and each file can be up to 25 MB. For very large workbooks, some data may not fit in one go and you will get partial results, so split a huge file into smaller sheets.
Also, some advanced Excel features are not supported by the add-in yet, including macros and VBA. OpenAI says to review every output before you rely on it, so use the add-in for cleaning, summarizing and first-pass analysis, not for running your macros.
What not to paste into ChatGPT
One habit protects your business here, and it is easy to forget.
Do not paste customer personal data you would not want leaving your office: full names with phone numbers and addresses, payment card details, Aadhaar or PAN numbers, passwords. Strip or mask those columns before you upload.
Treat it as you would any outside tool. If a column is sensitive and you do not strictly need it for the analysis, delete it from the copy you upload. You can analyze "sales by city" without the customers' names attached.
FAQ
Can ChatGPT read an Excel file?
Yes. You can upload an Excel or CSV file into ChatGPT on the web, or use the official ChatGPT add-in inside Excel. Both let it read and analyze the data.
Is ChatGPT for Excel free?
The add-in is available on all plans including Free. OpenAI says Free and Go include limited usage access, so heavier use needs a paid plan like Plus or Pro.
How do I install ChatGPT in Excel?
Open Excel, go to Home, then Add-ins, search for ChatGPT, add it, then sign in with your OpenAI account. The Google Sheets add-on installs from Extensions, Add-ons, Get add-ons.
Can ChatGPT make charts from my data?
Yes. Ask it to chart a column, name the chart type, and tell it to label the axes and values. On the web it draws the chart; in the add-in it builds it in the sheet.
Is it safe to upload business data?
Upload only what you need, and strip sensitive columns like customer phone numbers, payment details and ID numbers first. Analyze patterns without attaching personal data.
Does it work with Google Sheets too?
Yes. The same ChatGPT add-in works in Google Sheets, installed from the Google Workspace Marketplace, and is available globally.
If you want help turning your sales or lead sheet into a monthly review you actually use, you can book a consultation and we will set it up on your own data.
Comments