Import .csv files to Excel

S

SteveW

Depends on the actual contents of the file.

If it's a genuine .csv ie comma seperated valus
it should work fine each time.

Steve
 
D

Dave Peterson

Does that mean each record in the .csv file goes into column A (A1, A2, ...,
A#)?

Or does this mean that all your data really go into A1?

If the data goes into separate rows in column A, verify that the list separator
that you specify in the control panel

Regional settings And language options|Regional options tab
customize button|Numbers tab

matches the delimiter used in the .csv file (use notepad to verify)

===
If all the data really goes into A1, then maybe there's a problem with the end
of line marker and the list separator???
 
Top