Exporting a CSV file to Excel.

  • Thread starter Thread starter Geek
  • Start date Start date
G

Geek

Hi All,

Is there a way to export a CSV data into seperate cells for each item of
data between commas? When I export data all the information ends up in one
cell.
 
Do you mean importing? Bringing a .csv file into excel?

If yes, then if you're doing this manually, make sure your windows list
separator is the same character as the delimiter that you use in your .csv file.

In win98, I can check that windows list separator:
Windows start button|settings|control panel|Regional settings applet
Number Tab|at the bottom is "List Separator"

If you don't want to fiddle with this, you can rename your .csv file to .txt and
when you open it (file|open), you can specify that it's a delimited file and
specify your delimeter there.

(You'll get the same wizard if you just bring it into excel as one column, then
use Data|text to columns like Don suggested.)
 
Back
Top