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
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:
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
- It's a snapshot. The dashboard shows the sheet as it was when you built it. It doesn't update on its own.
- It can only clean what it can understand. If a cell is unclear, it should ask you. If it didn't ask and a number looks wrong, check that row.
- Keep private sheets private. Anything in the folder is read by Claude. Take out columns you don't need, like card numbers or home addresses, before you start.
- A very big sheet takes longer. Start with one tab.
- Tested on a Mac with a CSV file.
Want the next guide? Follow @zachcrawford.ai
