2 ms·
Excel does things to CSV data that shouldn’t be done. Encodings are troublesome. (See ftfy, a miracle library for fixing them) Everything might be a date. Eve
by wiredfool 4y ago
Excel does things to CSV data that shouldn’t be done.
Encodings are troublesome. (See ftfy, a miracle library for fixing them)
Everything might be a date. Even genes.
Leading zeros get dropped. Even when significant. (Like routing numbers)
Long numeric strings get turned into scientific notation. (Like account numbers)