[michaelanckaert]

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.

[nh2]

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?