实现如题所述操作的方法如下:
如图所示,将TXT文本文件中的数据用空格或制表符按行列分隔开。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8ad4b31c8701a18b6ccd0502992f07082838fe5d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如图所示,打开Excel工作表,切换至“数据”选项卡,单击“自文本”按钮,打开“导入文本文件”对话框,单击选取要导入的文本文件,单击“导入”按钮关闭对话框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/241f95cad1c8a786581e5d436009c93d70cf5042?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如图所示,启动“文本导入向导”,“合适的文件类型”点选“分隔符号”,单击“下一步”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fd039245d688d43f210b86bf7a1ed21b0ff43bd8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如图所示,依据第一步的设置,勾选分隔符号,本例勾选“Tab键”,单击“下一步”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48fe53cb693f71f3a292df57821?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如图所示,根据实际分别单击数据列,设置“列数据格式”,最后单击“完成”按钮关闭对话框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f31fbe096b63f62475ca2e4e8044ebf81b4ca3e3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如图所示,打开“导入数据”对话框,设置数据放置位置,单击确定按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4d086e061d950a7bfaea59890dd162d9f3d3c9a4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
结果如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c995d143ad4bd113b714a07f5dafa40f4afb05a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)