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
- When you copy and paste every branch’s or team’s Excel file into one each month
- When you need to combine the January through December files for a yearly total
- When the column order differs a little in each file and matching them up by hand is hard
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
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 4. Check the totals
Make it your own
- “Make a 3-slide PowerPoint with a monthly sales chart from the merged data”
- “Pull the vendor, amount, and date from the PDF quotes in this folder into one Excel sheet”
- If it happens every month: use a scheduled task to “merge them automatically on the 1st of every month”
Watch out for
- Always use a copy. And include “Don’t change the original files.”
- Don’t skip the final total check. It catches mistakes like rows that went missing or got added twice.
- If the files contain personal information (ID numbers, contact details), check your company’s rules first.
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.
💌 Get new tips by email
I'll email you when a new tip goes up. No ads, ever.