Open an SCV file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On some computers, if I open the *.csv file it opens correctly in Excel as I
import it in Excel, but on other computers I have to open the Excel and
import data... *.csv file.

Please tell me if there is an option in Excel to set this.

Many thanks,

Ciprian SABAU
System Engineer & Network Administrator
BUNGE Romania
 
It sounds like an international setting difference. English versions of excel,
..CSV files mean comma separated values.

I think I would look at one of the offending pc's.

Create a new worksheet in a new workbook and add some test data.

Then File|SaveAs
scroll down until you see the equivalent of comma separated values.
Note what excel expects as the extension. (I'm guessing that it's different for
that pc/language.)

Then close that file without saving.

Rename the .csv file to that extension and try it out.

=====
If you see .csv as the extension, maybe someone/something stole the .csv file
association from excel.

Maybe you can set it back with this:

Close Excel (both instances) and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 
Back
Top