Uploaded June 2026 | Updated September 2026, 1 week ago

---

Download the Practice File ⬇️ - goodly.co.in/how-to-combine-multiple-excel-files-using-claude
youtu.be/0ZOY8is-bgY?si=kO2cdCM3EiIKbPRX
youtu.be/CfElHHuKY3s?si=dCctIAW-7btkQYHr


Combining data from multiple Excel files into one file is one of the most common data cleaning tasks. In this video, I test whether Claude in Excel can actually help with that using Power Query.

We start with a simple case where all files have the same structure, then slowly increase the complexity by changing column names and adding junk rows on top. At each step, I ask Claude to help, test the result, and explain where it works, where it breaks, and what you should watch out for.

If you are interested in data analysis using AI, data cleaning with Claude, using Claude with Excel, Claude with Power Query, or combining multiple Excel files automatically, this video will be useful.


===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book

✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?

✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi

✔️ Power Query Course -
products.goodly.co.in/learn-power-query

✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel


===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨‍🏫 - goodly.co.in/training
Need my help on a Project 💻- goodlyinsights.com
Download the Practice File ⬇️ - goodly.co.in/how-to-combine-multiple-excel-files-using-claude


===== TIMESTAMP =====
0:00 Intro
0:39 Level 1
7:40 Level 2
11:12 Level 3


===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!