← Ideas · ⚙️ Automation · Last checked: November 10, 2026

Merge dozens of Excel files into one

You can do this after: Intermediate

💻 This only works on a computer. You'll need Claude Code or the Claude desktop app.

In one line

Install the document skills in Claude Code (an official bundle of skills for working well with Excel, Word, PowerPoint, and PDF), and say “Merge these into one” in the folder with your Excel files.

When to use it

Follow along

Step 1. Install the document skills (just once)

Open Claude Code (claude) and type the two lines below, one after the other. They add the skills collection published by Anthropic (the company that makes Claude) and install its document skills.

/plugin marketplace add anthropics/skills
/plugin install document-skills@anthropic-agent-skills

When it’s done installing, quit Claude Code and start it again (/exit, then claude again).

Step 2. Open it in a copy folder

Copy the Excel files you want to merge into a “merge-excel” folder, and open Claude Code in that folder. Leave the originals alone.

Step 3. Ask it to merge them

Merge all the Excel files in this folder into one. Put the file name (branch name) in the first column, and line up columns that have slightly different names but mean the same thing. Make a summary sheet at the front with totals by branch and by month, and save it as “all-totals.xlsx”. Don’t change the original files.

Illustration (may look a little different from the real screen)

Merge all the Excel files in this folder into one. Put the file name (branch name) in the first column, and line up columns that have slightly different names but mean the same thing. Make a summary sheet at the front with totals by branch and by month, and save it as "all-totals.xlsx". Don't change the original files.

Sample replyI found 24 Excel files with 3,812 rows.
Columns matched: "Sales amount" and "Sales" → Sales; "Day" and "Date" → Date

I made all-totals.xlsx.
• Summary sheet: totals by branch and month
• All sheet: the 3,812 merged rows

downtown_march.xlsx has 5 rows with an empty date. [needs checking]

Step 3: it merges the scattered files into one and makes a summary sheet

Step 4. Check the totals

Check in a table that each file’s original total matches its total after merging.

Make it your own

Watch out for

I'm stuck here

Stuck while following along? Tell me where. Only the site owner sees this. Leave your email only if you'd like a reply.