OpenRefine (formerly GoogleRefine) is a tool designed for working with messy data. You can use it to clean your data and transform it between formats.
OpenRefine is available in the PCL Data Lab.
These screencasts provide a brief introduction to OpenRefine. (They were developed by Google when the program was still called GoogleRefine, but not much has changed besides the name.)
Using Openrefine by 
This work is licensed under a Creative Commons Attribution-NonCommercial 2.0 Generic License.