Claude
Best Claude Prompt for Excel & Data
Copy, customize, and use this Claude prompt for Excel & Data.
Intermediate
Why Claude?
Claude translates plain-language data questions into precise Excel formulas, explains the logic step by step, and flags common error sources — bridging the gap between what users want to see and what the spreadsheet needs to compute.
Prompt Template
<role>\nYou are a spreadsheet expert and data analyst helping a {{user_role}} solve an Excel problem.\n</role>\n<context>\nExcel version: {{excel_version}}\nSheet structure: {{sheet_structure}}\nData description: {{data_description}}\nDesired output: {{desired_output}}\n</context>\n<instructions>\n1. Provide the exact Excel formula(s) needed to produce the desired output.\n2. Break down each formula component with a plain-language explanation.\n3. Identify 2-3 common mistakes or edge cases that could break the formula and how to guard against them.\n4. If multiple approaches exist, show the simplest first, then the most robust.\n5. Where helpful, suggest a complementary formula or helper column that improves reliability.\n6. Format code blocks using triple backticks for easy copying.\n7. Close with a one-line summary of what the formula does in plain English.\n</instructions> Example Output
```excel\n=SUMPRODUCT((MONTH(Sheet1!A2:A10000)=MONTH(TODAY()))*(YEAR(Sheet1!A2:A10000)=YEAR(TODAY()))*(Sheet1!B2:B10000=E2)*Sheet1!D2:D10000)\n```\n\nBreakdown:\n- MONTH(...)/YEAR(...): filters rows matching current month and year\n- Sheet1!B2:B10000=E2: matches the region listed in cell E2 on Sheet2\n- Final term multiplies matched rows by revenue\n\nEdge cases: blank rows return 0 (safe); text in Col D causes #VALUE — add ISNUMBER() guard if data is inconsistent.\n\nAlternative (SUMIFS, simpler): ...\n\nPlain English: Sum all revenue where the region matches and the date falls in today's month.
Make it yours
Your Generated Prompt
Prompt copied! What's next?
Got your AI output? Make it better.
Paste what Claude generated into Coda One and keep the next rewrite or cleanup pass in one browser flow.
Tips for Better Results
Paste 5-10 rows of real data (anonymized) directly into the prompt. Claude will reference actual column positions and catch type mismatches that abstract descriptions miss.
Example (filled in)
user_role=finance analyst, excel_version=Excel 365, sheet_structure=Sheet1 has transaction data: Col A=Date, Col B=Region, Col C=Salesperson, Col D=Revenue; Sheet2 is a summary dashboard, data_description=thousands of rows of daily sales transactions, desired_output=total revenue per region for the current calendar month that updates automatically