If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
csv, how to set excel to auto load
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~ |
#2
|
|||
|
|||
csv, how to set excel to auto load
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~ |
#3
|
|||
|
|||
csv, how to set excel to auto load
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" wrote in message ... 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~ |
#4
|
|||
|
|||
csv, how to set excel to auto load
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 |
#5
|
|||
|
|||
csv, how to set excel to auto load
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 . |
#6
|
|||
|
|||
csv, how to set excel to auto load
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 |
Thread Tools | |
Display Modes | |
|
|