Merge 1000 Workbooks into One Table with Excel

The original title: 10 Times Stronger than VLookup! It's the Strongest Tool for Merging Tables!

Here's a little question for you:

If you are now given 1,000 workbooks, and you need to merge all the data into one table, what would you do?

If you can't think of it for the moment, let's take a look at what I do first.~

1. Excel Novice

See how I type fast

Manual data entry is definitely the lowest efficiency way.

With 1,000 sheets, if you enter them like this one by one, it will take forever to finish. Not only is the efficiency low, but it is also a great harm to your health...

2. Excel Beginner

I'm the best at copy and paste

❶ Press 【Ctrl+A】key to select all the data;

❷ Press 【Ctrl+C】key to copy;

❸ Switch to another table and press 【Ctrl+V】key to paste.

However, Excel, which is called the 「data processing weapon」, how could it only have such efficiency?

3. Excel Expert

PowerQuery Merges with One Click

❶ Click 【Data】tab - 【Get Data】 - 【From File】 - 【From Folder】.

❷ Find the folder where the files are stored and click 【Open】.

❸ In the pop-up window, click 【Combine】, select 【Merge and Load】, select Table 1, and confirm.

After waiting for a while, all the data have been summarized into one table!

Easy, merge N tables at once!

What others need to struggle for hours, we can finish in one minute

This article is from the WeChat public account: Autumn Excel (ID: excel100), author: Zhu Lan