OpenRefine
OpenRefine (previously Google Refine) is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data.
We asked a whole journalism conference what it wanted, out loud