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

Actually you can change the extension from .csv (that Excel believes it can recognize) to something else and open it, the "import wizard" will let you choose the "separating character" and other settings that are very useful when importing Comma (or other character) separated values (such as forcing the "data type" by column). A good idea, however is to use TSV (TAB separated values) that can be usually copy pasted directly, it still remains in many cases the "feature" that Excel has to auto-identify data types, creating a mess with a number of pieces of data (such as a columen with Hex values, half of which will be "text" and the other half "numbers").


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

Search: