Turn any CSV into an Excel dashboard

1. Home
2. GPT / AI
3. Turn any CSV into an Excel dashboard

These copy-paste prompts will help you turn any raw CSV into a clean dashboard using Claude in Excel.

1. Import CSV into Excel, open Claude, and prompt: “View the data in this workbook. Tell me what this data is, what each column represents, and flag any problems with the structure or formatting. List the issues.”
   
2. Clean the data by prompting: “Fix every issue you identified. Remove any junk rows or metadata. Format numbers for human readability, and create proper tables with clear headers. Sort by the most important metric.”
   
3. For dashboard, prompt: “Create a ‘Dashboard’ tab. Identify 3-5 most useful metrics from this data and build a summary table for each. Rank the entries. Highlight the top performers in green and the bottom performers in red.”
   
4. For visualization: “Add 2-3 charts to the Dashboard tab that tell the story of this data. Pick the chart types that make the most sense. Make them clean, labeled.”

NHL 2022-2023 Data in CSV to test this out nhl_2223.csv