Prev: How to XML Map Repeating Rows?
Next: vlookup with 2 criteria or more
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
work)

Close excel
windows start button|run
excel /unregserver
then
windows start button|Run
excel /regserver

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

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2
Prev: How to XML Map Repeating Rows?
Next: vlookup with 2 criteria or more