OpenRefine, formerly GoogleRefine, is a free and open-source program to clean data.
1. Download a copy of OpenRefine. We recommend downloading the latest "final release" and not a "beta" or "release candidate" version.
2. If necessary, please also download and install Java.
3. With Java installed, follow the OpenRefine installation instructions for Windows, Mac, or Linux.
- Once the zipped file downloads completely, move it to the directory where you want OpenRefine. Note: OpenRefine does not install a program to My Programs (on Windows) or Applications (on Mac). Instead, the program runs from wherever you put it.
- On Windows, right click on the .zip file, and extract all files. You may need an extraction tool, like 7-zip.
On Mac, double-click the zip to extract it. - Once everything has been extracted, double-click the .exe file (on Windows) or .dmg file (on a Mac). You will first see a black box appear - leave it open during your time using OpenRefine. In a few more seconds, the OpenRefine interface will appear in your internet browser. Note: we recommend using Chrome or Firefox. If necessary, copy the URL and paste it into another browser and press Enter.
Please note that OpenRefine can read zipped files with the .zip extension. If your zipped files have another file extension such as .rar, however, you must first extract any zipped data files with a program like 7-Zip.
Note for Mac users: Sometimes, Macs will not allow you to open OpenRefine since it is from an unidentified developer. You may see an error message similar to this: "openrefine-mac.dmg can't be opened because it is from an unidentified developer."
Please see these official Mac instructions to allow trusted program to run.