How to Replace Manual Excel Reports: Automate in Excel First, Then Switch
Automate what Excel can do itself, spot the signs a report has outgrown the workbook, and move it to AI reporting step by step, with every figure checked.
- Excel
- Automation
- Reporting Workflows

Most monthly reports still go the same way. Someone exports from each tool, pastes the rows into last month's workbook, repairs the formulas, rebuilds the charts and rewrites the comments. To replace that routine, start inside Excel: it can already refresh data and replay steps. Then move the report to AI reporting one report at a time, with every figure checked against the source before the spreadsheet goes.
What can you automate in Excel before replacing anything?
Three built-in tools cover most of the routine. Power Query combines and cleans the exports, refresh settings update them, and Office Scripts replay the formatting you repeat. None of them needs VBA.
- Combine the exports. Save each month's files in one folder and load it with Power Query's From Folder connector. Next month, drop the new file in and refresh. The steps and the traps are in how to merge Excel and CSV files with Power Query.
- Refresh without clicking. In the query's Properties, the Usage tab offers "Refresh data when opening the file" and "Refresh every" a number of minutes. Ctrl+Alt+F5 refreshes everything in the workbook Microsoft Support.
- Replay the formatting. Office Scripts record what you do, such as deleting columns, formatting a table, adding formulas and building a PivotTable, and replay it on another workbook. Microsoft's own example is a CSV from an accounting site cleaned up every morning Microsoft Learn.
Scheduling inside Office Scripts is "temporarily disabled", according to the same page. To run a script on a schedule, call it from a Power Automate flow.
For one-off questions on the finished table, the AI add-ins inside Excel help too. Copilot, Claude and ChatGPT in Excel compares what each one does.
When should you replace a manual Excel report?
Replace it when the report comes back every month, pulls from several files, and people ask how a number was counted. Excel can repeat the steps. It doesn't keep your definitions, show how each figure was computed, or write the comments.
Signs the report has outgrown the workbook:
- The same report every month, with the same steps.
- Three or more exports joined by hand, with lookups across tabs.
- One person owns the file, and everyone else waits for them.
- A figure gets questioned in a meeting, and tracing it back takes longer than building it did.
- The comments get rewritten from scratch every month.
If only the first sign applies, Power Query and a clean template are often enough. Keep the workbook. For what to look for in a reporting tool once you switch, read reporting tool vs Excel.
How do you move from manual reporting to AI-driven reporting?
Move one report at a time and run the old and new versions side by side for one cycle. Write the definitions down first, give the AI the same exports, and compare totals before anyone stops using the spreadsheet.
- Pick the report that costs the most time and has the fewest sources. A first success matters more than the biggest report.
- Write the definitions in one line each. Is revenue counted before or after refunds? What makes a customer active? Does a sale belong to the month of the order or of the payment?
- Collect one month of exports in their raw form, with no edits by hand.
- Ask for the report, with the definitions in the request.
- Check three figures against the source export: a total, a count and one segment.
- Run both versions for one month. A gap means a definition was unclear. Fix the definition, not the number.
- Retire the spreadsheet once the totals match.
What does AI reporting still need from you?
Clean exports, written definitions and someone who checks. An AI that writes the query still has to guess what "active" means when nobody said it.
Microsoft says Copilot's output "can be inaccurate or inappropriate" and asks users to review it Microsoft Support. On SpreadsheetBench, Microsoft measured Excel's Agent Mode at 57.2% accuracy, against 71.3% for people (Futurum Group, October 2025, before general release).
So keep the habits that made the spreadsheet trustworthy. One file of definitions. One person who signs off. And last month's report kept beside this month's, so a big swing gets a second look before it goes out.
Where does Glow Reports fit?
Glow Reports takes the exports as they are. You upload the month's CSV or Excel files together and ask for the report in plain language, with your definitions. The AI writes the SQL, builds the charts and drafts the text.
The SQL sits under each figure. When a number looks wrong, you read how it was counted and edit the query, instead of hunting through tabs. The report exports to PDF and stays in your workspace, so next month you upload the new files, ask again and compare. The free plan gives 300 credits once, and a report costs 100 credits.
Common questions
Is Excel ever the right tool for reporting?
Yes. Excel suits one-off analysis, financial models and any report you build once. It becomes the wrong tool when the same report comes back every month and the manual work comes back with it.
Can Excel refresh a report on its own?
Partly. Query Properties can refresh the data when the file opens or every few minutes while it is open, and a Power Automate flow can run an Office Script on a schedule. The charts that need rebuilding and the comments stay manual.
Do I need SQL to move to AI reporting?
No. The AI writes the SQL. Reading it helps when you check a figure, and a definition written in plain English is what keeps the numbers right.
How long does the switch take?
Plan one reporting cycle per report. The side-by-side month is where the definitions get fixed, and it is the step that makes people trust the new report.
I am a product engineer and the founder of Glow Reports. I spent more than 6 years building products in tech, data and cybersecurity, for large groups, startups and SMEs. In most organizations I saw data treated as a technical topic, when it drives business decisions. I built the reporting tool I was looking for, so the people who run small and mid-sized organizations can read their own numbers without a data team.
More from El Mehdi BenaneUpload this month's exports to Glow Reports and get the report with the SQL behind each figure.
Keep reading
Ad Hoc Reporting Requests: How to Cut the Queue So Business Teams Answer Their Own QuestionsEl Mehdi Benane, 4 min read
How to Calculate Days Between Two Dates in Excel, and Fix DATEDIF #NUM!El Mehdi Benane, 4 min read
XLOOKUP vs VLOOKUP vs INDEX MATCH: Which One to Use on Your ExportsEl Mehdi Benane, 4 min read