I’ve written numerous articles on issues with spreadsheets and why they shouldn’t play any part in a data analytics pipeline. However, trying to persuade people to stop defaulting to Excel is a thankless task.
So, it was no surprise (but very depressing) to read that geneticists changed their naming conventions to prevent Excel mangling their data.
My dismay was alleviated, partially, by a great quote in the article that originally alerted me to this travesty.
[W]e won’t be putting anything into production that relies on data supplied to us as spreadsheets.
The anti-spreadsheet manifesto in a single sentence.