undefined | Better HN

0 pointsnh21y ago0 comments

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.

0 comments

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.

nh2OP11mo ago

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?

j / k navigate · click thread line to collapse