OpenRefine 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)
How to install OpenRefine?
Download the setup of the OpenRefine from here
UnZip the file and run openrefine.exe
Then go to your web browser and type "localhost:3333"
OpenRefine tool will get opened
Working with OpenRefine:
After running the openrefine tool go to any browser and type localhost:3333
And then you will see the following interface
Now choose a specified file and click on next then after you will see this interface
I have chosen a CSV(Comma separated value) File but you can choose any file type from the specified files
You can change the project name and you can also give the tags if you want and then you have to click on create project
After clicking on the create project you will see this kind of interface
Now you can perform any operation according to your need or you can refine the data using OpenRefine
To download the data you can check the Export option in the top right corner