csv, how to set excel to auto load
in [General]
|
From: Gina_Marano on 16 Nov 2009 16:35 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~
From: Bob I on 16 Nov 2009 16:41 have them send you REAL .csv files. CSV stands for "Comma Separated Values". 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~
From: Fred Smith on 16 Nov 2009 17:38 The problem is they are calling it a CSV file, but it's not. CSV files have values separated by commas. Yours does not. Regards, Fred. "Gina_Marano" <ginalster(a)gmail.com> wrote in message news:6fdba051-7198-4ac1-915b-3cb53a633b05(a)x6g2000prc.googlegroups.com... >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~
From: Dave Peterson on 16 Nov 2009 19:27 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
From: CSV double-click for import CSV double-click for on 17 Nov 2009 09:14
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 > . > |