Transform Data by Example
an add-in for Excel
Do you spend hours trying to clean, standardize, and transform data such as date-time, addresses, phone numbers, and URLs?
Transform Data by Example is an Excel add-in that helps you find the desired transformation function easily. Simply provide a few examples of the desired output, and Transform Data by Example will automatically find relevant data transformation functions from a large collection that it has already indexed. Add your own data transformation code into the collection, and Transform Data by Example will make them instantly searchable, all seamlessly within Excel.
Meet the team
Yeye He, Kris Ganjam, Surajit Chaudhuri, Vivek Narasayya, Kukjin Lee
Data Management, Exploration, and Mining group (DMX) at Microsoft Research