You have data in a spreadsheet. Your manager wants a dashboard. You don’t know how to code. Sound familiar?
This tutorial shows you how to use Claude Cowork to turn raw spreadsheet data into an interactive HTML dashboard — complete with charts, filters, and a clean layout — in under 30 minutes. No programming, no BI tools, no subscriptions. Just you, your data, and Claude.
What you’ll build
By the end of this tutorial, you’ll have a standalone HTML file that:
- Displays your key metrics as large, readable numbers
- Shows trends over time as line or bar charts
- Lets you filter by date range, category, or other dimensions
- Works in any browser — share it by email or host it internally
- Looks professional enough for a management presentation
What you need
- A Claude Pro or Max subscription (Cowork is required)
- The Claude Desktop app installed
- A spreadsheet with your data (Excel, CSV, or even just copied numbers)
Step 1: Prepare your data
Cowork can handle messy data, but you’ll get better results if your spreadsheet has:
- Clear column headers in the first row
- Consistent formats — don’t mix “Jan 2025” with “2025-01-15” in the same column
- No merged cells — these confuse parsers
If your data is in Excel, save it as CSV first. Or just copy-paste the relevant cells — Cowork handles that too.
Example data — let’s say you have monthly sales by product category:
Month,Category,Revenue,Units Sold
2025-01,Software,45000,120
2025-01,Consulting,32000,15
2025-01,Training,12000,45
2025-02,Software,48000,135
2025-02,Consulting,28000,12
2025-02,Training,15000,52
...
Step 2: Start a Cowork session
Open Claude Desktop and start a new Cowork conversation. Select the folder where your CSV file is (or where you want the dashboard saved).
Step 3: Describe what you want
Be specific. The more detail you give, the better the result. Here’s a prompt that works well:
I have a CSV file called sales-2025.csv with monthly sales data.
Columns: Month, Category, Revenue, Units Sold.
Build me an interactive HTML dashboard with:
1. KPI cards at the top: total revenue, total units, average monthly revenue
2. A line chart showing revenue trend over time (by month)
3. A bar chart showing revenue by category
4. A dropdown filter to select a specific category (or "All")
5. A table at the bottom with the raw data
Use Chart.js for the charts. Make it look clean and modern —
dark background, card-based layout. The whole thing should be
in a single HTML file that I can open in any browser.
Step 4: Let Cowork work
Cowork will now:
- Read your CSV file
- Write an HTML file with embedded JavaScript
- Include Chart.js from a CDN (no installation needed)
- Create the charts, filters, and layout
- Save the file to your selected folder
This typically takes 30-60 seconds. When it’s done, you’ll see the file in your folder.
Step 5: Open and review
Double-click the HTML file to open it in your browser. You should see your dashboard with live data. The charts are interactive — hover over data points for details, click legend items to toggle series.
Iterating on the design
Your first version probably won’t be perfect. That’s fine — this is where Cowork shines. You can iterate with natural language:
Change the colour scheme:
Change the chart colours to our company brand: primary #2A62FF, secondary #14468C. Make the background lighter.
Add a metric:
Add a KPI card showing month-over-month growth percentage for total revenue.
Change chart types:
Replace the bar chart with a stacked bar chart so I can see how each category contributes to the monthly total.
Add interactivity:
When I click on a month in the line chart, update the bar chart to show only that month's breakdown.
Each iteration takes seconds. Within a few rounds, you have something polished.
Real-world examples
Sales dashboard
The example above. Works well for any business tracking revenue, units, or transactions over time. Add filters for region, salesperson, or product line.
Project status board
Build a project dashboard from this CSV. Show: number of projects by status
(On Track, At Risk, Overdue) as coloured cards, a timeline chart showing
project start and end dates, and a table sorted by deadline.
Website analytics overview
Here's my Google Analytics export. Build a dashboard showing:
sessions per day as an area chart, top 10 pages as a horizontal bar chart,
traffic sources as a donut chart, and bounce rate trend as a line chart.
Financial reporting
Create a financial dashboard from this P&L data. Show: revenue vs expenses
as a grouped bar chart by month, profit margin as a line chart, and a
cost breakdown by category as a pie chart. Add a month selector.
Tips for better dashboards
Keep it focused. A dashboard with 3-4 well-chosen charts tells a clearer story than one with 15 charts crammed together. Ask yourself: what are the 3 things my audience needs to see?
Use the right chart type. Lines for trends over time. Bars for comparisons. Pies only when you have 5 or fewer categories (otherwise use a horizontal bar chart).
Label clearly. Ask Cowork to add proper axis labels, data labels on important points, and a title that explains what the viewer is looking at.
Consider your audience. A dashboard for your own analysis can be dense and detailed. A dashboard for management should be clean, with big numbers and obvious takeaways.
Limitations to know about
Data size. Embedding data directly in HTML works well for up to a few thousand rows. Beyond that, the file gets large and the browser may slow down. For big datasets, consider using a proper BI tool.
No live data. The dashboard shows the data as it was when you built it. It doesn’t auto-update when your spreadsheet changes. You’ll need to rebuild it with updated data.
Single file. Everything is in one HTML file — data, charts, styling. This makes it easy to share but means the data is visible to anyone who views the file source.
Browser-only. The dashboard needs a browser. It won’t work as a native app or embed directly in PowerPoint (though you can take screenshots).
What’s next?
- New to Cowork? Start with our beginner’s guide
- Want to automate the dashboard refresh? See our intermediate guide on scheduled tasks
- More things Cowork can do: 10 unexpected capabilities