Hacker News new | ask | show | jobs
by mike_hearn 820 days 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.

2 comments

TIL, neat! Does Excel automatically export like that if you format the columns as strings?
ok but will that work other tools that work with those csvs? I imagine that they export / import from excel to csv for a reason.