It takes a little getting used to, but Google Refine has saved me on multiple occasions.