And leading zeros, which is awesome when postal codes have them and shipping software uses csv imports. Somebody only has to open the file once, and it isn't immediately obvious unless people know to expect that.

I used to work with some data that would come across as CSV files but from non-technical people and required leading zeros on some fields. Trying to explain the difference between csv and excel ... or why you should not open those files in excel ... was difficult to say the least.

CSVs need an option to open as text. Or at least to tell people "hey, there butchered your data for ya" with an undo option. I got a ticket from IT dept (lol) that a CSV is the wrong format. It wasn't.

This article says the user will be notified if any data is automatically converted when opening a CSV. This should have been done a decade ago but I'm still glad to see it.

> When you select the When loading a .csv file or similar file, notify me of any automatic number conversions check box,

From what I can tell, these are all opt-in via settings. So it won't stop unaware users from accidentally messing up csvs