如何在Excel 2013中正确显示.csv文件? [英] How to correctly display .csv files within Excel 2013?
问题描述
似乎Excel 2013没有正确读取CSV文件(Excel 2010)。每次打开.csv文件时,我的所有数据都显示在第一列。
It seems Excel 2013 doesn't read CSV files correctly (Excel 2010 does). Every time I open .csv files, all my data are displayed in the first column.
我知道我可以去 DATA
,转换
,然后选择逗号
,但此设置不会保存,
I know I can go to DATA
, Convert
, and then choose commas
, but this set up is not saved, and I am fed up doing this every time I open this kind of file.
如何设置Excel 2013,一劳永逸地显示CSV文件(逗号分隔)?
How can I set Excel 2013, once and for all, to display CSV files (comma separated) prettily?
推荐答案
使用像样的文本编辑器打开CSV文件,例如 Notepad ++ 并在第一行中添加以下文本:
Open the CSV file with a decent text editor like Notepad++ and add the following text in the first line:
sep=,
现在用excel再次打开它。
Now open it with excel again.
作为逗号,或者您可以将其更改为任何您需要的。
This will set the separator as a comma, or you can change it to whatever you need.
这篇关于如何在Excel 2013中正确显示.csv文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!