How to Combine Several Excel Files into One Workbook?

Published By Aunraag Singh

Approved By Nimisha Ramesh

Published On August 27th, 2025

Reading Time 5 Minutes Reading

Are you also frustrated with multiple Excel files and want to combine them in one work sheet to manage data easily? Then you are not alone. Multiple users want to consolidate multiple Excel files into one workbook easily. This blog provides comprehensive information on the best and most effective ways, including manual methods and a quick solution.

Managing multiple large Excel files feels like trying to juggle too many balls at once. So, merging them is the best and easiest way to resolve this issue. But doing this is not as easy as we think, so let’s start the process. Stay tuned with us to combine several Excel files into one workbook.

Why Consolidate Multiple Excel Files into One Workbook?

Users can easily access all data in one place without opening multiple files, which makes the process easier.
Also, merging multiple files saves your time and energy from following the same process.
Minimize mistakes caused by handling multiple sheets.
After combining all files into one sheet, you can share it with others easily.

How to Combine Several Excel Files into One?

Yes, you can merge multiple Excel files into one sheet by copying and pasting data, using Excel Power Query, the Move or Copy feature, and using VBA code. Manual methods are suitable for one or two Excel files, but if you have large files and your Excel file is not opening due to its large size, then go for the expert solution.

#1: Consolidate Multiple Excel Files into One: Expert Solution

If your Excel file is not opening due to a large issue and you want to combine multiple files, then download the Excel Merge Tool. This software will combine several Excel files into one workbook without opening the files and losing any information.

This software has the power to support all types of Excel files from all versions. You just have to upload your files and choose the Merge Files option. It’s the first preference of all customers and experts, because it works without an internet connection. More steps and advantages are mentioned in the upcoming paragraphs.

How to Merge Multiple Excel Files into One Sheet? Tool Steps

Download and start the mentioned tool, and select the “Merge Excel” option.
Add your files and folders using the “Add Files” and “Add Folders” options and select the “Next” button.
Browse the location of your files and upload them by selecting the “Open” button.
All your files will appear with proper hierarchy, and hit the “Next” button.
And then select the required option between “Individual Worksheets” and “Single Worksheets” according to your requirements.
Select the Merge button and then choose the “OK” button to combine several Excel files into one workbook.
Lastly, click on the “View Report” button to open the default location with the merged file.

#2: By Copy and Paste Method

Open your source Excel file.
Copy the data from here.
And then open the destination Excel file.
Now paste the copied data here.

#3: Using Excel’s Power Query

Open your Excel spreadsheet.
Head to the “Data” >> “Get Data” from the “File” tab.
Browse and select the Excel files to combine.
Choose the “Combine and Load” icon to combine multiple Excel files into one worksheet.
Lastly, Power Query will consolidate data.

#4: Use “Move or Copy” Option

Open your Excel spreadsheet.
Right-click on the “Sheet” tab.
Select the “Move or Copy” icon.
Choose the path to save your file.
Also, check the “Create a Copy” option to keep data in the original file as well.
And finally hit on the “OK” icon.
Follow the same process again for each file.

#5: Combine Several Excel Sheets into One VBA Code

Again, open your file.
Choose “Alt+F11” keys to open the VBA editor.
Now choose the “Insert” >> “Module” options.
Now copy and paste the following code.

Dim Path As String
Dim Filename As String
Dim Sheet As Worksheet

Path = “C:UsersDellDesktopsample-data”
Filename = Dir(Path & “*.xlsx”)
Do While Filename <> “”

Workbooks.Open Filename:=Path & Filename, ReadOnly:=True

For Each Sheet In ActiveWorkbook.Sheets
Sheet.Copy After:=ThisWorkbook.Sheets(1)
Next Sheet

Workbooks(Filename).Close

Filename = Dir()
Loop
Lastly, hit the “F5” to start the process to consolidate multiple Excel files into one.

Drawbacks of All Manual Methods

Manual methods are not the right choice to combine multiple Excel files into one workbook.
Users have to follow the same steps and procedure for each file again and again.
High risk of losing data from rows/columns due to human error.
Basic technical knowledge about coding and Excel is required.
Formatting will not be maintained during the process to combine several Excel files into one workbook.

Why an Expert Tool to Consolidate Multiple Excel Files into One?

Expert solution provides multiple advanced features and filters, which make the solution the best and first choice of all users.

The software can merge large and open multiple Excel files without any size limit restrictions.
Dual options help users import single or multiple files and folders at once.
This amazing tool gives you two different options: Merge files as separate worksheets in a single file, and merge all files into a single worksheet. So that users can select any option according to their choice.
Also, you can choose any destination to save their output data file using the Change button to combine several Excel files into one workbook.
It supports all types of files like CSV, XLSX, and other Excel files from any version.

Final Comment

Here we have resolved the most searched query on the internet: how to combine several Excel files into one worksheet using manual methods and an expert solution. All manual methods are good for a limited Excel spreadsheet, and if your file is not opening or has multiple Excel files to merge, then you should go for the professional tool to consolidate multiple Excel files into one sheet. For any query, you can contact us anytime.