Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Not sure if this would work but have you tried quoting the values in the generated CSV ?


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: