Exporting a CSV file to Excel.

[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.

 

[Don Guillett]

data>text to columns

 

[Dave Peterson]

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.)

 

[Geek]

OK I have it. Yes, I did mean import....need some coffee, it has been a long
day. Thanks.