Claude 101(5) — 4 Prompts That Turn Any Spreadsheet Into a Clean Dashboard With Claude in Excel

Learn 4 copy-paste prompts that turn any messy CSV into a clean, visual dashboard inside Excel using Claude. No formula knowledge required.

Claude 101(5) — 4 Prompts That Turn Any Spreadsheet Into a Clean Dashboard With Claude in Excel

In this guide, you will learn 4 copy-paste prompts that turn any messy CSV — your monthly expenses, a workout log, an event guest list — into a clean, visual dashboard inside Excel, using Claude in Excel.

Required Tools: Claude Max + Microsoft Excel
Updated: May 2026

Overview

Most people open a CSV, take one look at the messy columns, and close it again. Cleaning, summarizing, and charting data in Excel takes hours if you don't know formulas — and even more hours if you do. Claude in Excel changes the math: paste 4 prompts in order, and Claude does the cleaning, the math, and the charts for you. We tested these prompts on a household monthly-expense CSV and a hobby running log. They work on anything. Import your data, paste the prompts, let Claude do the rest.

Who This Is Useful For

People who track personal finances or household budgets but never get past the "messy CSV" stage

Hobby trackers (runners, readers, gamers, gardeners) who want a real dashboard from their data

Students, researchers, and small business owners working with public datasets or exported reports

What You Will Build

A polished Excel dashboard with summary tables, conditional formatting, and 2–3 charts — built entirely by Claude from a raw CSV. You'll walk away with 4 prompts you can reuse on literally any dataset, every month, forever.

Example outcomes from real users:

A monthly household budget dashboard with category totals, top expenses, and a spending trend chart

A 12-month running log dashboard with pace, distance, and consistency metrics

A small-shop sales dashboard built from a Shopify export

What You Need

Microsoft 365 with Excel (desktop, web, or Mac)

A Claude Pro, Max, Team, or Enterprise plan (the Excel add-in requires one of these)

A CSV file — your own data, a bank export, or any public dataset

30 minutes (most of which is Claude doing the work in the background)

Step 1: Install the Add-In and Import Your Data

Open Excel, click Add-ins in the top ribbon, then Get Add-ins. Search for Claude and install it. The Claude button will appear in your ribbon. Click it and log in.

Next, open your CSV file in Excel. If it opens as a flat file, save it as a workbook (.xlsx). That's it for setup.

Step 2: Prompt 1 — Explore the Data

Open the Claude pane in Excel and paste this prompt:


Look at all the data in this workbook. Tell me what this data is,
what each column represents, and flag any problems with the
structure or formatting. List the issues.

Claude will scan every row and column, then come back with a plain-English breakdown of what your data is, what each column means, and what's wrong with it.

This is the most important step. It forces Claude to understand the data before it starts building anything. Everything after this gets better results because Claude already knows what it's working with.

If Claude gets confused about something (like abbreviations or date formats), just answer its questions in the chat. A one-line clarification goes a long way.

You don't need to tell Claude what kind of data this is — it figures it out on its own.

Step 3: Prompt 2 — Clean and Structure

Paste the next prompt:


Fix every issue you just identified. Remove any junk rows or
metadata. Format numbers so they're human-readable. Create
proper tables with clear headers. Sort by whatever the most
important metric is.

Claude will remove junk rows, reformat numbers (turning 10250000000000 into "$10.25T"), build a proper table with headers, and sort by the metric that matters most.

This step can take a minute or two depending on how much data you have

You can watch Claude work in real time as it edits cells

If it flags something you disagree with (like renaming a column), just tell it to skip that one and fix the rest

Step 4: Prompt 3 — Build the Dashboard

Paste prompt 3:


Create a new "Dashboard" tab. Identify the top 3–5 most useful
metrics from this data and build a summary table for each.
Rank the entries. Use conditional formatting to highlight the
top performers in green and the bottom performers in red.

Claude creates a new tab and builds summary tables based on whatever metrics it thinks matter most. For a household expense file it might pick monthly totals, top categories, and year-over-year change. For a running log it might pick longest run, fastest pace, and consistency.

Claude sometimes puts dashboard content in the wrong tab. If that happens, just tell it: "I noticed some dashboard tables ended up in the raw data sheet. Can you move everything to the Dashboard tab?"

This step takes about five minutes. You can let it run in the background while you do other things.

Step 5: Prompt 4 — Add Charts

Paste the last prompt:


Add 2–3 charts to the Dashboard tab that tell the story of
this data. Pick the chart types that make the most sense
(bar, line, scatter, etc.). Make them clean and labeled.

Claude picks chart types based on the data. For an expense file it might build a line chart showing spending over time and a bar chart comparing categories. For a running log it might make a bar chart for monthly distance and a scatter plot for pace vs distance.

Charts are a newer feature in Claude for Excel. They work, but Claude sometimes hard-codes source data and hides the rows, which breaks the chart. If your charts look blank, unhide the rows above or below them.

You may need to drag charts around or resize them. The data is right, the layout just needs a nudge sometimes.

Going Further

Try it with your own data. Export a CSV from your bank, your fitness app, your e-commerce store, or whatever you use. Run the same 4 prompts. No changes needed.

Build template workbooks for your team. Monthly reports, client dashboards, inventory tracking. Have Claude build the dashboard once, convert it to a template, and reuse it every cycle.

Layer in narrative. Add a final prompt: "Write a 3-sentence summary at the top of the Dashboard tab explaining what this data shows." Now your dashboard tells a story, not just shows numbers.

Key Takeaways

Here's what you learned in this guide:

4 prompts, in order, on any CSV. Explore → Clean → Build Dashboard → Add Charts. Reusable forever.

Step 1 (Explore) is the most important. Forcing Claude to understand the data first makes every later step better.

Always back up your data. Claude edits cells directly. Duplicate the original into a second tab before starting.

Let Claude pick the metrics and chart types. It's usually right — and you can always ask it to change one.

Turn the result into a template. One extra prompt makes the workbook reusable for next month, next quarter, forever.

No formula knowledge required. If you can paste prompts, you can build dashboards.

Claude 101(5) — 4 Prompts That Turn Any Spreadsheet Into a Clean Dashboard With Claude in Excel