4 ms·
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
by tacker2000 3y ago
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.
- ptman 3y agolibreoffice calc is better with csv import IIRC
- nuc1e0n 3y agoI agree libreoffice calc is better, but it does still munge some data.
- WorldMaker 3y agoIf 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 3y agoIt does delimiter auto detection and for the Statistics feature, it automatically detects dot vs. comma decimals.