How to merge two excel files

Hello Tuan,

I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

If you have multiple Excel files with data that you want to merge into one file, there are several ways you can do this. One way is to use the Consolidate tool in Excel. This tool allows you to summarize data from multiple sheets or workbooks onto one sheet.

To use the Consolidate tool, open your target Excel file and create a new worksheet by pressing the + (plus) button next to the sheet tabs at the bottom of the window. In your new worksheet, click on the Data tab in the ribbon, then click Consolidate in the Data Tools group. In the Consolidate dialog box, select the function you want to use to consolidate your data (e.g., Sum, Average, etc.), then add the data ranges from each source sheet or workbook by clicking Add and selecting the ranges. Once you have added all of your data ranges, click OK to consolidate your data.

Another way to merge data from multiple Excel files is to use the Move or Copy Sheet tool. This tool allows you to move or copy worksheets between different Excel files.

You can select all of the worksheets in each source file and move or copy them into your target file. To do this, open your source Excel files and select all of the sheet tabs at the bottom of each window by holding down the Shift key and clicking on each sheet tab. Then, click on the Home tab in the ribbon, click Format in the Cells group, then click Move or Copy Sheet. In the Move or Copy dialog box, select your target Excel file from the To book drop-down menu, choose where you want to place your sheets in the Before sheet section, then click OK.

These are just two ways you can merge data from multiple Excel files. You can also write a VBA macro to automate this process or use other tools such as Get & Transform .

Please let us know if you need more help.

Best Regards, IBHADIGHI

Watch the videos below and choose the way you like.

Andreas.

Consolidate & Clean Multiple Excel Sheets in One Pivot Table - YouTube

Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube

Thks all for your qucik help

Hello Tuan,

You are welcome.

Best Regards, IBHADIGHI