From: Dave Peterson on 17 Nov 2009 10:19
I would double check the windows list separator.
If that shows the comma, then I would try reregistering excel.
(A complete guess that shouldn't cause any trouble and may (probably???) not
windows start button|run
windows start button|Run
This resets a bunch of settings to factory defaults in the windows registry.
CSV double-click for import wrote:
> I am having the same issue. The csv file IS a true comma-separated file: it
> works fine if I use the import wizard from File/open. But if I double-click
> the csv file from explorer, it does not parse it out, it just puts it all in
> column 1. This happens on XP, Vista, and Windows7 with Office 2007. My
> regional settings are set to comma as the list separator.
> "Dave Peterson" wrote:
> > I'm gonna guess that the sender uses a different list separator on his/her pc
> > than you use on your pc.
> > You haven't shared what the sender used as a delimiter, but you could ask
> > him/her to change this windows setting (control panel|regional settings applet)
> > to what you use.
> > Or you could open the .csv in a text editor to see what was used--and then
> > change that windows setting, then open the file.
> > I'd do this only temporarily--since it's a windows setting, it'll affect other
> > things, too.
> > Personally, I wouldn't bother. I'd either import the text into that single
> > column and then select the column and do data|text to columns (delimited by that
> > character).
> > Or rename the .csv file to .txt and then use File|open (or its xl2007
> > equivalent) to open this file and step through the text to columns wizard.
> > Gina_Marano wrote:
> > >
> > > I want to double click on a .csv file and have it automatically load
> > > in to excel 2007.
> > >
> > > Currently it opens it and puts all the data in column A. If I close it
> > > and use data import all is fine.
> > >
> > > Ridiculous for people to send me .csv files. I have to save first them
> > > data import. Another way? Add-in?
> > >
> > > ~Gina_M~
> > --
> > Dave Peterson
> > .