Open a *.csv file?

J

Janepige

H

When I export a file from a database program as an *.csv file and open it in Excel all my data is included in one single column. This only happends when I use "," as a field seperator, but when I use ";" it seperates the data into different columns, which it's supposed to.
Can anyone tell me, where in Excel I can set up the field seperator to be a ","
Also, in my manual to my other database program, it is described how I should import the *.csv file into Excel to (chosing columns to different data etc.) but when I open a *.csv file it just opens it automaticly and I have no influence myself on how it is displayed

Regards
Jane
 
S

Stephen Bye

When opening a csv file, Excel uses whichever character you have defined in
the system Regional Settings control panel as the 'List Separator'
character.

Janepige said:
Hi

When I export a file from a database program as an *.csv file and open it
Click to expand...
in Excel all my data is included in one single column. This only happends
when I use "," as a field seperator, but when I use ";" it seperates the
data into different columns, which it's supposed to.
Can anyone tell me, where in Excel I can set up the field seperator to be a ","?
Also, in my manual to my other database program, it is described how I
Click to expand...
should import the *.csv file into Excel to (chosing columns to different
data etc.) but when I open a *.csv file it just opens it automaticly and I
have no influence myself on how it is displayed?
 
D

Dave Peterson

Stephen gave the location for that windows setting.

But if you rename your .csv file to .txt, then do File|open within excel, you'll
have control on what the delimiter is and how each field should be treated.
 
Top