For most project managers, spreadsheets remain unavoidable.
Whether it’s RAID logs, trackers, budgets, timelines, or scenario modelling, Excel and Google Sheets are still the backbone of day‑to‑day project work, even in organisations with formal PM tools.
With ChatGPT now embedded directly into Excel and Google Sheets, AI stops being something you “consult” elsewhere and becomes something you use inside the work itself.
What does ChatGPT in spreadsheets actually do?
The new integration allows users to interact with spreadsheets using natural language, directly inside the Excel or Google Sheets interface.
Typical capabilities include:
- creating and fixing formulas from plain‑English instructions
- cleaning and restructuring messy data
- generating summaries and insights from tables
- running quick “what‑if” or scenario analysis
- updating sheets without manual rework
Instead of translating requirements into formulas yourself, you can now describe the outcome you want and let the AI handle the mechanics.
Why this matters for PMs and PMOs
This is not about replacing project tools. It’s about reducing friction where work already happens.
For PMOs, spreadsheets are often:
- the lowest common denominator across teams
- the fastest way to analyse or stress‑test information
- still heavily relied on for reporting and decision support
AI embedded directly into spreadsheets offers:
- faster turnaround on reporting
- less reliance on advanced spreadsheet expertise
- fewer manual errors
- more consistent outputs across PMs
It allows project professionals to focus more on interpretation and decisions, and less on mechanics.
Practical project management use cases
ChatGPT in Excel and Sheets is particularly useful for:
📊 Reporting and status updates
- summarising large trackers into key messages
- highlighting trends, risks, or blockers
- preparing draft narratives for stakeholders
⚠️ Risk and dependency analysis
- identifying patterns across RAID logs
- testing the impact of delayed milestones
- comparing multiple delivery scenarios
💰 Budgeting and forecasting
- cleaning financial data
- modelling cost overruns or schedule changes
- quickly generating alternative scenarios
🧹 Data preparation
- fixing inconsistencies
- restructuring data pulled from multiple sources
- reducing time spent “getting the sheet ready”
These are all tasks PMs already do — just much faster.
A shift in how analysis happens
Traditionally, spreadsheet work has been split into two roles:
- people who understand the project
- people who understand Excel deeply
This change narrows that gap.
PMs no longer need to be spreadsheet experts to:
- ask the right analytical questions
- explore scenarios quickly
- get to decision‑ready data
AI handles the how; PMs stay focused on the why and the so what.
Governance still matters
As with any AI embedded into delivery tools, good practice is essential.
PMOs should reinforce that:
- AI‑generated formulas and outputs are always reviewed
- sensitive or client data is handled in line with policy
- AI supports analysis, but accountability remains human
Used responsibly, this capability improves quality and consistency rather than introducing new risk.
Tool availability
Tool: ChatGPT for Excel and Google Sheets
Provided by: OpenAI
Access: Available via ChatGPT plans (availability may vary by region and account type)
This is part of a broader shift toward AI embedded directly in everyday productivity tools, rather than standalone assistants.
Closing thought
The real value of AI for project management is not novelty — it’s removing friction from familiar workflows.
By bringing ChatGPT into Excel and Google Sheets, AI meets PMs where they already work. For PMOs focused on saving time, improving reporting quality, and enabling better decisions, this is one of the most practical and immediately useful AI developments to date.
Comments
Post a Comment