OpenRefine

OpenRefine (formerly Google Refine) is a powerful tool to work with messy data: cleaning, transforming, and dataset linking. With its group features, you can normalize the data at ease.

Octoparse