Excel Considered Harmful (by me)

I've been meaning to post this for a while: Excel is a horrible way to store and transmit data. Let me explain further what I mean: when working with data, it's important that those data are not modified unless you want to modify them. Excel likes to tamper with whatever you insert into its cells unless they're text type, so something that may appear to Excel to be a date is irrevocably lost when Excel decides to corrupt it. Just another example of Microsoft-induced lossage (another rant altogether).

Excel is not a database. It doesn't preserve your data as you intended them to be. And while I'm at it, creating multiple tabs is not a substitute for some kind of indicator. Whenever I encounter data that is generally a mess and disorganized it has been sent to me as an Excel file. Excel is good at what it is, but it isn't, as I say, a database or a reliable means to transmit data to another party.

And I'm not the only one who has suffered.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <i> <b>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Copy the characters (respecting upper/lower case) from the image.