4 Prompts That Turn Any Csv Into an Excel Dashboard (claude in Excel Tutorial)

Learn four copy-paste prompts that turn a raw CSV into a clean, visual Excel dashboard using Claude in Excel. You will import a dataset, have Claude inspect and clean it, then generate summary tables, conditional formatting, and charts. The cleaning pass can take a minute or two depending on the data, and the dashboard-building step takes about five minutes.

• Analysts and operations teams who spend the first hour of a project cleaning data
• Founders and managers who receive CSV exports but are not Excel power users
• Students and researchers working with messy public datasets

You will build a polished Excel dashboard from a raw CSV, with reusable prompts you can apply to other datasets.

• Cleaned and structured workbook data
• Summary tables based on the most useful metrics
• Conditional formatting for top and bottom performers
• Two to three labeled charts on a Dashboard tab
• A reusable set of four prompts for future CSV files

The workflow starts from messy CSV-style data like this and turns it into a dashboard.

• Microsoft 365 with Excel on desktop, web, or Mac
• A Claude Pro, Max, Team, or Enterprise plan for the Excel add-in
• A CSV file, such as your own data, a client export, or a public dataset

• Try the same four prompts with your own data from a CRM, accounting tool, ad platform, or another source.
• Build template workbooks for recurring team use, such as monthly reports, client dashboards, or inventory tracking.
• Have Claude convert a finished dashboard into a template so you can reuse it every cycle with fresh data.