Excel

How to Open Multiple Excel Files in One Workbook? Quick Methods

Are you frustrated with your multiple Excel files and want to open multiple Excel files in one workbook? If it sounds right, then you are on the right page blog. This blog has explained the best ways, the benefits of merging data files, manual methods, and expert solutions to combine all your files without losing data.

Microsoft Excel is a popular application for managing your data in rows and columns. And if you work regularly on Excel, then you may often situations where you have to manage multiple data files, and opening them one by one can be time-consuming and especially when you have to analyze and compare data.

So, if you open multiple Excel files in one workbook, it can save you time and make your organization better.

Before knowing the process, let’s have some knowledge about why users want to import multiple files.

How to Open Multiple Excel Files in One Workbook?

Yes, we can import multiple Excel files into one worksheet using the copy and paste method, the Move or Copy feature, Excel Power Query, use a VBA macro script, or use a perfect tool. All the methods are given below, step by step:

#1: Using the Copy and Paste Method

1. Open all your Excel files.
2. Select the source file and copy the content using the “Ctrl + A” and “Ctrl + C” buttons.
3. After that, head to the destination workbook where you manage the data.
4. Now, “Ctrl + V” option to paste the content.
5. And now repeat the process for each data file.

Cons

• This process will take a long time for a large number of files.
• Also, it contains a high chance of human error while doing the copy and paste process.

#2: Use Built-In “Move or Copy” Feature

Excel offers an in-built feature called Move or Copy, so you can use it to open multiple Excel files in one workbook. All the working steps are given below:

1. Open the Excel file you want to merge.
2. In any file, right-click on the sheet tab.
3. Choose the “Move or Copy” button.
4. Select the location to save the output file.
5. Now check the box of “Create a Copy” (if you don’t want to remove data from the original file).
6. Lastly, click on the “OK” button.
7. And now repeat the same process for each file.

Cons:

• This method is not good for bulk processing.
• Requires manual effort each time.
• Also, large data files may hang or crash.

#3: Open Multiple Excel Files at Once by Merging

If you have large and multiple Excel files and want to manage them in one workbook, then download the Excel Merger Tool. This is the only right, reliable, and trustworthy method to import multiple files without losing information.

This software can easily merge files as separate worksheets into a single file and merge all files into a single worksheet, so that users can select the option according to their requirements to open multiple Excel files in one workbook. Also, you can try the free demo version for better knowledge about the software, how it works.

How to View Two Excel Files Side by Side Vertically? All Steps

1. Firstly, download the software and install it properly on your system.
2. Choose the “Merge Excel” option from the screen.

   

3. Now import all files that you want to merge using the “Add Files” and “Add Folders” options.

   

4. Locate the file from your machine and choose the “Open” button.

   

5. All your files will appear on the screen; you can use the “Remove” buttons to remove any unwanted files from the uploaded data and choose the “Next” icon.

   

6. Select the “Merge Option” according to your choice and select the location using the “Change” button.

   

7. After all the settings, select the “Merge” button to start the process, and after that, select the “OK” button to open multiple Excel files in one workbook.

   

8. Hit the “View Report” button to open the selected location with the output data file.

   

#4: Use Excel Power Query (Get & Transform)

1. Firstly, save all your Excel files in one folder.
2. And open a new Excel spreadsheet.
3. Head to the Data >> Get Data >> From File and then “From Folder” options.
4. Browse and select the folder that contains your file.
5. Select the Combine and Load option to import data into one workbook.
6. Finally, Power Query will automatically merge the data.

Cons:

• Power Query must be enabled in all Excel 2010 and later versions.
• Technical knowledge required.
• Formatting may change during the importing process.

#5: Open Multiple Excel Files in One Workbook Using VBA

1. Open the VBA editor in the Excel file using Alt+ F11.
2. Select the “Insert” and then “Module” option.
3. Use the following code.
4. Now select F5 to start the process to open multiple Excel files in one workbook.

Cons:

• Basic VBA code knowledge required.
• This method will not work with large Excel files.
• This is not the right method for beginners to open multiple Excel files in one workbook.

Final Comment

Organizing data in multiple Excel files is not an easy task, and many users face issues. So don’t worry, this blog has discussed the methods for opening multiple Excel files in one workbook, with benefits, manual methods, and drawbacks, and an alternate solution to view two Excel files side by side vertically.

Manual methods are good for one or two data files, but if you have multiple files to merge then go for the expert solution. The mentioned solution is a trustworthy and highly recommended tool by experts.