当需要进行数据处理时，需要将Excel的多个Sheet合并在一个Sheet中，便于查询、操作Excel表格。然而Excel内容十分多，Ctrl+C/V,会导致系统卡顿和闪退的情况。
 
 
如何实用Excel自带的合并工具实现多Sheet的合并呢？这里我们介绍**Excel**自带的**Power Query工具**和**Python代码**来实现多个Sheet合并。
 
 
# Excel自带Power Query工具：
## 情况1：合并一个Excel文件中的所有Sheet
 
1、打开Excel，点击【数据】-【获取数据】-【来自文件】-【从Excel工作簿】
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/92e9cbcb-4dd2-4579-9a7c-ceb00fa7aef4.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A43%3A34Z%2F-1%2F%2F83d36cf7910be72d1cd243ec48c4c5e8ed1d93cc0c6a9c74383c79f0dd60d6c1)
 
2、找到自己的工作簿文件，点击【导入】
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/3edf2068-38ca-4c25-8b64-1baacd556f36.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A43%3A40Z%2F-1%2F%2F04479b070dc576ed661b063eb72da30d8d37e954ffd7e9a72e3df457f2d876c0)
 
3、点击【工作簿】，也就是你的文件名，点击【转换数据】
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/55aa330b-0f59-4e51-8476-70b0a53d446e.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A43%3A48Z%2F-1%2F%2F69debeead8c2cc306b062f0c9235ff5e5a38a911e2c7ff21eada354927424fbc)
 
注意：必须是工作簿，如果点击sheet,后面的页面不会出来
4、筛选【Kind】，去掉不是Sheet行，点击【Data -|-】,展开所有列数据，点击【确认】（删掉不要的列和行数数据就行）
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/45c50ef6-bbb9-41c4-8d25-c61391bcbcb9.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A43%3A58Z%2F-1%2F%2F1652ef51b6799b5dc37184964fbdac130789d26e25a8c6e89208e6e7a2289779)
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/9486bd04-d71c-4084-b809-626fd3c45ed7.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A44%3A26Z%2F-1%2F%2F9479f00903a29a27c216829a3971fc55a343363b0fb974d73ea9fa700068254b)
 
 
5、点击【关闭或上载】，即可看到合并的整个数据。
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/c9917af4-b488-4432-94b8-ca6b5c601e69.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A44%3A33Z%2F-1%2F%2Fa3c28b83bca5c6e8e143bbb6a2cec9e9906605ebcd36fe9a8ecaf4bee894adc5)
 
 
## 情况2：合并多个Excel文件中的所有Sheet
 
1、把所有的文件都放在同一个文件夹下，示例：文件放在桌面的hh\hm文件夹下
 
``` language
  C:\Users\XX\Desktop\hh\hm
```
2、打开Excel，点击【数据】-【获取数据】-【来自文件】-【从文件夹】
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/3c716ce8-f740-4eb5-aebe-d52ce087eb07.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A45%3A17Z%2F-1%2F%2Fa78abc10074660ca02458d9188c155b5fe247c50af1a9d13633107a1a1e8385d)
 
 
3、找到自己的文件夹，点击【打开】
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/a526513d-834f-4315-8465-f2df914d073a.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A45%3A42Z%2F-1%2F%2Fcf4a16abca356e66acbdab00c5c05e8cd39c8129e8b54cfdd39bd3250b8270a5)
 
 
4、点击【组合】，选择【合并并转换数据】
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/90faf723-8ccd-4790-8695-139b21b28b57.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A45%3A52Z%2F-1%2F%2F834d0acc79a335e22e858dbdd694a5e062fc67a14198bb952e31c3aa8de8d876)
 
 
5、点击【第一个文件】，点击【工作簿】。注意不要点击下面的Sheet文件
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/58d61bd7-d275-492f-9fd7-1b1432a2b720.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A47%3A04Z%2F-1%2F%2F6fd1755ae7acfc8e3259c0b5333d72444fd23b87ca886ca16fb61c8edd08ace6)
 
 
6、筛选【Kind】，去掉不是Sheet行，只保留Sheet。点击【Data -|-】,展开需要展开的数据，点击【确认】（删掉不要的列和行数数据就行）
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/0045a870-9a8d-461c-958f-d76c6896a344.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A46%3A09Z%2F-1%2F%2F080ac561bb529a2484b4ce032a1a4b3f3f6538f785f925b601645d2191dc24ee)
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/872fe67f-23c7-4817-ac01-8030386d2731.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A46%3A31Z%2F-1%2F%2F6cb189f488b34d0c8556dd7d23f390d0114fdafa29d6672215b7b7a0cef0c88e)
 
7、根据自己的要求调整表格，点击【关闭或上载】，即可看到合并的整个数据。
 
![iLoveOFD](https://iloveofd-blog.gz.bcebos.com/v1/images/2025/12/12/3dd76d5c-3ac7-4e11-b068-d919d66dab74.png?authorization=bce-auth-v1%2FALTAKVxLKtGCoifupcdq32EQNg%2F2025-12-12T07%3A46%3A45Z%2F-1%2F%2Fcaaba88a7a3f725f5309842e4cc3ac15fd70678ad8343a33385028cb73d994d7)
 
 
```