My Story AI Challenge Free Guides Get the free kitFree kit
← All free guides
PromptSet up ClaudeFree guide

Turn a Messy Spreadsheet Into a Dashboard With Claude Code

Most people keep a sheet of sales or leads that nobody can read at a glance, and they scroll it every time they need a number. This one prompt has Claude Code clean a copy, ask what you care about, and build a dashboard you open with a double click.

2 to copy4 steps4 min read
Zach CrawfordA free guide by Zach Crawford
Claude Code
Turn the spreadsheet in this folder into a dashboard I can open in my browser.
Rules:
- Never change my original file. Work on a copy.
- First, look at the file and tell me in plain words what's in it: the columns, how many rows, and anything messy (blank rows, dates written in different ways, the same name spelled two ways, numbers saved as text). Don't fix anything yet.
The whole prompt is in this guide. One click copies it.

This is the start of a real prompt from this guide. It is not a result.

You have a sheet. Sales, leads, clients, whatever you track. It works, but you can't read it. Every time you need a number, you scroll, filter and add it up in your head.

A dashboard fixes that: your main numbers big at the top, a few charts, and a table under them.

You don't need a dashboard tool for this, and you don't need to learn formulas. Claude Code can build one from the sheet you already have.

1Put your sheet in a folder

Make a new folder on your computer. Export your sheet as a CSV or an Excel file and put it in that folder. In Google Sheets: File, Download, then Comma Separated Values (.csv).

Open the Claude desktop app, switch from Chat to Code at the top, and pick that folder.

Use a copy of your sheet, not your only one.

2Paste the dashboard prompt

Copy and paste this
Turn the spreadsheet in this folder into a dashboard I can open in my browser.

Rules:
- Never change my original file. Work on a copy.
- First, look at the file and tell me in plain words what's in it: the columns, how many rows, and anything messy (blank rows, dates written in different ways, the same name spelled two ways, numbers saved as text). Don't fix anything yet.
- Then ask me up to 3 short questions: what this sheet tracks, the 3 numbers I care about most, and how I want it split (by month, by product, by person). Wait for my answers.
- Clean the copy. Tell me every fix you made and how many rows it touched. If you can't tell what a messy cell means, list it and ask me. Never guess a number.
- Build one file called dashboard.html: my 3 numbers big at the top, 2 or 3 simple charts, and a table under them. It has to open with a double click, with no internet and nothing to install.
- At the bottom of the dashboard, show the totals you used and how many rows they come from, so I can check them against my sheet.
- Save the steps as a script in this folder, so next time you can rebuild the dashboard from my updated sheet in one step.

When it's done, tell me where the file is and how to rebuild it when I add new rows.

It tells you what it found, asks its questions, then builds the file. Open dashboard.html with a double click.

3Check the numbers

Pick one total on the dashboard and check it against your sheet. One is enough to know it read the sheet right.

If a number is off, tell it which one and what it should be. It will find the rows it read wrong.

4Next time, it's one line

When you add new rows, put the updated sheet in the same folder with the same file name, and paste this:

Copy and paste this
I added new rows to my sheet. Rebuild dashboard.html the same way, and tell me what changed in my 3 main numbers.

The limitations you should know

Want the next guide? Follow @zachcrawford.ai

More free guides