csv, how to set excel to auto load

  • Thread starter Thread starter Gina_Marano
  • Start date Start date
G

Gina_Marano

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~
 
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.
 
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.
 
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.
 
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.
 
Back
Top