CSV no se abre con formato de comma delimitados


Hoy me tope con el problema de que mis archivos CSV no se abrian con el formato de coma delimitados..
Despues de algunas busquedas en internet encontre este articulo que me sirvio para poder arreglar mi problema.
Fuente : http://www.paessler.com/knowledgebase/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this

Trouble With Opening CSV Files With Excel? The Comma and Semicolon Issue in Excel Due to Regional Settings for Europe

When opening standard CSV (Comma Separated Values) files in Excel you may find that Excel did not recognize the fields and simply displays all data in the first column.
The Problem
The standard field delimiters for CSV files are commas: ","
On American Windows versions, the comma is set as default for the "List Separator", which is okay for CSV files.
But on European Windows versions this character is reserved as the Decimal Symbol and the "List Separator" is set by default to the semicolon:  ";"

There are Three Solutions
Change the CSV file extension to TXT (when you open a TXT file with Excel it will start the text file import wizard where you can choose the delimiter)
-- or --
In your CSV file(s), use a text editor to replace all commas,with semicolons;
-- or --
Solution #3: Changing Regional and Language settings
In your Windows Control Panel, change your Regional and Language settings


The last solution is our preferred one. To change regional settings,
go to Start | Control Panel | Regional and Language Options
Click Additional Settings
For Decimal Symbol, enter a dot: "."
For List Separator, enter a comma: ","

Now, when you open a CSV file in Excel it will automatically find the data fields and open it appropriately.



Comentarios