1️⃣ Install Claude in Excel
- Open Microsoft Excel
- Go to Home → Add-ins
- Search for “Claude by Anthropic”
- Install the add-in
- Open the Claude sidebar
2️⃣ Select the AI Model
Choose the latest model available (for example, Claude Opus 4.6).
3️⃣ Upload Your Data
Upload your data file to Claude. It supports:
- Excel files (.xlsx)
- CSV files
- Images
- PDFs
- Raw text datasets
4️⃣ Give a Clear Prompt
Example prompt used in the post:
I've uploaded my messy bank statement.
Categorize every transaction into:
income, business expenses, personal spending,
subscriptions, taxes, and transfers.
Flag recurring charges.
Calculate:
- total income
- total spend
- monthly profit margin
Highlight my top 5 spending categories.
Spot unusual or duplicate charges.
Create a clean Excel spreadsheet with:
- Summary tab
- Breakdown tab
- Charts
Claude will automatically:
- Clean the data
- Analyze transactions
- Create summaries
- Generate charts and dashboards
5️⃣ Refine the Analysis
If you want more insights, just prompt again in the sidebar.
Example prompts:
- “Show monthly spending trends.”
- “Create a pivot table for categories.”
- “Visualize expenses with charts.”
✅ Result:
Claude converts messy data into a clean dashboard with insights in Excel.
💡 Why this is powerful
AI tools like Claude can:
- Clean datasets
- Detect duplicates and anomalies
- Generate charts and reports
- Suggest formulas automatically
This lets users focus on understanding the data rather than writing complex formulas.
0 Comments