This week at Strata, Stanford announced a new app called “Data Wrangler” to make cleaning data easier.  Looking very similar to the previously discussed “Google Refine“, it allows you to quickly and easily reformat and clean data for import into Excel, R, Tableau, and Protovis.

You can read about the creation of the tool in this Whitepaper.  Unlike Google Refine’s design of “Search for data, then Clean it as a batch”, DataWrangler seems to work on something called the “Wrangler Transformation Language” which looks a bit like SQL.  Two different methods to achieve the same result, I guess only time will tell which one wins.

Watch the demo below.

Wrangler Demo Video from Stanford Visualization Group on Vimeo.

Data Wrangler.