Combine Multiple Excel Files into one!

[@ReadySteadyExcel]

Get the Excel files to follow along with this video...
readysteadyexcel.thinkific.com/courses/ready-steady-files

[@dwbarcl]

Thank you so much for such a simple straight forward video with instructions. You SAVED me so much time trying to combine 5 files into one with over 70,000 lines.

[@ReadySteadyExcel]

You're very welcome. Thank you for the amazing feedback. Happy to have helped and you found my video 😊😊😊

[@sangeethvaheesan3173]

Brilliant, was pondering for days how to do and this saved me at work❤

[@ReadySteadyExcel]

This is great to hear! Glad you found my video 😊😊😊

[@ahb0102]

Great tip.Saved my time.

[@ahb0102]

Thanks a thousand .

[@ReadySteadyExcel]

@@ahb0102 great to hear this! Thank you very much 😊😊😊

[@anthonybello172]

Thanks man you just saved my ass at work with 32K of cells from 10 files

[@ReadySteadyExcel]

Thanks for feedback....Happy to hear that I've helped save you time and frustration 😊

[@suvendubiswas3978]

I am not getting 'get data's options in the data tab. Kindly help

[@calmpups]

Great video. I'm running Microsoft Excel for Mac V 16.66 and not able to select the folder containing the files to use. Is that a Mac issue or user error?

[@ReadySteadyExcel]

Sorry to hear this. I don't have access to a Mac to be able to check this.

[@utubepremium9557]

thankyou

[@ReadySteadyExcel]

Thank you for watching 😎

[@kbenefits]

perfect 1-2-3 explanation. i wish i could give you 10 likes.

[@ReadySteadyExcel]

thank you very much 😊

[@mozark.hiker_]

Why isn’t there a single video on the internet that’ll show me how to merge multiple files into one workbook on SEPARATE sheets

[@ReadySteadyExcel]

Challenge accepted!!

[@lil2633]

Out here looking for same 😢

[@bobbishmurda1232]

import os
import pandas as pd
# Set the directory where your Excel files are located
source_folder = r'FILE PATH HERE'
# Get a list of Excel file paths
excel_files = [os.path.join(source_folder, file) for file in os.listdir(source_folder) if file.endswith('.xlsx')]
# Create a target workbook
target_path = 'merged_workbook.xlsx'
with pd.ExcelWriter(target_path, engine='openpyxl') as writer:
for file in excel_files:
df = pd.read_excel(file)
sheet_name = os.path.splitext(os.path.basename(file))[0] # Use filename as sheet name
df.to_excel(writer, sheet_name=sheet_name, index=False)
print("Merging complete. Saved to:", target_path)

[@robynbaker6697]

Also looking

[@karthickd6845]

Me also

[@lakshaydhouchak3695]

Which excel version we need for this?

[@ReadySteadyExcel]

Excel 365 but it was available from the previous version as well

[@karthickd6845]

How to get all the Excel files in different sheets in a single file.

[@ReadySteadyExcel]

Great question. I will have a look

[@ankurzweb8149]

I am also looking for this solution. Please let me know if you find it😊

[@ReadySteadyExcel]

@ankurzweb8149 I have the solution just need to make the video. Will record and publish soon

[@ankurzweb8149]

@@ReadySteadyExcel I have 25 files which I need to show in separate tab in one excel file.
Can you share steps at least if possible🙂. please