A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

csv, how to set excel to auto load



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2009, 10:35 PM posted to microsoft.public.excel.misc
Gina_Marano
external usenet poster
 
Posts: 3
Default 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  
Old November 16th, 2009, 10:41 PM posted to microsoft.public.excel.misc
Bob I
external usenet poster
 
Posts: 10,698
Default 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  
Old November 16th, 2009, 11:38 PM posted to microsoft.public.excel.misc
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default 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  
Old November 17th, 2009, 01:27 AM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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  
Old November 17th, 2009, 03:14 PM posted to microsoft.public.excel.misc
CSV double-click for import
external usenet poster
 
Posts: 1
Default 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  
Old November 17th, 2009, 04:19 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.