Build a Dashboard and Data Story With Claude Data

Import a shop's monthly numbers into Claude Data, build a dashboard you can edit, and draft a data story you've checked before you share it.

  • Beginner
  • 8 steps
  • 2 resources
  • By The Rundown University

You'll build a Claude Data dashboard from a made-up shop's monthly numbers, edit it yourself and through Claude, roll a change back, and draft a data story you've checked against the file. Claude Data is on paid plans only (Pro, Max, Ultra, Team and Enterprise), and Import a file works on screen but isn't in Anthropic's help page yet, as of November 16, 2026.

Resources 2

Start from the exact files used in this guide instead of rebuilding them from scratch.

Unlock with Pro

$29 a month, cancel anytime

Step by step 8 steps

  1. Step 1 of 8

    Open Claude Data and import your file

    Open Data from the Artifacts tab and attach your file on its start page. Nothing gets built yet: you're giving Claude the numbers to work from.

    Actions

    • In claude.ai, click Artifacts in the left sidebar. If the sidebar is hidden, open it with the panel icon at the top left.
    • Under Make something new, click the Data tile (pink, with a bar chart). A new chat called Untitled dashboard opens straight away.
    • Under "Where do your numbers come from?", click Import a file (the card that says CSV, Excel, or JSON). Leave Use a connector alone.
    • In your computer's file picker, choose fernhill-candle-co-monthly.csv and open it.
    • Check that the file sits in the Reply box as a card with a CSV tag, and that Dashboard is the selected tile under "Choose a format." on the right.
    The Claude Data start page. The left side asks Where do your numbers come from? with two cards, Use a connector and Import a file, above a Choose design system menu and the Reply box. The right side says Nothing here yet and Choose a format, with Dashboard selected.
    Import a file is the lower of the two cards under "Where do your numbers come from?", and Dashboard is already selected on the right.

    Further explanation

    Anthropic's help page and its November 10, 2026 announcement only mention warehouses and connected apps as sources, so the Import a file option may move or change. If your own numbers are messy, tidy them into one clean table before you import.

    If it didn't work

    • There's no Data tile under Make something new: Free doesn't include Claude Data. On Team or Enterprise, ask an owner to turn it on in Organization settings > Artifacts (Enterprise turns it on by default on November 20, 2026 unless an owner already saved a setting).
    • The start page has no Import a file option: Start a normal chat, attach the CSV with +, and ask for a dashboard there. Anthropic's help page says you can ask for one in any chat.
    • Your file won't attach: The card lists CSV, Excel or JSON. Save other formats (Numbers, Google Sheets) as CSV or Excel first.
    • An empty Untitled dashboard chat is sitting in Recents: Clicking Data makes a chat right away. If you clicked twice, delete the spare one from Recents.

  2. Step 2 of 8

    Ask Claude for a dashboard

    Send one prompt that says who the dashboard is for and what they want to know. Claude builds it in a few minutes and opens it on the right.

    Actions

    • Paste the dashboard prompt into Reply, under the attached file, and press Enter.
    • Wait while Claude builds it, and keep the tab open. Ours took about four minutes; a published test on November 13, 2026 took about six.
    • Read the top of the dashboard: the summary line under the title, the red-bordered THE ONE CHANGE WORTH KNOWING callout, and the Latest month cards.
    • Note Updated 1 min ago at the top left. It's when the dashboard's data was last refreshed.
    • Scroll down to Last 12 months for the three charts: Revenue by month, Orders by month and Refunds by month.
    Claude Data with the chat on the left and the Fernhill Candle Co. monthly performance dashboard on the right: the title, a summary line, a callout about the July refund spike and three cards for the latest month. A small toolbar at the bottom holds an arrow, a pencil, a speech bubble and Ask Claude.
    Look for the summary line under the title and the red-bordered callout below it; in our run (Opus 5.5, November 16, 2026) they gave $193,010 from 4,834 orders and July's $2,187 in refunds.

    Dashboard prompt

    Build a dashboard for the owner of Fernhill Candle Co. from this file. Show monthly revenue, orders and refunds for the last 12 months, and put the one change worth knowing at the top.

    Further explanation

    Anthropic's tip is to say what you want to know, not only what to chart. Our prompt named the reader and asked for the one change worth knowing, and the dashboard opened with a summary line and that callout. Claude writes each dashboard fresh, so your wording will differ from ours, but every figure should match the file. The dashboard is saved in your Artifacts tab.

    If it didn't work

    • The dashboard is just charts with no summary at the top: Ask again, naming who it's for and what you want to know, not only what to chart.
    • You hit a usage limit partway: Claude Data counts toward your plan's usage limits. Wait for the limit to reset, then reply "carry on" in the same chat.
    • Your own file came in as one long column: It's probably split by semicolons. Save it as a comma-separated CSV and import it again.
    • Claude made a story or summary instead of a dashboard: Check that Dashboard is the selected format before you send, or reply "Make this a dashboard".

  3. Step 3 of 8

    Open a chart's query

    Every number on the dashboard comes from a query you can open. Finding one now shows you where to check figures in step 8.

    Actions

    • Point at the first (tallest) bar in Revenue by month, December 2025. The card reads Dec 2025, Revenue: $24,786, while the axis only says $25K.
    • Click the Sources icon (a stack of discs, the last of the three icons at the top right, after Design and History). Linked numbers get a dotted underline and charts a dotted outline.
    • In the Sources list, click Last 12 months, with refund rate. The time beside it (2m ago in our run) is when it last ran.
    • Read the line under its name that says what it counts, then click Result. You can skip the Formula code.
    • Check the table: each month's orders, revenue and refunds, unrounded. December's revenue reads 24786, the same as the hover card and your file.
    • Click the back arrow, then the X, to close Sources.
    Result expanded under the query: a table with the columns month, orders, revenue and refunds, from 2025-12 (612, 24786, 412) down to 2026-08, and 12 rows below it.
    Result lists the exact values from your file, one row per month, with 24786 as December 2025's revenue.

    Further explanation

    Anthropic says each chart shows its query and when its data was last refreshed. The bottom of the Sources panel also shows Refresh data (On each visit). That re-runs queries against connected sources; it won't pick up a newer copy of your spreadsheet.

    If it didn't work

    • Your Sources list has different names: Claude names each query itself. Point at an entry and the chart it feeds gets a dotted outline.
    • A query isn't counting what you meant: Tell Claude in the chat what to change, for example which column to use.
    • The Formula code makes no sense to you: You don't need it. Open Result and compare its numbers with your file.

  4. Step 4 of 8

    Edit the title yourself

    You can change a title, caption or chart on the page without asking Claude. Here you retitle the dashboard by hand.

    Actions

    • In the toolbar at the bottom of the dashboard, click the pencil (Edit the page). Everything you can change gets a light box.
    • Click the title at the top of the page. It opens in a purple edit box with a small B, I and link toolbar under it.
    • Select the old title and type Fernhill Candle Co.: your year in numbers.
    • Click Save in the bar above the title. Its tooltip reads "Make this change live for everyone with access".
    • Check that the light boxes go away and the title shows your new words. A tick and Saved may show at the top for a moment first. The name in the header above doesn't change: that's the artifact's name, kept apart from the title.
    The new title, Fernhill Candle Co.: your year in numbers, in the purple edit box with the B, I, link and Ask Claude toolbar under it. Above it, a bar with undo, redo, an X and a dark Save button with a 1 on it.
    Save, with a 1 for your one unsaved change, sits in the bar above the title next to undo, redo and X.

    If it didn't work

    • Clicking the title does nothing: Turn on the pencil (Edit the page) first. The arrow next to it is for using the page.
    • You typed something you don't want: Before saving, use undo or the X in the top bar to throw the change away.
    • The header at the top still shows the old name: That's the artifact's name, kept separately. The title on the page is what changed.

  5. Step 5 of 8

    Ask Claude to change a chart

    For bigger changes, ask Claude in the chat. One specific request makes it easy to see what Claude did.

    Actions

    • Paste the change prompt into Reply on the left and press Enter.
    • When Claude finishes, look at the new first chart, Revenue and ad spend by quarter, and read Claude's reply beside it.
    • Note the two faded bars marked Partial quarter in the legend: Q4 2025 is only December, and Q4 2026 only October and November.
    • Look at the label over the Q2 '26 bar: $45K. Then point at the bar. The card reads Q2 2026, Apr 2026 - Jun 2026, Revenue: $44,998. Quote the card, not the label.
    • Check that your title still reads Fernhill Candle Co.: your year in numbers. In our run Claude kept it and said so.
    Claude Data with the Fernhill Candle Co. dashboard open after Claude's change: the chart now reads Revenue and ad spend by quarter. At the top right of the dashboard, under Share, sit three icons: a palette, a clock and a database.
    The labels over the bars are rounded, $45K over Q2 '26, and the two faded bars are the partial quarters.

    Change prompt

    Group revenue by quarter instead of by month, and add ad spend as a line on the same chart.

    Further explanation

    Anthropic's own examples are the same kind of request: add a filter for region, or change to a weekly view. Orders by month and Refunds by month stay as they were unless you ask, and in our run Claude offered to switch them to quarters as well.

    If it didn't work

    • The last quarter looks like a big drop: It's only October and November so far. The faded bar is labeled Partial quarter.
    • The ad spend line hugs the bottom of the chart: It shares the dollar scale with revenue. Ask Claude to give ad spend its own scale on the right; it offered this in our run.
    • Claude changed more than you asked, or undid your title: Say what to leave alone and ask again, or go back to the earlier version in step 6.

  6. Step 6 of 8

    Roll back with version history

    History keeps earlier versions of the dashboard. You'll restore the version from before Claude's change, then restore Claude's again, so you can see that restoring loses nothing.

    Actions

    • Click the History icon (a clock) at the top right of the dashboard, between Design and Sources.
    • Click the version from before Claude's change, the one below Current. It opens as a read-only preview with a banner across the top and Back to latest.
    • Click Restore at the bottom right of the panel. The monthly Revenue by month chart comes back, and the restore appears at the top of History marked Current. Your new title stays: this version already has it.
    • Click Claude's quarterly version in the list (Today at 1:31 PM in our run; your times will differ). The banner reads "You're viewing an earlier version" with the date and time, then "with today's data."
    • Click Restore again. The quarterly chart is back, and this restore gets its own entry at the top too.
    • Close History with the X.
    A preview of the 1:31 PM version. A banner over the dashboard reads You're viewing an earlier version (Nov 16, 1:31 PM) with today's data, with a Back to latest button, and the chart shows Revenue and ad spend by quarter. The History panel shows Today at 1:31 PM, Edited the page, index.html, and a dark Restore button at its bottom right.
    Restore is the dark button at the bottom right of the History panel, under the banner that says you're viewing an earlier version.

    Further explanation

    Anthropic says a restore brings the dashboard back to that version for everyone who opens it and goes into History as its own entry, so every earlier version stays in the list. In our run the hand-edited title didn't get an entry of its own; it showed up inside a later version.

    With History or Sources open, the chart prints exact labels ($44,998, Q2 2026). Close the panel and they round again ($45K). The numbers don't change.

    If it didn't work

    • History says "No versions yet": Make one change through Claude (step 5), then open History again.
    • The preview didn't change your dashboard: Previews are read-only. Click Restore to bring that version back, or Back to latest to leave.
    • There's no Restore button: People with view-only access can't restore. Ask the owner to restore it.

  7. Step 7 of 8

    Have Claude draft a data story

    From the same file, Claude can write a Scrollyteller: a scrolling story with a chart that changes as you read. Treat it as a draft you'll check in step 8.

    Actions

    • Paste the story prompt into Reply and press Enter.
    • Wait a few minutes (about five in our run). Claude says it'll write a new page so your dashboard stays as it is, and a new card appears in the chat.
    • Read the first section on the right: the headline, the subtitle with the months covered, and Twelve months at a glance.
    • Scroll slowly through What changed this year. The chart stays in view and changes for each part.
    • Read The month that stands out (July's refunds) and What these numbers can't tell us, down to The one thing to do next.
    The finished story beside the chat. Headline "Fernhill Candle Co.: a steady year, a strong autumn, and one bad July", then "THE YEAR" and "Twelve months at a glance": $193,010 from 4,834 orders. On the right, a "Revenue by month" bar chart labelled $24,786 for December and $21,882 for November.
    The story opens on its headline and Twelve months at a glance, with the Revenue by month chart held on the right; ours (Opus 5.5, November 16, 2026) quoted $193,010 from 4,834 orders.

    Story prompt

    From the same numbers, draft a Scrollyteller data story for the owner of Fernhill Candle Co. Cover what changed this year, the month that stands out, and what these numbers can't tell us.

    Further explanation

    Asking what the numbers can't tell is what made our story list its limits, such as why the July refunds happened and whether the shop made money. For a short narrated video instead, ask for a Visual short: change "draft a Scrollyteller data story" to "make a Visual short". We didn't make one in our test, so check its narration against the file the same way as the story.

    If it didn't work

    • Claude edited your dashboard instead of making a new page: Restore the dashboard from History (step 6), then ask for "a new Scrollyteller page".
    • The story says something your file can't back up: It's a draft for you to review. Ask Claude to cut that line or reword it as a question.

  8. Step 8 of 8

    Check the numbers before you share

    A story sounds just as sure when a figure is wrong. Check three figures against the answer key, read one claim twice, and find Share without using it.

    Actions

    • Open the answer key: total revenue $193,010; best month December 2025, $24,786; refund spike July 2026, $2,187.
    • On the story, click the Sources icon, then Figures quoted in the story, then Result if it's closed. total_revenue should read 193010.
    • Find Share at the top right of the story, but don't click it now. The cards in the chat read Data · Only you, so nothing is shared yet.
    • Use the back arrow in Sources, click Monthly store figures (the entry with the file icon), then Show more. The description ends "Kept fixed so the story's words match its numbers."
    • Close Sources and check the story's December ($24,786) and July ($2,187) figures against the key.
    • Read the July section again. "Something went wrong with what was sold or shipped that month" is a guess: the story's own limits say the file has refund totals, not reasons.
    • In the chat, click the dashboard's card to open it, and check its summary line ($193,010) and callout ($2,187) against the key.
    The Figures quoted in the story query open in the Sources panel, with Result expanded: total_revenue 193010, total_orders 4834, first_month 2025-12, last_month 2026-11, and 1 row.
    Under Result in Figures quoted in the story, total_revenue reads 193010, the $193,010 on your answer key.

    Further explanation

    Anthropic says Claude drafts stories and narrated videos for you to review before sharing. In one published test, 116 of 118 figures were right and the two misses were chart labels off in the last digit. In another write-up, a creator's Visual short of YouTube stats put one video format's average at 197% across every video, but 135% without the single best one: one outlier can carry an average. The lesson "Fluent isn't the same as true" in our How AI Works course covers why fluent writing can still be wrong.

    Everything starts private to you. Testers found that anyone you share a file-built dashboard with can see the file's data, so keep private columns out.

    If it didn't work

    • A chart label is a little off from your file: Labels can round, like the $45K over Q2 '26 in step 5. Quote the hover card or the query's Result, never the label.
    • A figure doesn't match the file at all: Open its query to see what it counts, then tell Claude which column or months to use.
    • Your own file has columns you wouldn't show a viewer: Delete them from the file, import it again and rebuild. Testers found that whoever you share with can read the file's data.
    • You updated the spreadsheet and nothing moved: The dashboard works from a fixed copy. Import the new file in the same chat and ask Claude to update the dashboard.

That's the whole workflow

Mark it complete to keep your progress. The background and common questions follow.

Keep learning with Rundown Pro

Guides stay free. This is what Rundown Pro adds:

  • Every course and recording
  • The Rundown Certified Operator program
  • Member perks

$29/mo, cancel anytime

Background and context

Before you start

  • A paid Claude plan. On Team or Enterprise, an owner may need to turn Claude Data on in Organization settings > Artifacts.
  • claude.ai in a desktop browser.
  • The practice file, fernhill-candle-co-monthly.csv, and its answer key (download both from this page), or your own small CSV with nothing private in it.

Frequently asked questions

Anthropic says Claude Data needs a connector. Will a file really work?

Yes, as of November 16, 2026. The Data start page offers Import a file (CSV, Excel, or JSON), and this guide was made with it. Anthropic's help page and announcement only mention warehouses and connected apps, so the option may move. If it's missing, attach the file in any chat and ask for a dashboard.

Does my dashboard update when my spreadsheet changes?

No. A dashboard built from a file works from a fixed copy, and the file's entry in Sources says "Kept fixed". Refresh data re-runs queries on connected sources, not on your upload. Import the new file in the same chat and ask Claude to update the dashboard. If the numbers must stay current, use a connector instead; the earlier Claude Dashboards tutorial here connects a Google Drive file, under the beta name.

Who can see it when I share it?

Everything starts private, marked Only you. On Pro, Max and Ultra, Share offers Only you or Anyone with the link. On Team and Enterprise, Share offers Only people invited, Anyone at your organization, or Anyone with the link if an owner allows it. Most link-shared artifacts open without a Claude account. Testers found that anyone who can open a file-built dashboard can see the file's data, so keep private columns out. We didn't open the Share dialog while testing, so read its wording before you pick.

Which plans include Claude Data?

As of November 2026: Pro, Max, Ultra, Team and Enterprise, not Free. It counts toward your plan's usage limits like the rest of your work with Claude. On Team it's on by default. On Enterprise it turns on by default on November 20, 2026 unless an owner already saved a setting. Owners manage it in Organization settings > Artifacts.

What happened to Claude Dashboards?

That was the beta name, from October 2026. On November 10, 2026 it became generally available as Claude Data, and dashboards you already made keep working. They're in your Artifacts tab.

What are certified queries and live sharing?

Two beta features for connected data. Certified queries are ones your data team has approved; Claude can reuse them, and charts built on them carry a badge. Live sharing lets the people you share with see results from your connections even without access to the source, and you turn it on per connector in the Sources menu with Your access. Both are on by default on Team and off on Enterprise. Neither applies to an imported file.