Hacker News new | ask | show | jobs
by tgflynn 4866 days ago
Not sure if this would work but have you tried quoting the values in the generated CSV ?
1 comments

Excel ignores double quotes around the fields, it just uses them to escape commas inside the fields.

The official way to do it is to insert a single quote at the beginning of every field that you don't want auto-converted. In practice this is a time-wasting pain in the neck and ruins your data for use outside of Excel.