Excel is not opening csv file without .csv extension properly

Question

The columns in a csv file are grouped together into column A if the file has a different extension other than .csv

I have to use Data > Text To Columns and change the delimiter from '\t' to ',' to format the contents properly.

Can I tell Excel say to treat .ext as a .csv file?

Answer 1

In these cases, I've usually removed the extension from the file altogether. In Excel 2007, if I take a file filename.ext and change that to filename before opening it, it forces Excel's Text Import Wizard to open:

Other than that, I don't know of an Excel setting to map file extensions to specific behaviors.