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.