How to combine excel files into one workbook

July 22, 2022
2.0K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

Spreadsheet generally is used worldwide and because of their various functions and program, it makes work very easy for this generation of people and every type of financial model can be performed under excel supervision. But due to the several excel files, it creates a harder situation to access data and this process takes a lot of our time. So to save our precious time we must aware of the easiest ways by which we can merge and combine excel files into one. There are several ways to combine excel files.

In this tutorial, we will find ways to combine excel files into one.

NOTE: To merge files there are several steps, which are below.

1) The first step is to open excel and there you will find many options on the top bar like this.

2) Second step is to pop up on the tools key where you will again find many options below like this.

3) Press on the split or merge option by which a new window will appear on the screen, in which you will ask regarding the split or merging of your file.

4) Click on the merge option you will be asked about the files you want to merge.

After clicking on the NEXT your selected files will be merged and ready to save in your respective folder.

How to combine Excel files using power query.

This is also a function of excel by which we can easily combine the excel files into one folder and Power query permits us to import and combine the information. It can likewise be utilized to import and join various successful records into one file.

In this function, several steps are used which are given below.

1) The First step is to copy all the files you want to merge and move them to the new folder.

2) The second step here which we follow is to go to excel and click on the data tab which appears on the top.

3) When you click on Split or Merge the option will again pop up between split and merge, click on the merge and select your files to merge so in that way you can easily combine excel files.

 How to Split Combined Excel files.

This function is also very relatable to the merge option because all the steps will be the same and in the last select the split and click on it.

In this function, there are several steps used.

1) The first step is to open excel and there you will find many options on the top bar like this.

2) Second step is to pop up on the tools key where you will again find many options below like this.

3) Press on the split or merge option by which a new window will appear on the screen, in which you will ask regarding the split or merging of your file.

4) when you click on the Split key again the window will open which will ask you to split the files you want to do and when to click the next button your files will be split.

By following all these steps, you can easily professionally split your files.

You can also find this feature in the latest excel versions 2016/2018/2019 spreadsheet, where you can easily find the right way to combine excel files.

Did you learn about how to combine excel files? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience