What are the best tools for cleaning data?

PowerQuery adds functionality to pull and cleanse data from a variety of sources into your spreadsheet, remembering the source and cleansing workflow steps to allow the data in the sheet to be refreshed should the source data change.
http://www.microsoft.com/en-gb/download/details.aspx?id=39379