2 ms·
The file format being ambiguous and underspecified enough to mangle is, though.
by thunderfork 6mo ago
The file format being ambiguous and underspecified enough to mangle is, though.
- mcdonje 6mo agoNo, it's Excel trying to be too clever. It does the same thing with manual imput if you don't proactively change the field type. You can import a DSV into Excel without mangling datatypes in a few different ways. Probably the best way is using Power Query. A DSV generally does have a schema. It's just not in the file format itself. Just because it isn't self-describing doesn't mean it isn't described. It just means the schema is communicated outside of the data interchange.