CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this:
Turns out it was a regional setting issue;
Go into your control panel --> Regional Settings --> Advanced Settings and change your list separator to a comma.
Mine was set to semi-colon for South Africa after I changed to Windows 8. After I changed it to a comma, all my CSV's open correctly with Excel 2013.
Hope this helps.
Additional comment:
I used the same steps as Lèse majesté, but I also changed the Decimal symbol from a comma (,) to a fullstop (.) and it fixed my problem.
This is because, by Default, Windows 8 uses a comma as a Decimal symbol and Excel gets confused when it has to use both the characters as separator and Decimal symbol.
Revisions
- February 12, 2015 @ 16:53:39 [Current Revision] by admin
- February 12, 2015 @ 16:53:39 by admin
- February 12, 2015 @ 16:52:42 by admin
Revision Differences
| February 12, 2015 @ 16:52:42 | Current Revision | ||
|---|---|---|---|
| Content | |||
| Added: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | |||
| Added: <span style="color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 13.6960000991821px; line-height: 17.8048000335693px;">CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this:</span> | |||
| Added: </p> | |||
| Added: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | |||
| Added: <a href="http:// www.gentotech.net/wiki/wp- content/uploads/ 2015/02/p5BMK.png"><img alt="p5BMK" class="alignnone size-medium wp-image-709" height="457" src="http://www.gentotech.net/ wiki/wp-content/ uploads/2015/ 02/p5BMK-500x457.png" width="500" /></a> | |||
| Added: </p> | |||
| Added: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | |||
| Added: | |||
| Added: </p> | |||
| Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | ||
| Unchanged: Turns out it was a regional setting issue; | Unchanged: Turns out it was a regional setting issue; | ||
| Unchanged: </p> | Unchanged: </p> | ||
| Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | ||
| Unchanged: Go into your control panel --> <strong style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;">Regional Settings</strong> --> <strong style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;">Advanced Settings</strong> and change your list separator to a <strong style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;" >comma</strong>. | Unchanged: Go into your control panel --> <strong style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;">Regional Settings</strong> --> <strong style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;">Advanced Settings</strong> and change your list separator to a <strong style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;" >comma</strong>. | ||
| Unchanged: </p> | Unchanged: </p> | ||
| Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | ||
| Unchanged: Mine was set to semi-colon for South Africa after I changed to Windows 8. After I changed it to a comma, all my CSV's open correctly with Excel 2013. | Unchanged: Mine was set to semi-colon for South Africa after I changed to Windows 8. After I changed it to a comma, all my CSV's open correctly with Excel 2013. | ||
| Unchanged: </p> | Unchanged: </p> | ||
| Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | ||
| Unchanged: Hope this helps. | Unchanged: Hope this helps. | ||
| Unchanged: </p> | Unchanged: </p> | ||
| Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | ||
| Unchanged: <em style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;">Additional comment:</em><br /> | Unchanged: <em style="margin: 0px; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; background: transparent;">Additional comment:</em><br /> | ||
| Unchanged: I used the same steps as Lèse majesté, but I also changed the Decimal symbol from a comma (,) to a fullstop (.) and it fixed my problem. | Unchanged: I used the same steps as Lèse majesté, but I also changed the Decimal symbol from a comma (,) to a fullstop (.) and it fixed my problem. | ||
| Unchanged: </p> | Unchanged: </p> | ||
| Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 13.6960000991821px; vertical-align: baseline; clear: both; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; line-height: 17.8048000335693px; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> | ||
| Unchanged: This is because, by Default, Windows 8 uses a comma as a Decimal symbol and Excel gets confused when it has to use both the characters as separator and Decimal symbol. | Unchanged: This is because, by Default, Windows 8 uses a comma as a Decimal symbol and Excel gets confused when it has to use both the characters as separator and Decimal symbol. | ||
| Unchanged: </p> | Unchanged: </p> | ||
Note: Spaces may be added to comparison text to allow better line wrapping.
No comments yet.