Turn a Two Hour Excel Slog Into a 10-Minute Task With Claude in Excel

In this guide, you’ll learn how to use Claude as a spreadsheet architect. You’ll take multiple messy CSVs and have Claude clean the data, format tables, color-code tabs, and turn the workbook into a useful dashboard. The source example used 7 unlabeled CSVs of SEO data and produced a dashboard in under 10 minutes.

  • Beginner
  • 4 steps
  • By The Rundown University

Step by step 4 steps

  1. Step 1 of 4

    Install Claude in Excel and gather your CSVs

    Install Claude in Excel from the Microsoft marketplace.

    Find 5–10 CSVs of data. You can use sales data, expense tracking, or anything else you report on each month.

    💡 Pro tip: Make sure you choose the same timeframe for your data sources.

  2. Step 2 of 4

    Import your CSVs and ask Claude to clean the workbook

    Open a new Excel workbook. Import each CSV as a new tab using File > Import > CSV. Make sure you select “comma” as the delimiter.

    Click the Claude logo in the top right, then start with this prompt:

    I imported [data type] data from [source 1] and [source 2] from my website. Can you rename all the tabs and reformat all the data in the sheet so that it’s more readable?

    Asking Claude if it can do the task can produce better results because it encourages Claude to explore the data, consider its capabilities, and come up with a plan. You can also explicitly ask Claude to make a plan.

    💡 Pro tip: You can tell Claude to color-code the tabs based on data source and create tables in each tab.

  3. Step 3 of 4

    Ask Claude to recommend and build a master report

    Prompting Claude to build the master dashboard is important. The best results came from first asking Claude to look at all the data and make a recommendation.

    What do you recommend doing to tie all this data together into a quick master report sheet?

    Claude can break the data sources into tables and write formulas to bring the data together.

    image-2037

  4. Step 4 of 4

    Add charts and turn the report into a reusable template

    Claude can also make charts from the data. Ask it to visualize each dashboard component.

    image-2038

    Once you’ve created a report you like, ask Claude to turn it into a reusable template:

    Adjust the Dashboard formulas to make this work as a template I can use each month by importing the data into each tab. Create a README tab explaining how to use the template.

That's the whole workflow

Mark it complete to keep your progress. The background follows.

Go further with Claude

This Rundown Pro recording covers the same tool or topic as this guide.

$29/mo, cancel anytime

Background and context

Who This Is Useful For

  • Consultants with clients who love spreadsheets
  • Team leads who want to standardize reporting processes across their organization
  • The “Excel person” on the team who spends the end of each month cleaning up formulas and tables

What You Will Build

You’ll build a cleaned, formatted Excel workbook that combines several raw CSVs into a master dashboard and can be reused as a monthly reporting template.

  • Renamed and reformatted worksheet tabs
  • Cleaned tables for each data source
  • A master report sheet that ties the data together
  • Charts for dashboard components
  • A README tab explaining how to use the template
image-2036

What You Need

  • Microsoft Excel
  • Any paid Claude plan
  • 3–10 CSVs of raw data
  • Optional: sales data, expense tracking data, SEO data, or another dataset you report on each month

Going Further

  • Use Claude for Chrome to log in to your CRM and export the source data for you.
  • Set this up as a recurring workflow to run at the end of each month so you can see trends over time.