A practical guide for monitoring, evaluation, and learning professionals using Claude's AI directly inside Microsoft Excel — to analyze MEAL data, build indicator dashboards, debug formulas, and run results framework analyses without leaving your workbook.
Claude for Excel is an official Microsoft Office Add-in that brings Anthropic's Claude AI directly inside your Excel workbook. For M&E professionals, it means you can ask questions about any cell, formula, or tab in your MEAL dataset, indicator tracker, or results framework — and get clear, cell-level explanations, formula fixes, and data analysis without leaving the spreadsheet.
Ask Claude to explain any formula, calculation, or data in your workbook. Every explanation includes cell-level citations so you can verify the logic instantly.
Change indicator targets, baseline values, or scenario assumptions across the entire model while Claude preserves all formula dependencies automatically.
Trace #REF!, #VALUE!, #DIV/0!, and circular references to their source in seconds — with a clear explanation of what went wrong.
Create indicator progress dashboards, pivot tables, and charts from your MEAL data. Claude structures and populates visualizations from your existing data.
Save your evaluation workflows — variance analysis, data quality checks, survey summaries — as one-click Skills any team member can run instantly.
Claude passes context across Excel, Word, and PowerPoint add-ins. Analyze data in Excel, then draft findings in Word — in one continuous conversation.
Claude for Excel is available on Claude Pro, Max, Team, and Enterprise plans — including individual Pro plans. This makes it accessible to independent evaluation consultants, not just organizations with Team licences. Visit claude.ai or claude.com/pricing to check your plan.
Claude for Excel is in beta across all paid plans as of April 2026. Features are actively being developed. Install early to access the full beta feature set and provide feedback that shapes the tool's development for the M&E community.
Installation takes under five minutes via Microsoft AppSource. Compatible with Excel 2019 or later, Excel for Mac, Excel on the Web, and Excel on Windows (Microsoft 365).
Log into claude.ai and verify you are on a Pro, Max, Team, or Enterprise plan. Unlike Claude for Word, individual Pro plans are fully supported — making this accessible to independent consultants and evaluators.
Visit claude.com/claude-in-excel or search "Claude by Anthropic" in Microsoft AppSource. Click Get it now. Sign in with your Microsoft work, school, or personal Microsoft account.
Both work/school and personal Microsoft accounts are supportedOpen Microsoft Excel. Go to Insert → Add-ins → My Add-ins. Locate Claude by Anthropic for Office and click Add. The Claude panel opens on the right side of your workbook.
In the Claude panel, click Sign in with your claude.ai credentials. Your plan is verified automatically. Enterprise users can also authenticate through Amazon Bedrock, Google Cloud Vertex AI, or Microsoft Foundry.
Open your MEAL database, indicator tracker, or survey data workbook. Press Ctrl+Option+C (Mac) or Ctrl+Alt+C (Windows) to open Claude instantly from anywhere in Excel.
Pin the Claude panel open while working on complex evaluation modelsClaude for Excel works through a side panel that stays open alongside your workbook. There are five core interaction modes — each suited to different stages of M&E data work.
Click any cell in your workbook — an indicator formula, COUNTIFS, VLOOKUP, or nested IF — and ask Claude: "Explain what this formula in D14 is calculating and whether it is correctly counting only female beneficiaries." Claude returns a plain-English explanation with cell-level citations so you can trace the logic.
Best for: understanding inherited formulas, verifying data logic, training new M&E staffSelect a range or refer to specific cells and ask: "Update the Year 2 target for indicator 3.1 from 1,200 to 1,500 and show me all cells affected by this change." Claude highlights every updated cell with an explanation, preserving all downstream formula dependencies.
Best for: scenario testing, mid-project target revisions, budget reforecastingClick on any error cell and ask: "Why is cell G145 returning #VALUE! and how do I fix it without disrupting the rest of the model?" Claude traces the error to its source, explains what caused it, and proposes a corrected formula.
Best for: fixing broken MEAL databases, debugging complex indicator calculationsAsk Claude to build new analytical structures: "Create an indicator progress dashboard on a new tab using the data in the Beneficiaries tab, with columns for indicator name, target, achieved, variance, and percent completion." Claude creates the structure and populates it from your existing data.
Best for: building MEL dashboards, creating pivot tables, structuring new analysis tabsIf your team has saved M&E workflows as Skills — variance analysis, data quality check, beneficiary summary — click the Skills button in the Claude panel and run any skill with one click. Skills apply the same analytical workflow to any dataset that matches the template.
Best for: recurring reports, team-wide standardized analysis, audit-ready workflowsThis formula counts the number of female beneficiaries who have a status of "Completed" and whose district code matches the value in cell A14. It pulls from the Beneficiaries tab across three columns simultaneously using COUNTIFS with multiple criteria.
Claude highlights every change it makes in your workbook with a cell-level explanation. Before saving, review all changes in the Claude panel to confirm they are correct. For critical MEAL databases, keep a backup copy before starting a Claude session.
Nine high-value use cases for monitoring, evaluation, and learning practitioners — from MEAL data analysis to indicator dashboards and survey data processing.
Build a live indicator progress dashboard from your MEAL database. Track target vs. achieved values, calculate percent completion, flag under- and over-performing indicators, and disaggregate by sex, geography, and population group.
Process KII and household survey data collected in Excel. Clean inconsistencies, identify outliers, calculate frequencies and cross-tabulations, summarize responses by demographic group, and flag data quality issues.
Build and manage a logframe tracking sheet with auto-calculated progress against each output, outcome, and impact indicator. Link indicator data tabs to the logframe matrix and generate period-over-period variance summaries.
Analyze budget vs. actual expenditure across project budget lines. Calculate absorption rates, identify over- and under-spend, model revised projections, and generate variance narratives for donor reporting.
Run systematic data quality checks across your MEAL database. Identify duplicate entries, missing values, out-of-range data, date inconsistencies, and format errors. Generate a data quality report with recommended corrections.
Analyze beneficiary registration databases. Count unique beneficiaries by location, sex, age group, and vulnerability status. Generate demographic summaries, calculate reach against targets, and flag duplicate registrations.
Build scenario models to test different assumptions — coverage rates, unit costs, dropout rates, exchange rate variations. Claude updates all dependent cells and shows you the impact on output targets and project costs.
Aggregate data from multiple tabs or collection periods into a consolidated results summary. Automatically calculate cumulative achievements, period-over-period changes, and percentage progress toward end-of-project targets.
| M&E Task | Excel Tab / Data | Claude Action | Key Prompt |
|---|---|---|---|
| Indicator Progress | Indicator tracker tab | Calculate % completion, add RAG status column, flag below-target indicators | "Add a RAG status column — Red if below 70%, Amber 70–90%, Green above 90%" |
| Beneficiary Count | Registration database | Count unique beneficiaries, deduplicate, disaggregate by sex and district | "Count unique beneficiaries by district and sex, excluding duplicate IDs" |
| Survey Analysis | KoboToolbox / ODK export | Calculate frequencies, build cross-tabs, identify non-responses | "Calculate the frequency of each response to Q5 by respondent sex" |
| Budget Tracking | Budget vs. actuals sheet | Calculate absorption rate, flag over/underspend, project year-end position | "Calculate absorption rate per budget line and project year-end spend at current burn rate" |
| Data Quality | Any MEAL dataset | Identify blanks, duplicates, out-of-range values, date errors | "Flag all rows where Age is above 120 or below 0, and where Date is outside project period" |
| Variance Analysis | Results framework tracker | Calculate actual vs. target variance, explain significant variances | "Calculate variance from target for each indicator and highlight variances above 20%" |
| Pivot Summary | Raw data tab | Create pivot table summarizing beneficiaries by location, type, and status | "Create a pivot table on a new tab showing total beneficiaries by region and program type" |
| Logframe Update | Logframe matrix tab | Update achieved values, recalculate cumulative progress, flag milestones | "Update Q2 achieved values from the Data tab and recalculate all cumulative totals" |
M&E work in Excel relies on a set of formulas that handle counting, conditional logic, aggregation, and lookup across complex multi-tab datasets. Claude can explain, write, debug, and optimize all of these for your specific workbook structure.
Count or sum beneficiaries, activities, or costs meeting multiple criteria — by sex, district, status, and date range simultaneously. The most common formula type in beneficiary databases.
Pull indicator names, donor codes, or location names from reference tables into your tracking sheets. Claude can convert legacy VLOOKUPs to the more robust XLOOKUP.
Build RAG status logic, flag data quality issues, apply conditional scoring, or create tiered performance classifications — essential for indicator dashboards.
Summarize large MEAL datasets by geographic area, program component, beneficiary type, or reporting period. Claude can create and configure pivot tables from your raw data.
Calculate reporting periods, project duration, days between dates, or flag data collected outside valid date ranges — critical for data quality checks and period summaries.
Calculate indicator completion percentages, budget absorption rates, period-over-period variance, and coverage ratios. Claude writes these with correct error handling for zero-division cases.
Link data between tabs using structured references. Claude ensures formula integrity is maintained when you add rows to your data tabs — a common source of broken MEAL models.
Calculate disaggregated averages for satisfaction scores, cost-per-beneficiary, or test results — filtering by subgroup for statistical analysis of survey and assessment data.
Clean up error displays in dashboards and handle missing data gracefully. Claude wraps all formula outputs with appropriate error handling for professional-looking MEAL reports.
Before modifying any formula in an inherited MEAL database, ask Claude to explain the full calculation chain: "Explain what cell D14 is calculating, which cells it depends on, and which other cells depend on it." This prevents accidentally breaking downstream calculations.
Copy and adapt these prompts directly into the Claude for Excel panel. Replace bracketed values with your actual cell references, tab names, and indicator names.
Create an Indicator Progress Dashboard on a new tab called "Dashboard" using data from the [tab name] tab. Include columns for: Indicator Code, Indicator Name, Baseline, End-of-Project Target, Year [N] Target, Year [N] Achieved, Variance from Annual Target (%), Cumulative Achieved to Date, Cumulative % of End-of-Project Target, and a RAG status column (Red below 70%, Amber 70–90%, Green above 90%). Pull data automatically using formulas linked to [data tab name].
Analyze the data in [tab name] and create a disaggregation summary on a new tab. Break down total beneficiaries reached by: (1) Sex — Male/Female/Other, (2) Age group — Under 18, 18–35, 36–59, 60+, (3) Geographic area — by [district/region column], (4) Disability status if present. Calculate the percentage each group represents of the total. Add a column showing the target disaggregation percentages from column [X] and flag any group where the actual percentage differs from target by more than 10 percentage points.
Write a formula for a RAG status column based on the percentage completion value in column [X]. Apply the following rules: Red if below 70%, Amber if 70% to 89%, Green if 90% or above, and Grey (display as "No data") if the cell in column [X] is blank or contains an error. Use conditional formatting to color the cells accordingly — Red fill for Red, Amber fill for Amber, Green fill for Green.
Analyze the survey responses in this tab and create a frequency analysis on a new tab called "Survey Summary". For each closed-ended question (columns [C] through [P]): (1) List all unique response options, (2) Count the frequency of each response, (3) Calculate the percentage of respondents selecting each option, (4) Break down responses by [sex column] — show Male and Female percentages separately. Flag any question with more than 10% non-response or missing values.
Check this beneficiary database for duplicate registrations. A duplicate is defined as: the same beneficiary ID appearing more than once in column [A], OR the same combination of First Name + Last Name + Date of Birth appearing in more than one row. Add a new column called "Duplicate Flag" at the end of the sheet. Mark all duplicate rows with "DUPLICATE" and the first/original row with "ORIGINAL". Count the total number of unique beneficiaries after deduplication and display the count in cell [X].
Run a data quality check on this dataset and add a "DQA Flag" column at the end. Flag each row with one of the following issues if present: MISSING DATA (any required field in columns A–H is blank), OUT OF RANGE (Age outside 0–100, or numeric values below 0 in columns I–M), DATE ERROR (any date outside the project period [start date] to [end date]), DUPLICATE ID (beneficiary ID appears more than once), or OK if no issues found. Create a DQA Summary tab showing the count of each issue type and the rows affected.
Analyze the budget vs. actuals data in this sheet. For each budget line: (1) Calculate the absorption rate (Actual Spend ÷ Budget × 100), (2) Calculate the remaining budget, (3) Calculate the projected year-end spend based on current monthly burn rate, (4) Flag lines where absorption is below 50% or above 95% of the pro-rated expected spend at this point in the project. Add a Variance Explanation column where I can type notes for flagged lines. Display a summary total row at the bottom.
Explain in plain English what the formula in cell [cell reference] is doing. Tell me: (1) What it is calculating and what the result represents, (2) Which cells and tabs it depends on, (3) What each argument or criteria in the formula means, (4) Whether the formula logic is correct for counting [describe what you are trying to count], (5) Any potential issues — such as what happens if new rows are added to the data tab, or if a referenced cell is blank.
Cell [cell reference] is returning a [#VALUE! / #REF! / #DIV/0! / #NAME? / circular reference] error. Trace the source of this error and explain: (1) What is causing the error, (2) Which cells or formulas are involved in the error chain, (3) What the corrected formula should be, (4) Whether fixing this cell will affect any other cells or tabs in the workbook. Provide the corrected formula and highlight all changes made.
I need to update the following assumptions in this workbook and see the full downstream impact: [list the assumption changes, e.g. "Indicator 3.1 annual target: change from 1,200 to 1,500" and "Unit cost per training: change from $45 to $52"]. Make these changes and show me: (1) Which cells were directly updated, (2) Which other cells or tabs are affected by these changes, (3) What the new totals and percentages are in the summary dashboard. Highlight all changes clearly with explanations.
Create a pivot table on a new tab called "Pivot Summary" using the data in this tab. Configure the pivot table to show: Rows = [geographic area column], Columns = [sex column], Values = Count of beneficiary IDs. Add a second pivot table below it showing: Rows = [program component column], Values = Count of unique beneficiaries, Sum of [output value column if applicable]. Format both tables clearly with totals rows and a title indicating the reporting period.
Generate a results summary table from this indicator tracker for the reporting period [period]. For each indicator: pull the indicator name, annual target, achieved value, percentage completion, and cumulative achieved to date. Highlight in amber any indicator below 80% of the pro-rated period target, and in red any indicator below 50%. Format the table ready to copy into a Word donor report, with a header row and clear column labels. Include a footnote row with the total number of direct and indirect beneficiaries.
Skills are saved Claude workflows that you and your team can run in one click from the Excel panel. When your team defines the right workflow for a recurring M&E task — variance analysis, data quality check, beneficiary summary — save it as a Skill so anyone can run it consistently, without retyping the prompt each time.
Compares this period's indicator achievements against targets, calculates variances, applies RAG status, and flags indicators requiring explanations. Run at every reporting period close.
Scans the registration database for duplicate beneficiary IDs and name/DOB combinations, flags all duplicates, and outputs a clean count of unique verified beneficiaries.
Runs a systematic DQA check across the MEAL database — missing values, out-of-range data, date errors, format inconsistencies — and generates a DQA summary report tab.
Calculates absorption rates per budget line, projects year-end spend at current burn rate, flags over- and underspending lines, and generates a summary for the finance team.
Takes raw KoboToolbox or ODK survey exports and generates a clean frequency table disaggregated by sex and geography — ready for the findings section of your report.
Pulls latest achieved values from the data tab, updates the logframe matrix, recalculates cumulative progress, and highlights any milestone that has been reached or missed.
Checks whether the current beneficiary breakdown by sex, age, and location meets the disaggregation targets in the logframe, flagging any groups that are under- or over-represented.
Formats indicator results data into a clean, donor-ready results table with targets, achievements, variance, and cumulative totals — ready to paste directly into Word or PowerPoint.
Run the Claude workflow that produces the output you want. Refine the prompt until the results are exactly right for your M&E context — the right columns, the right thresholds, the right tab names.
Click Save as Skill in the Claude panel. Give the Skill a clear name — "Q2 Variance Analysis" or "Beneficiary DQA Check" — and a short description so team members know when to use it.
On Team and Enterprise plans, Skills can be shared across your organization's Claude workspace. Field MEL officers, enumerator supervisors, and program staff can all access and run the same standardized analysis.
Skills are shareable on Team and Enterprise plansAny team member opens the Claude panel in Excel, clicks the Skills tab, selects the saved Skill, and runs it. Claude applies the full analytical workflow to the current workbook in seconds.
No prompting required — Skills run consistently every timeComplex MEAL databases with multiple linked tabs, conditional formulas, and inherited structures are prone to errors that can silently corrupt your indicator calculations. Claude can trace any error to its source in seconds.
| Error Type | Common M&E Cause | What Claude Does | Example Prompt |
|---|---|---|---|
#REF! | A row or column was deleted that a COUNTIFS or VLOOKUP referenced in the indicator tracker | Traces the broken reference chain, identifies what was deleted, proposes a corrected formula | "Cell D14 shows #REF! — trace the broken reference and give me the corrected formula" |
#VALUE! | A text entry in a numeric column is preventing a SUM or calculation from running | Identifies the non-numeric cell(s) causing the error, explains how to clean the data or wrap with IFERROR | "Why is G145 returning #VALUE! and how do I fix it without disrupting the rest of the model?" |
#DIV/0! | Percentage completion formula divides by a target cell that is blank or zero for a new indicator | Wraps the formula with IFERROR or IF(denominator=0,"—",formula) to handle zero-division gracefully | "Fix the #DIV/0! errors in the % completion column without removing the formula logic" |
#NAME? | A formula uses a named range that was deleted, or a function name has a typo | Identifies the undefined name or typo, corrects the function name, or recreates the named range | "Column F has #NAME? errors — find the cause and provide the corrected formulas" |
| Circular Reference | A formula accidentally references its own cell, often in budget models with cumulative totals | Traces the circular dependency chain, explains which cells form the loop, and proposes a restructured formula | "Excel is warning about a circular reference in the Budget tab — trace it and fix it" |
| Wrong Results (No Error) | COUNTIFS criteria range and sum range are different lengths after adding new beneficiary rows | Audits the formula logic against the data structure, identifies the mismatch, and corrects the range references | "The total in D5 looks wrong — it should be around 1,200 but shows 847. Check the formula logic" |
These best practices help evaluators and MEL practitioners get accurate, reliable results from Claude for Excel — especially on complex multi-tab MEAL workbooks.
Before starting a Claude session, rename tabs from "Sheet1" to descriptive names like "Beneficiaries", "Indicators", "Budget". Claude references tab names in formulas — clear names prevent confusion in complex workbooks.
For formula explanations and error fixes, click the specific cell before typing your question. Claude reads the active cell and uses it as context — this gives far more precise answers than describing the formula in text.
Before asking Claude to make changes across the workbook, save a backup copy. For critical MEAL databases, maintain version-controlled file naming — "MEAL_DB_v3_2026-04-13" — before each Claude session.
For new analytical workflows, test Claude's approach on a small sample of rows before applying to your full dataset. Verify the logic is correct before running across thousands of beneficiary records.
After Claude updates formulas or aggregates data, spot-check the totals against a manual count or known figure. Claude cannot access your MIS or database — totals depend entirely on what is in the spreadsheet.
Before using Claude for Excel on beneficiary databases, check your organization's data protection policy. Remove or anonymize personally identifiable information — names, national IDs, GPS coordinates — from files used in Claude sessions.
Ensure your MEAL data tabs have clear, descriptive header rows in Row 1. Claude reads headers to understand the data structure — tabs without headers lead to ambiguous and sometimes incorrect formula generation.
When you find a Claude prompt that produces exactly the right output for a recurring task — quarterly report, DQA check — save it as a Skill immediately. This converts one good analysis into a permanent team asset.
After analyzing MEAL data in Excel, keep the Claude panel open and switch to Word or PowerPoint. Claude carries context across apps — you can ask it to draft the findings section based on the Excel analysis you just completed.
EvalCommunity offers 41 specialist M&E AI agents, a 200-prompt M&E Prompt Library in RCTOF format, AI Governance Toolkit, and a full AI in M&E learning series — all built for monitoring, evaluation, and learning professionals. Visit evalcommunity.com to explore the full toolkit.
Sign Up & To Get My Free Referral Toolkit Now: