3 ms·
You have to do this with Excel as well to avoid your data automagically being formatted and/or truncated.
by PrayagBhakar 3y ago
You have to do this with Excel as well to avoid your data automagically being formatted and/or truncated.
- ale42 3y agoSo true... opening a CSV in Excel is like playing the lottery. Sometimes it opens fine, sometimes not, it even depends on the character encoding of the CSV and whether you double-click the file, open it or drag it inside Excel. Sometimes you get the "import text file" window where you have to choose the delimiter, sometimes everything gets in a single column, and sometimes you get what you want.