Earlier quoted context omitted.
Even "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.
That'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.
It 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?