4 ms·
Excel hates CSV only if you don't use the "From text / csv" function (under the data tab). For whatever reason, it flawlessly manages to import most CSV data u
by TrackerFF 2y ago
Excel hates CSV only if you don't use the "From text / csv" function (under the data tab).
For whatever reason, it flawlessly manages to import most CSV data using that functionality. It is the only way I can reliably import data to excel with datestamps / formats.
Just drag/dropping a CSV file onto a spreadsheet, or "open with excel" sucks.
- tacker2000 2y agoYea they seem to have added this about a year ago and it works pretty well, to be fair. Now if they would just also allow pasting CSV data as “source” it would be great.
- tgtweak 2y agoIt's a carry over from powerbi actually, separate function entirely.
- nh2 2y agoEven "From Text / CSV" sucks: It inserts an extra row at the top for its pivot table, with entries "Column1, Column2, ...". So if you export to CSV again, you now have 2 header rows. So Excel can't roundtrip CSVs, and the more often you roundtrip, the more header rows you get. You need to remember to manually delete the added header row each time, otherwise software you export back to can't read it.
- michaelanckaert 2y agoThat's strange, I've never seen this behaviour. Loading a CSV this way (Data -> From Text/CSV) always parses the first record as the header for me.
- nh2 2y agoIt does parse the first row as the header, but it inserts it as the second row, and the first row becomes another header. It creates a green/white coloured pivot table -- do you also observe that?