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

Really, the main problem is that Excel (which has data types) is trying to support CSV (which has no data types) as a pseudo-native format. If Excel forced CSV files through the import wizard, and you could override a data type for each column, it would solve most of the issues. Instead, each column is implicitly treated as Auto and that fails in a lot of cases.


last time I looked there was exactly such a wizard with the override functionality


Yeah, it works great... but only if your csv file has a .txt extension and you select that is a delimited file.


There is, it just isn't invoked for a .csv file.

As someone who basically lives in Excel for 40 hours a week, I find my quality of life to be much improved when I keep my text files tab delimited.


+0001




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

Search: