opening csv-files

  • Thread starter Thread starter spoefi
  • Start date Start date
S

spoefi

Hi,

When I double-click a .csv file, Excel opens, but the .csv-file doesn'
open correctly. Excel doesn't see the comma's as delimiters. I don'
even get the 'text-import wizzard' to ask me how I want to open th
file.

Strangly enough, sometimes it does open correctly and sometimes i
doesn't. It depends on who is sending me the file.

Question:
1. If such a file does not open correctily by doubleclicking or b
File/Open/ text-files... How can I open it correctly?
2. Is there somewhere a setting on a pc which influences this all? Wh
can i open some .csv files from one person's computer and not fro
another one's?

thank you,
spoef
 
Hi

In Control Panel, under Regional Settings, there is a List Separator field.
AFAIK, this is what determines what the delimiter is.
If you rename the file to a TXT, you can use the Text Import Wizard to gain
more control over how the file is imported by Excel.
 
spoefi,

If you rename the file to have a .txt extension, then the import wizard will
start up when you try to open it. Use Excel's file open dialog instead of
double-clicking the file.

HTH,
Bernie
MS Excel MVP
 
Back
Top