published feb 5, 2026

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

beginner

Members get every guide, course, and $1,000+ in partner perks.

The Rundown

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.

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

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.

Choose the same timeframe for your data sources before asking Claude to combine them.

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.

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:

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.

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.

Prompt

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.

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

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

Prompt

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.

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

The Rundown

Who This Is Useful For

What You Will Build

What You Need

Going Further

Install Claude in Excel and gather your CSVs

Import your CSVs and ask Claude to clean the workbook

Ask Claude to recommend and build a master report

Add charts and turn the report into a reusable template

The Rundown

Who This Is Useful For

What You Will Build

What You Need

Going Further

Every workflow on Rundown University, free for 7 days