Can you use AI to make Excel spreadsheets?

Short answer: how you get the sheet depends on your plan and where you use ChatGPT, and checking it is always your job. OpenAI’s help pages describe two ways for ChatGPT to make the spreadsheet itself. An ordinary chat can still give you formulas and a layout to enter by hand.

What ChatGPT can actually produce

OpenAI describes ChatGPT Work as able to create or edit documents, spreadsheets, presentations, reports and analyses. You describe the file, attach any source material, and name the output format and where it should be created. Availability depends on your plan, workspace settings, file type and surface, and the help page does not say which plans include it.

The second route is ChatGPT for Excel, an add-in that sits in a sidebar inside Excel. OpenAI says it can create spreadsheets from scratch, explain existing ones and update them from plain-language requests. It lists the add-in for Free, Go, Plus, Pro, Business, Enterprise, Edu and K-12 users, with limited usage on Free and Go. There is a matching add-in for Google Sheets.

ChatGPT can also read spreadsheets you upload. OpenAI’s uploads page lists XLSX, XLS, CSV and TSV, says spreadsheet uploads work on Free and paid plans, and puts the limit for spreadsheets and CSV files at approximately 50 MB, depending on the size of each row. For calculations it may write and run Python, and OpenAI asks you to review that code, its outputs and its assumptions before relying on the result.

Three ways to get a spreadsheet out of ChatGPT

Ask ChatGPT Work for a file. This is the route to take when you want a finished workbook to open. OpenAI’s own advice is to name the sheets, columns, formulas and charts that matter, and, if you attach an existing file, to say what must stay unchanged.

Build it inside Excel with the add-in. In Excel, go to Home, then Add-ins, search for ChatGPT, add it and sign in. Changes land in the workbook you have open, which suits a sheet you already use. For important work OpenAI suggests duplicating the file first so you can go back. It also warns that VBA and macros may not be fully supported.

Ask for formulas or a layout in an ordinary chat. Describe your columns and the calculation you need, and ask for the formula and the cell it goes in. Then type it into your own sheet. It’s slower, it needs no file feature, and you see every formula as you enter it.

How to do it well

Be specific, annoyingly so. Say what each column is for, what each row represents and what you want totalled. “Make me a budget” gets you something generic. “A monthly budget with income at the top, a column each for rent, food and travel, and a total row” gets you something you can use.

If you’re giving it data, tidy it first. OpenAI recommends descriptive column headers in the first row, one row per record and plain-language column names. It also says to avoid putting several unrelated tables on one sheet, or empty rows and columns that split the data up. A PDF is a weaker starting point: OpenAI says ChatGPT may not reliably pull exact values from scanned files or image-based tables, so use a text-based file where you can. Summarising a PDF covers the reading side.

Where you have no figures, tell it to leave the cells blank. OpenAI’s own page on accuracy says ChatGPT can produce incorrect or misleading answers and can sound confident when it’s wrong. A made-up figure sitting in a tidy sheet looks exactly like a real one.

For big edits, ask for a plan first. OpenAI’s Excel guidance suggests asking which tabs and ranges it will change before it touches anything.

Then check, because OpenAI says outputs from the Excel add-in may be incomplete or incorrect and tells you to review formulas, calculations and changed cells. Three checks are worth the time:

1. Work out one or two totals by hand or with a calculator and see if the sheet agrees.
2. For a nested formula, select the cell and use Formulas, then Formula Auditing, then Evaluate Formula. Excel shows each part worked out in the order it is calculated. It checks one cell at a time, and parts that use IF or CHOOSE may show #N/A instead of a value.
3. Look up any function you don’t recognise on Microsoft Support. XLOOKUP, for example, is not available in Excel 2016 or Excel 2019, so a sheet built on it may not work for someone using an older copy.

Treat the first version as a draft, just as you would with AI-made slides.

Why the file sometimes doesn’t appear, and what to do

You ask for a file and get a description of one. These are the documented causes:

• The feature isn’t available to you. OpenAI says file creation depends on plan, workspace settings, file type and surface. Work admins also control which apps and actions are available.
• You’re looking in the wrong place. Chats in the Excel and Sheets add-ins are kept separate from your main ChatGPT history and do not sync, so a sheet you built there won’t appear in your usual chats. Files made in a Temporary Chat are not saved to Library.
• You’ve hit an upload limit. OpenAI says Free users can upload 3 files a day, and everyone else up to 80 files every 3 hours, which it may lower at peak times. Failed upload attempts can sometimes count towards that limit. OpenAI’s status page will show any outage.
• The file is too big or complicated. OpenAI says a spreadsheet can upload successfully and still be too large or complex to analyse in full, and that lots of complex formulas can affect processing. Ask it to look at specific sheets or columns, or split the file.

If none of that helps, switch to the formulas route. You’ll have a working sheet with a bit more typing.

Rules and risks

The biggest UK risk is personal data. If your sheet holds names, contact details, client records or anything else that identifies a real person, UK GDPR applies to it wherever it goes. The ICO’s guidance on AI and data protection is written for organisations using AI with personal data, and the ICO says it is under review after the Data (Use and Access) Act. If the data comes from work, check your employer’s rules before you upload anything.

The safest habit is to upload less. Replace names with labels, delete columns you don’t need, or build the structure with dummy figures and put the real ones in yourself afterwards. You still get the layout and the formulas.

On training, OpenAI says that with Improve the model for everyone turned off, new conversations are not used to train its models. Temporary chats are not used for training but may be kept for up to 30 days for safety purposes. Business, Enterprise and Edu workspace content is not used for training by default. Two catches: giving a thumbs up or thumbs down can make the whole conversation available for training even after you opt out, and deleting a chat does not delete a copy of the file saved in Library. For who else can see what you share, read who can see my ChatGPT conversations.

If the sheet feeds into accounts or a tax return, a wrong total has real consequences. OpenAI itself says ChatGPT is not a financial, legal or tax adviser. Read using AI for bookkeeping and using AI for your taxes before you rely on it for either.

This is general information, not legal or financial advice.