News for hackers. Stuff that matters.

A comment on Scientists rename human genes to stop MS Excel from misreading them as dates. Parent comment

Re:Scientists rename human genes to stop MS Excel from misre... by jandrese on Thursday August 06, 2020 @04:06PM (#24074897)
I've always been surprised at how bad Excel is at importing CSV files. The solution feels like it was hacked together by an intern over the weekend even though this is an incredibly common use case.

I had to build a very basic CSV->XLS tool once because the built-in CSV import kept screwing up. Admittedly the CSV files were slightly mis-formatted in places, but that wasn't the only headache with the import.

[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by _4570 on Friday August 07, 2020 @01:23PM (#24084359)
It's really good these days compared to a few years back. You just need to use the import feature in the Data ribbon menu instead of just double clicking on the csv file. This way you get to use the "Power Query" tool that allows you to import a csv file a lot more precisely.
[ Parent | on HN ]