AI tools

How does Microsoft Copilot compare with ChatGPT for Office work?

· By Robert Scales · 4 min read

Short answer

Copilot Pro puts an AI assistant inside Word, Excel, PowerPoint, Outlook and OneNote, so it works on your document where it sits, while ChatGPT Plus works in a separate window on files you upload and is stronger for open-ended analysis and step-by-step calculations. Both cost $20 a month; the better choice depends on whether you spend your day inside Office files or need a general assistant.

Two months ago, Microsoft opened Copilot to individuals inside its Office apps. Copilot Pro, launched on January 15 at $20 per user per month, brings Copilot into Word, Excel, PowerPoint, Outlook and OneNote for people with a Microsoft 365 Personal or Family subscription. That is the same monthly price as ChatGPT Plus, so a lot of people who write reports and build spreadsheets are now asking which one to pay for.

They are built for different ways of working. Copilot lives inside the document. ChatGPT lives in its own window, and you bring the work to it.

What each one actually is

Copilot Pro is a subscription layered on top of Microsoft 365. It adds a Copilot pane to the Office apps on PC, Mac and iPad, priority access to OpenAI's GPT-4 Turbo model when demand is high, faster image creation in Designer, and a tool for building custom Copilot GPTs that Microsoft says is coming soon. Copilot in Excel is still a preview and works in English only. It does not include Copilot in Teams, which belongs to the business product, Copilot for Microsoft 365, at $30 per user per month.

ChatGPT Plus is OpenAI's $20-a-month plan for individuals. Its data tool, introduced to Plus users last July under the name Code Interpreter, writes and runs Python code in a sandbox (a sealed-off computing space) to do the math, charts and file conversions you ask for, then lets you download the results.

There is also a free Copilot at copilot.microsoft.com and a free ChatGPT, but neither works inside your Office files.

One task, two tools

Here is a worked comparison. You have a Word draft of a quarterly report and an Excel sheet of monthly sales for four regions. You need a one-page summary with the key numbers, a chart and three recommendations.

StepWith Copilot ProWith ChatGPT Plus
Get the data inAlready there: open the workbook and the draftUpload the Excel file and paste or upload the draft
Analyze the numbersAsk Copilot in Excel (still a preview) for totals by region and the biggest changeAsk ChatGPT to calculate totals and growth; it runs code you can inspect
Make a chartAsk Copilot in Excel, or insert one yourself from the totalsChatGPT's data tool draws one you download
Write the summaryAsk Copilot in Word to draft from your draft, in placeChatGPT writes it in the chat; you copy it into Word
FormattingThe text is already in your documentYou paste the text into Word and format it

A prompt that works well in either tool:

Prompt
Using the sales data, give me: total sales per region for the quarter,
the region with the largest change from last quarter (with the percentage),
and one sentence on what might explain it. Show your calculation.
Then draft a 250-word summary for managers, plain language, three
recommendations as bullet points at the end.

Expect Copilot to save the most time on the writing steps, because nothing leaves Word. ChatGPT is more transparent on the analysis, because you can open the code it ran and check every figure. Either way, check the numbers yourself against the spreadsheet before the report goes out; both tools can make arithmetic or reading errors.

Try it: Take a real spreadsheet you work with and ask either tool the prompt above. Then do one of the calculations by hand or with a normal Excel formula, and compare. If they match, try a harder question; if not, ask the tool to show exactly which cells it used.

Where each one fits

Copilot is the better fit if your work starts and ends in Office documents, if formatting matters, and if you would otherwise spend time copying text between windows. ChatGPT is the better fit for data work you want to verify, for files that aren't Office documents, and for general questions, brainstorming and learning that have nothing to do with a specific file.

Businesses have a third question, which is where their data goes. Copilot Pro is for individuals; Microsoft points organizations to Copilot for Microsoft 365, which can also draw on work email, meetings and chats. OpenAI's equivalent for small teams is ChatGPT Team, at $25 to $30 per user per month, with GPT-4, DALL-E 3 and the same file tools; OpenAI says it does not train its models on Team data.

When is Copilot Pro worth it?

Copilot Pro is worth it when three things are true. You already pay for Microsoft 365 Personal or Family, since Copilot Pro is an add-on to it. You spend several hours a week writing or editing in Word, building slides in PowerPoint, or working through email in Outlook. And you would use the assistant in place, on the documents you already have, rather than starting from a blank chat.

It is harder to justify if you mostly need Excel analysis, since Copilot in Excel is still a preview in English only, or if you work in Google Docs or other tools. It also overlaps heavily with ChatGPT Plus: both are built on OpenAI models, both cost $20 a month, and few people need both. If you pay for ChatGPT Plus already and copying text into Word doesn't bother you, keep what you have.

A practical approach is to try one month on a real project. Keep a short log of each time Copilot saved you a step, and each time you went back to ChatGPT or did the work yourself. At the end of the month the log will tell you more than any comparison table.

Sources

  1. Bringing the full power of Copilot to more people and businesses — Official Microsoft Blog (Yusuf Mehdi); read via Wayback Machine capture of 2024-01-16, January 15, 2024
  2. OpenAI debuts ChatGPT subscription aimed at small teams — TechCrunch (Kyle Wiggers), January 10, 2024
  3. OpenAI Releases ChatGPT Code Interpreter, 'Your Personal Data Analyst' — Datanami (Alex Woodie), July 11, 2023

Get the free Guide to Artificial Intelligence

Sign up for the weekly newsletter and receive the free guide: what changed in AI this week, one lesson, one prompt to try. Unsubscribe in one click.

How we handle your address

Back to top

Display

Your choices are saved in this browser only. No data is sent.

Text size
100%
Colours
Reading
More settings
Accessibility statement