Copilot vs ChatGPT for Formatting Excel Sheets
By Mark Fulton · 2026-10-06 · 11 min read
Copilot in Excel works inside the workbook you have open, applying formatting with Excel's own features, but it needs the file saved to OneDrive with AutoSave on and a qualifying Microsoft 365 license. ChatGPT now works two ways: as a sidebar add-in inside Excel, and as a chat where you upload an .xlsx or .csv and ask about it. Either assistant can format a sheet, and either can also change things you didn't ask it to touch, so the useful question isn't which one is smarter. It's which one fits where your file lives, and what you have to check afterwards.
Most comparisons still treat ChatGPT as a browser tab where you upload a file and copy the answer back. That is no longer the whole picture, because ChatGPT now has its own Excel add-in. So when someone asks "can ChatGPT format an Excel spreadsheet?", the honest answer depends on which ChatGPT they mean.
This post sticks to formatting: number formats, fills, borders, column widths, conditional rules, the things that decide whether the person reading your sheet trusts it. It skips formula-writing contests, which are a different job.
How do Copilot and ChatGPT touch your file differently?
There are three routes, and they behave differently enough that it's worth separating them.
Copilot in Excel runs in a side pane inside the open workbook. Microsoft's own help page says it has three modes: edit, plan and chat. In edit mode it changes the workbook directly. In plan mode it writes out a step-by-step approach for you to confirm before anything changes. In chat mode it answers questions without touching the file. Microsoft describes the formatting it can apply as conditional formatting, data validation, borders and styles, and says it uses Excel's built-in features so your content stays editable. You can read the details on Microsoft's Copilot in Excel overview.
ChatGPT for Excel is a separate route. OpenAI's help center describes it as a sidebar inside Excel (and Google Sheets) that can build, update and explain spreadsheets, and it lists "cleaning up messy sheets, including formatting, labels, duplicates, and broken formulas" among its uses. Like Copilot, it edits the workbook you have open.
ChatGPT with an uploaded file is the older route. OpenAI's data analysis page says ChatGPT accepts .xls, .xlsx and .csv files and can summarize them, build tables and charts, and run Python-based calculations on them. What that page describes is analysis. It doesn't promise a formatted workbook coming back to you, so if you take this route for formatting, expect to be handed either a new file or a block of code, and treat the result as a new file to inspect rather than an edit to your original.
That last difference is the one that matters most. An in-place edit changes the thing you already have, so the risk is that it changes something you wanted left alone. A new file avoids that risk but creates another: anything the tool didn't carry across is simply gone, and you won't see it missing until someone asks where it went.
What did each do with the same formatting request?
I'm not going to print a scoreboard here. Both products change often, results vary with the model and the sheet, and a table of "Copilot did X, ChatGPT did Y" from one afternoon would be out of date by the time you read it. What lasts longer is the test itself. It takes about ten minutes, and it tells you what your assistant does to your files rather than what it did to someone else's.
Build a 40-row sheet that looks like real work: a header row, a few text columns, a currency column, a percentage column, a date column, a totals row, one formula column that references another sheet, one conditional formatting rule, and one merged title cell. Save a copy. Then give each assistant the identical request, for example: "Format this as a clean report. Don't change any values or formulas." Run it on a duplicate every time, never the original.
Afterwards, run these eight checks:
| Check | What to look for | Why it goes wrong |
|---|---|---|
| Values unchanged | Compare totals and a few raw cells to the saved copy | Rounding or "tidying" can alter what's stored |
| Formulas still live | Click formula cells; confirm they're formulas, not pasted numbers | A new file built from code can write results instead of formulas |
| Number formats | Currency, percent, and date columns still display correctly | Dates and percents are easy to flatten into text |
| Conditional rules | Open the rules manager and count the rules | A rule can be dropped, duplicated or rewritten |
| Merged cells | Is the title still merged, or did it spread across columns | Assistants differ in how they treat merges |
| Column widths and wrapping | Any #### or clipped text |
Widths are set once and not revisited after formats change |
| Other sheets | Do cross-sheet references still point at the right place | Edits to one tab can disturb another |
| Undo and history | Can you reverse the whole change in one step | In-place edits are only safe if you can walk back |
If a tool fails one of these on your sheet, you've learned something no review could have told you. If it passes all eight on a 40-row sheet, scale the test up before trusting it on the 4,000-row version, because a longer file gives it more places to wander.
Which one keeps your formulas and conditional rules intact?
The design of each route gives you hints about where to look, even without a scoreboard.
An in-place editor like Copilot or the ChatGPT add-in works on the live workbook, so formulas and rules are present from the start and are only lost if the assistant overwrites them. That is the failure to watch for: an instruction like "make it look consistent" can be read as permission to rewrite a cell range, and a formula inside that range goes with it. OpenAI's own help page for the add-in gives a hint of how to prevent it, with the example prompt "Update assumptions on the Inputs tab only. Don't change formatting." The same advice works in reverse for formatting jobs: name what to preserve, name where to work, and say what not to touch.
The upload route works from a copy. Python libraries that write .xlsx files can set fills, number formats and borders, but a script that rebuilds a sheet from scratch has to be told about every rule, every merge and every formula it should keep. If the instruction doesn't mention them, they're at risk. Plain values can survive while the structure around them doesn't, which is how you end up with a sheet that looks right and no longer recalculates.
Both OpenAI and Microsoft are straightforward about this in their own pages. OpenAI's add-in page says outputs may be incomplete or incorrect and recommends duplicating the file first so you can revert. That's good practice for every assistant, not only that one.
What does each require in plans and file location?
This is where the two differ most in daily use, and where the facts come straight from the vendors' help pages.
Copilot in Excel. Microsoft's Copilot in Excel FAQ lists the qualifying options: a Microsoft 365 Personal or Family subscription with an AI credits plan, a Microsoft 365 Premium subscription, a commercial Microsoft Copilot subscription, or a business or enterprise subscription that is Copilot Chat-eligible. Switching models inside Copilot needs a commercial Copilot subscription or Microsoft 365 Premium. Edit mode is available on Excel for Windows, Mac and the web. On iPad and iPhone, Microsoft says edit mode is rolling out, and on Android only chat mode is available.
On the file-location question, Microsoft's Copilot subscription FAQ says plainly that Copilot in Excel requires AutoSave to be enabled, meaning the file must be saved to OneDrive, and that it doesn't function with unsaved files. A workbook sitting in a local folder, or one a client emailed you, needs to be moved to OneDrive first.
ChatGPT for Excel. OpenAI's help article for the add-in says it's available to Free, Go, Plus and Pro users as well as business and education plans, with Free and Go getting limited usage and Plus and Pro subject to an agentic usage limit. You install it from the Add-ins menu in Excel, search for ChatGPT, and sign in. The page also notes that, under Microsoft's add-in marketplace terms, Microsoft may be able to read the content of your workbook, attachments and prompts. That's worth knowing before you point it at a client file.
ChatGPT with an upload. OpenAI's file upload FAQ says spreadsheets and CSVs are capped at roughly 50MB depending on row size, and that Free users are limited to a small number of uploads per day. The upload route has no OneDrive requirement, which is its main practical advantage for a file that isn't in the cloud.
Prices change and are tied to plans, so check the vendors' current pages before deciding. I haven't quoted figures here because they will have moved by the time you read this.
Where does each make formatting mistakes you have to catch?
The mistakes cluster by route rather than by brand.
In-place edits tend to fail by overreach. Ask for a "clean look" and a helpful assistant may also change a date format, widen a column that was meant to be narrow for printing, or restyle a total you had deliberately highlighted. The fix is a narrow request: "Apply formatting to A1:H41 only. Don't change values, formulas or number formats."
Rebuilt files tend to fail by omission. Merges, data validation, conditional rules, frozen panes and print settings are the things a script forgets. If your sheet depends on any of them, name them in the request, then check each one in the output.
Both routes fail by being confident. Neither one knows what your reader needs. A sheet with a bold header, banded rows and every number right-aligned looks finished, but it can still show a percentage as 0.18 or a negative as a minus sign where your finance team uses brackets. Number format conventions are a judgment call, and the number formatting guide covers the choices an assistant won't make for you.
One more habit pays off with any of them: ask for a change log. A request that ends with "then list exactly what you changed" gives you a list to verify against, and OpenAI's own add-in page uses almost that exact prompt as an example. It turns a vague "looks better" into something you can check cell by cell.
When is neither the right tool?
There are three situations where I'd skip both.
The file is going to a client and can't be wrong. A general assistant is a fine first pass, but a document with a contractual or financial purpose deserves a deliberate pass by a person. The pre-send checklist is built for that stage.
The problem is structure, not styling. Merged title cells, several tables stacked on one tab, headers that repeat mid-sheet: no formatting request fixes these safely, and an assistant that "fixes" them is guessing. Merged cells and what to use instead explains why, and what to build in their place.
You need the same result every time. An assistant interprets a request fresh each run, so two runs on two files will not match. If you format a monthly report, you want a repeatable result, not a clever one. Chart styling is the same story, and the chart formatting guide shows what a consistent standard looks like.
For that last case, there's a third route worth running alongside the other two. SuperSheet's formatter takes an .xlsx or .csv in the browser, shows you the plan of changes before applying them, and gives you back a formatted file with real number formats, a totals row, frozen panes and a theme. Its limits are plain: it doesn't unmerge cells or restructure a tab that holds several tables, because guessing at structure is how data gets lost. It's free to use, with Pro at $6 a month billed $36 every six months or $99 once, as listed on the pricing page. If you run your 40-row test on Copilot and ChatGPT, run it on SuperSheet too and compare all three against the eight checks.
Frequently asked questions
Can ChatGPT format an Excel spreadsheet?
Yes, in two ways. The ChatGPT add-in for Excel works inside your open workbook and lists formatting clean-up among its uses. In a regular ChatGPT chat you can upload an .xlsx or .csv, and ChatGPT will analyze it and may hand back a new file or code. Treat the output as a new file, and check formulas, number formats and conditional rules against your original before using it.
Does Copilot in Excel need the file saved to OneDrive?
Yes. Microsoft's subscription FAQ says Copilot in Excel requires AutoSave to be enabled, meaning the file must be saved to OneDrive, and that it doesn't work with unsaved files. If your workbook is on a local drive, move it to OneDrive first.
Is Copilot included in Microsoft 365 Personal?
Microsoft's FAQ lists a Microsoft 365 Personal or Family subscription with an AI credits plan as one of the qualifying licenses for Copilot in Excel, alongside Microsoft 365 Premium, a commercial Copilot subscription, and Copilot Chat-eligible business plans. Eligibility and credit allowances change, so confirm yours in your Microsoft account settings.
Will an AI assistant change my numbers while formatting?
It can. Both vendors say outputs may be incomplete or incorrect, and OpenAI recommends duplicating the file before the assistant edits it. Save a copy, tell the assistant not to change values or formulas, ask for a list of what it changed, and compare totals before and after.