3 ms·
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 im
by zrobotics 3y ago
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.
- filcuk 3y agoCSVs 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.
- mthoms 3y agoThis 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.
- ozyschmozy 3y ago> 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
- david422 3y agoI 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.