How does Excel make it's guess as to what type of file a CSV file is?

Giganews Newsgroups
Subject: How does Excel make it's guess as to what type of file a CSV file is?
Posted by:  tharpa (83433ai…@sneakemail.com)
Date: Tue, 1 Jul 2008

I have a CSV file (not created with Excel.)  If a user double-clicks
on the file, Excel wrongly guesses that it's not a true Comma-
Separated-Value file, but a fixed-width file.  Thus to the user it
will display incorrectly.

How does Excel decide what to make it's first guess as to what kind of
file a CSV file is?

If I knew, I could probably tailor the file so Excel would guess
correctly.

Thanks.

Replies