Extend an existing financial model with Claude in Excel without breaking it
Have Claude explain how the tabs connect and annotate complex formulas first, then extend the model following the original patterns while you check its assumptions.
Tools used
- Claude in ExcelReads formulas, adds comments and extends the model
- Excel (Microsoft 365)Holds the model
Step navigator
An extended model with commented new formulas, where you have checked the assumptions Claude relied on.
FP&A and finance people who maintain multi-tab models.
Before you start
Finance users on r/FPandA say Claude in Excel is good at debugging formulas and building from scratch, but can break existing models if the prompt is slightly off. Anthropic's own example for inherited spreadsheets starts with understanding before extending. This guide follows that order.
Step-by-step instructions
Ask Claude to explain how the tabs connect first
Before any change, ask for the structure: how the tabs connect, what the key formulas do, and what isn't documented. Anthropic's example asks Claude to read the existing Legend tab and cell comments first.
Read the Legend tab and the cell comments, then explain how the four tabs connect, what the seasonality and CAC payback formulas do, and anything important that isn't documented. Don't change anything yet.
Why this works
Understanding first keeps the extension consistent with the original logic.
Have it annotate the complex formulas
Ask Claude to add cell comments explaining complex formulas and flagging logic that wasn't clear. Anthropic describes ending up with "both an explanation and a marked-up file you can reference later."
Check its reading of the assumptions yourself
An FP&A user's warning: "if your prompt is even a little off, it can misunderstand the assumptions. I think you still need to really understand the model logic yourself." Compare Claude's explanation with the formulas before you go on.
Why this works
Existing models are where it breaks things.
Ask for the extension with very specific instructions
Ask it to extend the model following the original patterns and to comment any new formulas. Users stress specificity: "You have to be very specific", and another user who finds it works with their existing model still says "I have to be very specific with what I am asking it to do."
Extend the model through Q3 2026 using the same formula patterns as the existing quarters. Comment every new formula. List every cell you changed.
Iterate, then spot-check the new periods
Review the list of changed cells, check a few new periods by hand, and ask for fixes. One user's approach: "ask it to make recommendations and then iterate. Iterate. Iterate."
End of guide · Reviewed Oct 26, 2026
Pro tips2
- Work on a copy of the model.
- Ask Claude to list every cell it changed so you can review them.
Common mistakes2
- Asking for the extension before Claude has explained the model.
- Handing off an existing model blindly.
FAQ2
Is it good for charts?
Can it handle circular references?
Related field guides.
ExcelCombine monthly files with Power Query, using an LLM one step at a time
Point Power Query at a folder of same-shaped files, then use ChatGPT or Copilot only to write or explain individual M steps, testing each one before adding the next.
ExcelTurn a recorded macro into reusable VBA with ChatGPT, then test it on a copy
Record the task, have ChatGPT clean up and comment the code and make the ranges dynamic, then compile, step through and test it on a copy before it touches real data.
ExcelRun a Python analysis in Excel with Copilot's Advanced Analysis
Put the data in a Table in a cloud-saved workbook, start Advanced Analysis in Copilot, let it write Python cells, and read each one before you reuse the code.