Excel as a Database

Thanks to Stef to point this my way – it is hilarious. Cross posted from Rory Blyth – make sure to check out his post for all the hilarious story. Sadly, this is dejavu for me…. 🙂

As a developer, you’ve probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of “data” by someone in marketing and told to “do something with it.”

Columns probably didn’t line up, and a thousand different fonts were used. Every feature of Excel was probably abused and abused again in order to avoid having to use an actual database application for storage of the data.

Of course, it’s up to you to make sense of the layout, and they could just give a bleepity-bleep about what a pain in the ass it is to suck weird data out of Excel and “do something with it” when little or (more often) no thought has been given to possibly making the data consistent or, dare I say, orderly.

To this end, I’ve put together another art project. This time, what you will see unfold before your peepers is a process of discovery – My thoughts on how these files are created.

Published by

Amit Bahree

This blog is my personal blog and while it does reflect my experiences in my professional life, this is just my thoughts. Most of the entries are technical though sometimes they can vary from the wacky to even political – however that is quite rare. Quite often, I have been asked what’s up with the “gibberish” and the funny title of the blog? Some people even going the extra step to say that, this is a virus that infected their system (ahem) well. [:D] It actually is quite simple, and if you have still not figured out then check out this link – whats in a name?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.