OpenRefine: For working with, cleaning, transforming messy data (openrefine.org)
OpenRefine is a powerful free, open source tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data.