2010-06-01

指定excel输出csv文件的分隔符 | Specify the separator in csv file outputted by Excel

Excel 导入csv文件时候可以指定分隔符,但是输出是没有明显的选项,只是txt用空格,csv用逗号。

查了一下,这个需要去控制面板,区域语言选项,“格式”标签选高级,在数字里面就可以调整分隔符了。

这个还真是不直观,太隐蔽了。。。




In Excel the separator can be specified when import a csv file using the wizard, but there's no such an option when exporting, the only choices are txt and csv, where the space and comma are used as separator respectively.

And I found on the Internet that, to change the symbol, go to the control panel, then "regional and language options". In the advanced options under the "format" tab, there's a "number" tab, where you can change the "list separator".

This option is hidden so well...