Google tool : http://openrefine.org/
Video explain all .... this is very cool tool for data mining, and data transforming. I usually use LibreOffice Calc for this data mining, that tools rocks as it could:
- conditions for columns creation from other column
- language for data minding from columns
- recording of data translation to repeat again and again
- usage of web services to generate new column base on existing column
- embedded language to parse JSON
- .... just look at video ...