That’s Why You Don’t Store Data in Excel
April 17, 2014 Leave a comment
A recent blog post from DataPub addresses one of the most essential issues about what and how to save data. In particular, how do different date systems work in Excel and other software, like R? And with that question in mind, should we save our data in Excel (or not)?
Like anyone who works with a lot of data, I have a strained relationship with Microsoft Excel. Its ubiquity forces me to tolerate it, yet I believe that it is fundamentally a malicious force whose main goal is to incite chaos through the obfuscation and distortion of data.1 After discovering a truly ghastly feature of how it handles dates, I am now fully convinced.