Magic/Replace is a web based tool to clean up data easily. It enables the user to copy data from a spreadsheet, csv (comma separated file), or a TSV (tab separated file) and make changes to all of the rows at once.

For example, if you had a column of data that contained a phone number without separators (1234567890), you could easily change the contents to be formatted to include separators (123-456-7890).

Magic/Replace will also change the case of the data in a field.

You would use Excel or some other more powerful tool for major data cleanup. However, Magic/Replace works well and is quick for simple data cleanup. Magic/Replace is brought to you by Dabble DB – an easy way to create online databases.

Website: http://cleanupdata.com/