Both .XLS (Excel) and .CSV (Comma Separated Values) files are accepted as file formats for Excel.
When you go to save any Excel file it normally will default to the native .XLS format.
Unless you set up Excel to save as the same format as the file was originally.
The biggest difference between the two formats is that the .CSV file is just the data, and not the formulas, nor the format, not the fonts or colors. just the data.
.CSV files are useful for transferring data between two different spreadsheet (or data file) programs. Otherwise I wouldn't use it.
Whereas the .XLS file can contain everything.
I am having a problem with a .csv Outlook attachment that is baffling.
When user A sends it to user B in our company, it opens into Excel, automatically formatted into columns.
Within the Outlook message, the attachment icon is correct for an Excel csv file and when you try to save it, it saves as "queries.csv"
When user A sends the same attachment to user C, it opens in a single column. Within the Outlook message, the attachment icon looks like an Excel worksheet icon, even though the attachment name is "queries.csv", and when you try to save the attachment, it saves as "queries.xls"!!
Could anyone explain what is happening?
I would love to have it open into Excel automatically formatted into columns.
Note - The OS is NT4 but it happens in XP also
- The regional settings are the same on each PC
- Thr "list separator" character is the same on each PC
Cheers - Tom

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic