A simple method of merging multiple Excel table files together

How to merge multiple Sheet from multiple table files into one table? Not yet, guys. Take a look. Today, Mr. Wang takes Excel2016 as an example to give you a detailed explanation.

Here are three Excel table files:

There are multiple Sheet worksheets in each table file:

Merge multiple workbooks and multiple worksheets 1, open a blank table, and then enter "data"-"get and convert"-"New query"-"from File"-"from folder". Enter the storage path of multiple table files in the pop-up "folder" and then "determine"-"convert data".

2. Select the useful columns, and then click "Home"-"manage columns"-"Delete columns"-"Delete other columns". You can delete useless columns.

3. Click "add column"-"General"-"Custom column", and enter the formula in "Custom column Formula":

Excel.Workbook ([Content], true)

4. Click the button next to "Custom", then "OK", and then click the button next to "Data" to "OK".

Click "Home"-"close"-"close and upload".

6. Now our merged data has been transferred to the table, but you may find that there seems to be some less data, it doesn't matter, we can click "Design"-"Refresh".

OK, now that we have merged multiple worksheets in multiple workbooks, just delete the useless columns.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi