Y
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
mcintyre1994
820 days ago
TIL, neat! Does Excel automatically export like that if you format the columns as strings?
link
_visgean
820 days ago
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.
link