[WorldMaker]

If you use Data > From Text/CSV in Excel instead of File > Open or file double-clicking it gives you more tools and does a better auto-detection.

That used to be the default behavior in Excel for years that you'd get the CSV data "wizard" but they split the behavior and "hid" the better behavior on the Data tab of the ribbon.

(The Data tab also includes From JSON which is great at avoiding building CSV files for Excel people if you can just teach them From JSON. Most don't actually want to learn and I still wish Excel would support an XLJSON or something like that file extension to give people the double-click a file they want, but with something much more useful and clearer than CSV.)