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

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

4 ай бұрын

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

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

@ReadySteadyExcel

7 ай бұрын

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

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

@ReadySteadyExcel

5 ай бұрын

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

Great tip.Saved my time.

@ahb0102

5 ай бұрын

Thanks a thousand .

@ReadySteadyExcel

5 ай бұрын

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

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

thankyou

@ReadySteadyExcel

11 ай бұрын

Thank you for watching 😎

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

@ReadySteadyExcel

3 ай бұрын

thank you very much 😊

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

8 ай бұрын

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

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

11 ай бұрын

Challenge accepted!!

@lil2633

10 ай бұрын

Out here looking for same 😢

@bobbishmurda1232

10 ай бұрын

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

10 ай бұрын

Also looking

@karthickd6845

9 ай бұрын

Me also

Which excel version we need for this?

@ReadySteadyExcel

9 ай бұрын

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

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

@ReadySteadyExcel

9 ай бұрын

Great question. I will have a look

@ankurzweb8149

8 ай бұрын

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

@ReadySteadyExcel

8 ай бұрын

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

@ankurzweb8149

8 ай бұрын

@@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