News for hackers. Stuff that matters.

A comment on So you want to write your own CSV code (2014). Parent comment

Re:So you want to write your own CSV code (2014) by JoBrad on Friday May 15, 2020 @11:02AM (#23192961)
Importantly, tabs aren’t usually inserted into fields by Excel users. With Power BI, exporting TSV is a little easier for non-dev Excel power users, too.
[ Parent | on HN ]
Re:So you want to write your own CSV code (2014) by IggleSniggle on Friday May 15, 2020 @12:32PM (#23194081)
Nailed it. When Excel users press tab, they mean "go to the next cell." Conveniently, this is also what the format means to the computer when it encounters the tab separator. It's not foolproof, but it's much better. The human interpretation of the character matches the machine interpretation.
[ Parent | on HN ]