How to combine multiple excel sheets data into one sheet 2026

combine multiple excel sheets data into one sheet today and You will be able to combine multiple excel sheets into one main sheet after reviewing this post. This Tutorial will make you an expert.

When you have two excel sheets of data and want to combine them into one sheet, we will tell and explain this scenario. There are occasionally happened that every department in an organization collects the data which they need. For example, the accounting department of an organization collects data for salary purposes.

Table of Contents

How to combine multiple excel sheets data into one sheet?

An establishment department collects every type of data for file maintenance. When you are asked to combine the data into one sheet and file then what you will do. We are here to explain combining them to gather.

Let’s, assume that the accounting department excel file contains the column of Sr#, name, father name, Cnic, date of birth and bank account number of all the employees. Same way, the establishment branch contains the data in an excel file like sr#, file number, name, father name, CNIC, department, employee number, cell number, emergency cell number and permanent address. you can combine multiple excel sheets data into one sheet

How to combine multiple excel sheets data into one sheet

Now, you have to ask to combine this information into one sheet or file. If you are an expert on excel formulas, you will start to complete the task. But if you are new in the field, first search for it before starting. You are here because you have the same situation or maybe for learning purposes. Whatever the purpose of learning it, our purpose is to tell you the process of combining the two excel files into one file. Also, learn how to type by voice and from a video and audio voice.

I am also not an excel expert but do the excel tasks in seconds. For this purpose, I will use the Microsoft excel plugin named kutool for excel. This is a small plugin that supported all Microsoft Excel versions. There is no need of worrying, about what version of words you have installed into your computer.

It works on all the versions of excel. Kutool for excel has different functions compared to the excel built-in functions. You can do everything with ease by using this extended software application. It really extends the excel as well as your skills to do your task on time. Now, let’s start to combine multiple excel sheets data into one sheet file using the software. Download the Kutool for word.

How to combine multiple excel sheets data into one sheet?

If you already don’t have the application of kutool for excel into your system, click here to get and install it on your computer.
Now, open your Microsoft excel application and both department files. One file of the accounting department and the second file of the establishment department.
The account department file has six columns while the establishment has 11 columns.
The establishment file contains the 11 columns that are named A-K.
Now, you have to rearrange the column name of the Account file and should start from the next column like “L”. This file has 6 columns so, you have to put them in column L and onwards. Select all columns and cut them and select column L and paste them all.
Only one CNIC on both files should be on the same column. If your account excel file has the cnic on the D column, then cnic on the establishment file also should be on column D.
Now, you have made two files arrangement, the establishment file contains the column A to K while on another file contains L to Q column. It means that the account data will be shown thereafter combined.

combine multiple excel sheets data into one sheet

Now, copy the account file data and paste it into the establishment file below.
Now, select the whole first row by clicking on it.
Now, click on the Data tab and choose the filter button.
Now go to the CNIC column and arrange them A to Z.
All data will be arranged. You will see the color of the departments. These should be a different color after each. If you found the same color in two or more rows to gather, then consider it is the wrong CNIC found in the file. If this happened, it is better to find the duplicate and erase it.
Now, select the account data rows from the file.
Right-click and choose the cut command.
Now go to the top row and paste them at them.
Now, arrange data by color.
You will see that column 11 has one file data and the next columns of second file data.
You have successfully combined the two excel files into one file.

Conclusion:

Hope you learn Kutool techniques to combine multiple excel sheets data into one sheet. Kutool has other various functions to get expertise in excel. Share the post of combine multiple excel sheets data into one sheet with our friends.

You May Also Join Us On: