[sanotehu]

Yes, through the "Import" feature. Excel will in that case allow you to choose what "type" each column in the CSV has (and will not parse text if given the "text" type). The problem is that a lot of users (myself included) will use muscle memory and double-click a CSV file in windows explorer rather than opening up Excel and initiating an import.

[yjftsjthsd-h]

So why does it not import when opening files?

[mijamo]

Because you can create documents with formulas, save them as CSV and open them again. If it did an import when opening, the operation save A -> load A would result in a different result than the file you had when you clicked saved.

or at least this the most logical explanation I could find.

[pbhjpbhj]

So a safe-import could import all columns as text (without interpretation) and offer to parse columns with a predictive input type suggestion.