How to Merge Multiple XLS/XLSX Files into One Sheet? Best Techniques

Approved By Anuraag Singh

Published On September 24th, 2025

Reading Time 5 Minutes Reading

Category Excel File, How to

Do you have two or more XLS / XLSX files and you are not able to manage them all, and now you want to merge XLS files into one sheet? If it sounds right, then this is the right blog. Here you will get every possible detail with a step-by-step process to combine XLSX files into one worksheet. Read the complete article first and then choose the best method for your help.

XLSX and XLS are popular file extensions created by the Excel application. Both formats are mainly used to store data in columns and rows for better organization. But managing multiple XLSX and XLS files is not an easy task for anyone.

So, merging them is the best and efficient way to organize all XLSX and XLS files in one place without switching from one data file to another. Without wasting more time, let’s start the process to merge XLS files into one sheet.

How to Combine XLSX Files into One Worksheet?

You can easily merge multiple XLSX and XLS files into one sheet using the copy and paste method, using a VBA Macro, with Power Query, or as a manual method. And in case you are not capable of following manual techniques, then you should go for an alternate tool, which allows users to combine multiple files in bulk.

Quick Solution to Merge Multiple XLS Files into One

In case you have multiple data files and you don’t want to download the Excel application, then go for the SysTools Excel Merge Tool. This is the reliable and best way to merge XLSX files into one easily. Download the free version now.

Download Now Purchase Now

#1: Using the Copy and Paste Method

Open your source XLS/XLSX file.
Copy data from here.
Now open the destination file.
And paste all the copied data here.

#2: Combine All XLSX Files using Excel’s Power Query

Re-open your data files.
Choose the “File” tab and then “Date” >> “Get Data” options.
Select the XLSX/XLS files to merge.
Select the “Combine and Load” options.
Finally, this query will merge XLS files into one sheet.

#3: Merge XLS Files into One Using VBA Code

Launch the “VBA Editor” using the “ALT + F11” keys in the file.
Select the “Insert” >> “Module” options.
Now use the mentioned 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
And hit the “F5” key to run the script to combine XLSX files into one sheet.

#4: Automate Solution to Combine XLSX Files into One

The SysTools Excel Merger Tool is the perfect solution to merge XLS files into one sheet without losing any data. It is beneficial for those users who don’t have installed Excel application installed and have multiple XLS and XLSX files to merge. This software helps users a lot with advanced features and settings.

It supports all types of XLS and XLSX files exported from any version, including all the latest versions. There is no need to repeat similar steps for each file, because it supports combining multiple bulk data files to combine.

How to Merge XLS Files into One? All Working Steps

Download the software and start it on your system.
Choose the “Merge Excel” option from the screen.
Add your single and multiple files/folders to the panel.
Locate the path of your XLS and XLSX file and choose the “Open” button.
All your data files will show here, and choose the “Next” button.
Select the “Merge Options” as per need, and also select the path to save the file.
Hit the “Merge” button to start the process, and after completing, select the “OK” button to merge XLS files into one sheet.
Select the “View Report” button to open the selected location with merged data files.

What are the Major Capabilities of this Tool?

It can easily combine multiple XLSX files into one sheet in bulk at the same time, without following the same process on repeat for each file.
Provides two options to merge all data in a single tab, one by one, or in a single file by separate by tabs according to your choice.
This software is capable of maintaining all the original data and components.
Also, it doesn’t change anything in the original data file, which makes it more trustworthy for experts.
No internet or other connection required, because it works in offline mode, which makes your data safer and more secure.

Time to Say Bye

If you are also one of those who are unable to manage multiple XLS and XLSX files and want to merge them, then this is the right blog for you. Here we have explained the best and possible ways to merge XLS files into one sheet. Users can go for the manual method for one or two XLSX/XLS files.

And in case you have multiple data files, then they should choose the automated solution. This is the best and reliable way to combine XLSX files into one worksheet. Also, you can go for the trial version first. And for any query, you can contact us.