Viewing 1 to 2 of 2 items
Archive | Importing data RSS feed for this section

Easiest way to open CSV with commas in Excel

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  Full Article…