I just started working for a local company. So far work has been very good and everything is great. A few days ago they asked me to help them move some data from their current repository to a new software they just bought.
I asked for the data and I was handed 3 or 4 (10 MB+) excel spreadsheets. At first I thought it was a joke, but come to find out they keep all their history and information about sites their maintain in excel spreadsheets! Needless to say that the data is a mess, it is all typed by hand, no standardisation at all, and of course each sheet has 10 million fields and 4-5 separate worksheets with a billion different formulas.
I have spent the past week digging through it trying to get some “clean” data out, so far I have not been very successful at scripting or getting said data out without having to physically manipulate it.
As soon as I can sort that mess I am doing away with all the spreadsheets and moving everything to a database system. I can not believe that there are people out there still using Excel as a data repository. Excel is not a database, it is a data manipulation software. Please please please NEVER USE EXCEL for “Data Storage” you will regret it.