ع
Learn Tracks Reference Guides Saved
build recipe

Build a basic dashboard

Take a spreadsheet of numbers and turn it into a simple web page with charts you can open in your browser — no coding, no terminal.

easy ~15 min

you'll end up with A single web page that shows your key numbers as charts, runnable on your own computer.

The steps

  1. Open your data folder in Claude Desktop

    Make a new folder, drop your CSV or spreadsheet export inside it, then open that folder in the Claude Desktop app so Claude can see the file.

    paste this to Claude
    I just opened you in a folder with a file called sales.csv. Take a look and tell me what columns and data it has.

  2. Describe the dashboard you want

    In the chat, tell Claude what numbers matter to you and what kind of charts you'd like. Plain language is enough.

    paste this to Claude
    Build a simple HTML dashboard from sales.csv with three things: total revenue this month, a line chart of revenue over time, and a bar chart of revenue by region. Keep it a single self-contained file I can open in my browser.

  3. Review the new file and open it

    Claude creates the file — review it in the visual diff and accept it, then double-click it to open it in your browser and see the charts.

    paste this to Claude
    Open the dashboard file you just created and walk me through what each chart is showing.

  4. React like you would with a designer

    Look at the page, then ask for changes in the chat. Claude edits the file and shows you the diff — accept the ones you like.

    paste this to Claude
    The bar chart colors are hard to read and I want the totals bigger at the top. Adjust it.

  5. Refresh it later

    Next month, swap the new CSV into the folder and ask Claude to regenerate — or save the steps as a recipe so it's one instruction.

    paste this to Claude
    I've replaced sales.csv with the new month's data. Rebuild the dashboard the same way.
tips & best practices
  • Ask for a single self-contained HTML file — it opens in any browser with nothing to install.
  • Describe the numbers that matter to you; don't accept whatever charts Claude picks by default.
  • Sanity-check one total against your spreadsheet before you trust the whole dashboard.
  • Once it looks right, save the steps as a command so next month is a one-word refresh.

Questions people ask

Do I need to install anything to build this?
Just the Claude Desktop app — no terminal, no coding tools. You drop your spreadsheet into a folder, open that folder in Claude Desktop, and ask. Claude builds a single self-contained HTML file that opens in any browser with nothing else to install.
Do I need to know how to code?
No. You describe the numbers that matter and the charts you'd like in plain language, then ask for changes the way you'd talk to a designer — "make the totals bigger," "these colors are hard to read." Claude writes the code; you review the result in the file pane.
What if a chart looks wrong or a total seems off?
Sanity-check one total against your spreadsheet before trusting the whole dashboard. If a number's off, the data or the column mapping is usually the cause — ask Claude what it counted, and tell it the right column.
Can I refresh it next month without redoing everything?
Yes. Replace the spreadsheet with the new month's data and ask Claude to rebuild it the same way — or save the steps as a slash command so the refresh is a single word.