BTC USD 49,461.9 Gold USD 1,787.56
Time now: Jun 1, 12:00 AM

Can't Open CSV file Correctly in Ms Excel

CSV (comma separated value) is extension file that used to store the data tables in plain text format. To open this type of file we usually use the Ms Excel.
If you have the CSV file, but can't be opened correctly in Ms excel ( no table, and difficult to read), here is the solution.

It is usually caused by the difference of standard number format, between CSV file and the Computer.
To resolve this problem in Ms Windows


Click Start -> Control Panel -> Language And Region
Click on Additional settings (at the format tab )

csv+11.gif

In the Columns : List separator, change from , (comma) to ; (semicolon) or from ; (semicolon) to , (comma)

csv+22.gif


Click OK
Now open the CSV file.

Comments

There are no comments to display.

Blog entry information

Author
SayaAndaKita®
Views
612
Last update

More entries in Others

More entries from SayaAndaKita®

Top
Log in Register