原因:直接双击打开CSV格式的文件会让原本Excel中的数据格式设置发生错误,导致显示出现问题,但转换后数据是没有发生错误的。
解决方法(以Excel2016为例):
1、先打开EXCEL空白的表格文件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15cef2dd53e8b8003af33a87b224?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后点击“数据”选项卡中的“从文本/CSV”选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/95eef01f3a292df5e3a01ff4b2315c6035a873eb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、打开窗口找到保存好的csv文件,点击“导入”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/50da81cb39dbb6fd151956c70724ab18962b3794?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、Excel页面会弹出加载CSV格式的文件的窗口,点击右下角的转换数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ae51f3deb48f8c546bb576ce34292df5e1fe7fe9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、即可打开CSV格式文件的编辑器,在其中可以对文件数据进行编辑操作,空白单元格会显示null,但不影响使用。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7acb0a46f21fbe09da6970f565600c338744ad18?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)