ChatGPT for Excel and PowerPoint: Automate a Recurring Report

Same scene, every first of the month. Your office manager opens four exports, copy-pastes numbers across three Excel tabs, recalculates two totals by hand, then switches to PowerPoint to rebuild last month's deck with the new figures. Three or four hours later, the report goes out by email. Next month, repeat. And when she's on holiday, you're the one stuck doing it, swearing you'll "automate this someday."

That someday is this week. Since May 2026, ChatGPT can create, fill and format .xlsx and .pptx files directly. You can work in a side panel inside Excel and PowerPoint, or have it generate the file from scratch out of your data. No VBA macro, no developer. You describe what you want in plain language, it hands you the file.

This tutorial shows you how to set up a recurring report that almost fills itself. Five steps, each with its concrete tool, a setup in a few minutes, and the result you can expect. All of it is testable today with a ChatGPT account at around 20 dollars a month.

1. Frame the report before touching the AI

The classic mistake is opening ChatGPT and asking it to "make me a nice report." You'll get something generic, pretty, and unusable, because your report follows specific rules the AI cannot guess. Before automating anything, you have to lock down the structure.

Concrete tool: a plain text document (Notion, Word, or even an email to yourself). No cost.

5-minute setup:

1. Pull up the last report your team produced by hand. The real one, the one that went to the client or the committee.
2. List the blocks it contains: revenue by segment, margin, top 5 clients, year-over-year comparison, commentary. Note the exact order and the format of each figure (euros, percentage, one decimal or none).
3. Identify where each piece of data comes from: which export, which tab, which column. This is the boring part, but it's what makes the automation hold up over time.

Expected outcome: a half-page that describes your report like a recipe. This page becomes the brief you'll paste into ChatGPT at every following step. The time you spend here, you get back tenfold later.

2. Install ChatGPT inside Excel and PowerPoint

Since early May 2026, ChatGPT exists as an official add-in for Excel (out of beta) and for PowerPoint (launched in beta on May 21, 2026). The add-in opens in a side panel to the right of your file. You speak in plain language, it acts on the open document. It's available on every plan, from free up to Enterprise, but for serious business use you want a paid plan at minimum.

Concrete tool: Microsoft 365 (Excel and PowerPoint, desktop or web) plus the ChatGPT add-in from Microsoft AppSource. On the ChatGPT side, count on a Plus plan at roughly 20 dollars a month for individual use, or Business/Team around 25 to 30 dollars per user for a team (with the guarantee that your data isn't used to train the models). Enterprise starts near 50 to 60 dollars for SSO and audit controls.

5-minute setup:

1. In Excel, go to Home then Add-ins (or Insert then Get Add-ins).
2. Search for "ChatGPT", install the add-in, then connect your OpenAI account.
3. Repeat the operation in PowerPoint. The ChatGPT panel appears on the right, ready to take your instructions.

Expected outcome: a chat panel directly inside both of your office tools. No more back-and-forth between a browser and your file. Note that add-in conversations stay isolated from your regular ChatGPT history, which is rather healthy for company data.

3. Fill and calculate the Excel file

This is the heart of the time savings. Instead of copy-pasting columns and writing formulas by hand, you describe the calculation you want and ChatGPT lays it down. It can generate lookup and filter formulas, normalize messy columns, and apply row-by-row processing across thousands of entries.

Concrete tool: the ChatGPT add-in in Excel, on your raw data file (the export from your billing tool or your CRM).

5-minute setup:

1. Open your data export in Excel. Select the relevant range.
2. In the ChatGPT panel, give a precise instruction: "In a new sheet, calculate revenue by client segment for the current month, compare it to the same month last year, and show the gap as a percentage with one decimal."
3. Check the result, then ask for an adjustment if needed: "Sort from the largest segment to the smallest and turn negative gaps red."

Expected outcome: your summary tab gets built in a few minutes instead of an hour of manual work. ChatGPT also explains the formulas it lays down, so your team understands what's happening and can take over if the format changes. On a report of medium complexity, count on 45 minutes saved per cycle.

4. Generate the PowerPoint from the data

Once your Excel is clean, you move to the presentation. The PowerPoint add-in can build an entire deck from a brief, notes, a document or a spreadsheet. So you can feed your slides directly with the Excel summary you just produced.

Concrete tool: the ChatGPT add-in in PowerPoint, plus your Excel file from the previous step and the structured brief from step 1.

5-minute setup:

1. Open a blank PowerPoint (or your usual reporting template) and launch the ChatGPT panel.
2. Give the brief: "Create a monthly reporting deck in six slides: title, total revenue, performance by segment, top 5 clients, year-over-year comparison, summary commentary. Use the figures from the summary sheet."
3. Then adjust slide by slide: "Lighten slide 3, it's too dense, switch it to three columns" or "Rewrite the title of slide 1 so it mentions the month and the year."

Expected outcome: a structured, filled deck in about ten minutes, where the manual rebuild took an hour or more. ChatGPT can also analyze an existing deck, spot the weak slides, and anticipate the questions an executive will raise in the meeting, which strengthens your presentation before you even send it.

5. Connect the sources and turn it into a ritual

The report becomes truly automatic when ChatGPT fetches the data on its own. The add-ins connect to Gmail, Outlook and SharePoint linked to your account, so it can pull a file straight from your shared space rather than waiting for you to drop it in by hand.

Concrete tool: the ChatGPT connectors (Outlook, SharePoint, OneDrive) plus a simple team ritual written into the calendar.

5-minute setup:

1. In the add-in settings, authorize the connection to your company SharePoint or OneDrive.
2. Always store the source export in the same place, with the same file name from one month to the next (for example "billing-export-month.xlsx").
3. Set a recurring reminder on the first working day of the month: "Monthly report, 20 minutes." The person opens Excel, runs the brief from step 3, generates the deck from step 4, reviews, sends.

Expected outcome: a report that goes from three or four hours down to about twenty minutes of human steering. The format stays identical from month to month because the brief is locked. And above all, the day the usual person is away, anyone on the team can pick up the ritual by following the same recipe.

And now?

You've just turned a four-hour monthly chore into a twenty-minute ritual that anyone on your team can run. That's a single report. The same logic applies to the weekly sales report, the production dashboard, the quarterly accounting recap, the client portfolio review. Every recurring office task that eats hours is a candidate.

The trap, at this stage, is wanting to automate everything at once and spreading yourself thin. The right question isn't "what can I automate," it's "which report costs me the most today, and which one is most likely to hold up once automated." Choosing the wrong first project doesn't cost money, it costs momentum. And momentum decides whether the team moves straight to a second project or shelves the topic for six months.

This is exactly what we do in the Scan of the S3 framework: 30 minutes to spot the two or three most profitable office automations in your specific context, no pitch and no commitment. We look together at what your team redoes every month, what it really costs, and where to start to win fast. You can book this free Scan on solidscale.tech. If we identify a project behind it, great. If you walk away with a plan your team runs in-house, that's just as good.