I assume most Americans don't run into the CSV hell that other countries do. In my current country, whether CSVs open as a comma-separated or semi-colon seperated document depends on whether the OS is set to use a , or a . for decimal numbers. It's absolutely annoying.

OMG--we had a worfklow where less-techy folks were supposed to edit a csv, then check it in to github, which would kick off a whole process automatically for them. I kid you not--anyone who edited the csv in Excel would eff the whole file up every single time! They just needed a text editor, which we told them to use, and the changes were literally simple, either editing an existing entry or adding a new entry. Nope, these college educated "IT" workers could not handle it! We ended up having to scrap the entire automation workflow because the employees were simply too dumb to use a text editor and github.

> Excel can't even open CSV files properly. You need to run the import wizard.

Ofc you do. In practice, a CSV file can decide to use `|` for comma, and `<>` instead of quotes.

CSV is data only. Excel handles way more than that. XLSX is the preferred file format because it's compressed XML that can hold all kinds of things.

Also, CSVs seem to open just fine on my Excel. If it's not formatted with a standard delimiter or isn't handing quoted strings the proper way, sure maybe the data wizard is needed.

Excel is terrible in a lot of aspects, but CSVs seem to be something it handles as well as anything else in my experience.