Hi,
I am new to freelancer.com. I am a software engineer in sf Bay Area. Enjoying my thanksgiving dinner with family today. I would use a tool called google refine to cleanup the data and send you back a clean csv. I'm not that financially motivated honestly. Send me your data and a written description of what you are trying to do and I'll send you back a csv. If you don't like it, no payment required. If you do like it, I'll run the rest of the clean ups for you and tell you how it do it yourself with the tool,
Dan Gardner