absolutely agree. We get lots of csv files to process and most of our consultants will check them in excel and totally mangle them one way or another. You _can_ make excel import them without messing them too much but it's several hoops away from the normal file open procedure so they forget. Libreoffice Just Works. Love it. And the way it can split a multi-tab excel file into separate csv files from the command line is a godsend. Although the documentation for the incantation for the filters to make it do it is rather lacking. But once you get it, it's fantastic

Excel has two different ways to open csv. The open/doubleclick is kinda compatiblity mode, with reasons for default options lost in history. The way you are supposed to use csv is open blank workbook, data tab and import.

Yup, this is a constant trouble maker for us.

Customer exports a csv file, then verifies the contents in excel. They never realize that excel modified some of the data, and pass it on to us.

Just, constantly! (I use notepad++ for CSV files however)

Me too, I'm not impressed with the interface tho.

It should be able to sniff the csv flavor before ingesting it.

Maybe it would be cool to tie the settings to the file path so that it simply opens /banana/2.csv assuming it is just like /banana/1.csv (skipping the dialog)

you can also try this tool for csv https://newbeelearn.com/tools/csvonline/

Why not a text editor?