[tacker2000]

Can your app auto detect the CSV delimiters and also detect decimal point vs comma for numbers?

This is a huge problem when dealing with European and UK/US CSV formats (or whatever you mat want to call them) for me daily.

Excel only auto opens the format supported by the current locale, so anything else will just not be detected.

[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.)

[evanem]

It does delimiter auto detection and for the Statistics feature, it automatically detects dot vs. comma decimals.

[ptman]

libreoffice calc is better with csv import IIRC

[nuc1e0n]

I agree libreoffice calc is better, but it does still munge some data.