3 ms·
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
by smackfu 14y ago
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.
- flatfilefan 14y agolast time I looked there was exactly such a wizard with the override functionality
- mbetter 14y agoThere 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.
- EEGuy 14y ago+0001
- smackfu 14y agoYeah, it works great... but only if your csv file has a .txt extension and you select that is a delimited file.
- deleted 14y ago[deleted]
- deleted 14y ago[deleted]
- deleted 14y ago[deleted]
- deleted 14y ago[deleted]
- deleted 14y ago[deleted]
- deleted 14y ago[deleted]