A free, open source, powerful tool for working with messy data
OpenRefine (formerly Google Refine) is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data.
The part-2 of the videos on OpenRefine are here
Go to www.openrefine.org for more info, downloads and user guide