When you are working with data, you may need to make large-scale transformations, such as changing a date format or separating a piece of data into two cells. Instead of going through every cell in a spreadsheet, you can use tools or programming to expedite the process.
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.
OpenRefine always keeps your data private on your own computer until YOU want to share or collaborate. Your private data never leaves your computer unless you want it to. (It works by running a small server on your computer and you use your web browser to interact with it)