3 ms·
You can write CSVs in such a way that forces Excel to infer specific data types: "=""Data Here""" will always be treated as a string. This is also supported b
by mike_hearn 3y ago
You can write CSVs in such a way that forces Excel to infer specific data types:
"=""Data Here"""
will always be treated as a string. This is also supported by Sheets, apparently.
- mcintyre1994 3y agoTIL, neat! Does Excel automatically export like that if you format the columns as strings?
- _visgean 3y agook but will that work other tools that work with those csvs? I imagine that they export / import from excel to csv for a reason.