The best tool I've ever used for cleaning up large datasets, CSV or otherwise, is Google Refine[1] It takes some time to get used to the workflow, but it's ver

The best tool I've ever used for cleaning up large datasets, CSV or otherwise, is Google Refine[1] It takes some time to get used to the workflow, but it's very powerful and does a great job making messy data usable. [1]https://code.google.com/p/google-refine/ https://code.google.com/p/google-refine/