OpenRefine (previously known as Google Refine) is an open-sourced data cleanup tool that looks like a typical spreadsheet but has robust data cleanup capabilities.
Benefits of OpenRefine:
• Get an overview of a data set
• Resolve inconsistencies in a data set
• Help you split data up into more granular parts
• Match local data up to other data sets
• Enhance a data set with data from other sources
“Developed by Owen Stephens on behalf of the British Library”