1、首先我们需要打开Excel,然后新建一个空白工作簿,选择工作簿里面sheet 1工作表任意单元格,如图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3d4fda2b4daaa1cd11728b2990?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、接着点击工具栏的“数据”-“现有连接”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f7246b600c338744abffe001410fd9f9d72aa091?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后就会在表格上弹出现有连接对话框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef4c1c675bedfaaf51f3de6691?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击现有链接之后,会弹出如图所示的界面,此时只需要在点击要插入的表格所在的本地文件夹即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f510fb30f2442a7073b32d8c143ad4bd1130292?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在导入数据的时候,我们只需选择“表”以及确定导入的位置即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b6006bfac0caf950352ac65cb793?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、将需要导入的表格导入以后的效果图;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0823dd54564e92584b0049938c82d158ccbf4e93?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、然后点击表格左下角的“+”新建名为sheet 2的工作表,接下来按照以上的步骤将剩下的那个工作表导入数据即可,这样就完成了将两个表格合并的目标了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fc1f4134970a304e89126f87c1c8a786c9175c9f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)