这里有两种方法,第一种是直接复制粘贴,不过如果遇到老版本的软件,则需要用到以下方法:
WORD表格数字需要先转成txt格式文本,然后在通过数据导入的方式导入Excel
例如将以下表格导入Excel
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/838ba61ea8d3fd1f08e4f6d4394e251f94ca5f6a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第一步:新建txt文件打开——复制表格文字到txt文件——关闭——保存
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/810a19d8bc3eb135709fe055af1ea8d3fc1f4487?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/b219ebc4b74543a9102bac2217178a82b901142f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第三步:widows默认——下一步
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd980c662373001213fb90e9170?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/50da81cb39dbb6fd3ce8b4c80024ab18962b37a8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第五步:设置分隔符(即用什么符号区分单元格,word复制过来的默认是tab建)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/11385343fbf2b21164d2d4a0c38065380dd78e64?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/b7003af33a87e950c48ba28219385343faf2b444?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/50da81cb39dbb6fd3f48b5c80024ab18962b37c8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)