OpenRefine (formerly Google Refine) is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; extending it with web services; and linking it to databases like Freebase.
Web:http://openrefine.org/
Source code: https://github.com/OpenRefine
Wikipedia: http://en.wikipedia.org/wiki/OpenRefine