Thread: opening csv
View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Jo

Excel sees any file with the extension *.csv as a native file and tries to
open it straight away. Once in Excel you could parse it using DataText to
columns

Alternatively, remove the extension or replace it with .txt and Excel will
launch the text import wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Jo Segers" <Jo
wrote in message
...
If I doubleclick on a csv it opens in Excel but all the data is in one
column.
If I do the same on another pc the data is displayed correct.

Is this a setting and where can I change it?

MS Office 2000.