OpenRefine Reviews & Product Details

I like how seamless it is to use the tool! Every time I think it is perfect I have found that my data is improved. I use this tool both personally and professionally and I have found that it makes my work so much easier. Review collected by and hosted on G2.com.

At this current time I like all aspects of the tool. I have been using for quite some time for both professional and personal use and each time the experience continues to get better. Review collected by and hosted on G2.com.

OpenRefine makes it quick and easy to import a very large dataset and then clean that data so it is ready for import into a different software for data analysis. Review collected by and hosted on G2.com.

OpenRefine may take some time to learn and become a comfortable user of. It is not quite as simple as doing it in Excel, but once you learn it is definitely a faster way to clean data. Review collected by and hosted on G2.com.

The button UI to do complex cleaning tasks. Most of the things/tasks that takes a lot of time and code to complete can be done in a few seconds using Openrefine. This makes it one of the easiest and user-friendly application. Review collected by and hosted on G2.com.

Maybe the theme of the tool can be changed and made more user-friendly. Most of the things/tasks that takes a lot of time and code to complete can be done in a few seconds using Openrefine. This makes it one of the easiest and user-friendly application. Review collected by and hosted on G2.com.

I like that it is easy to pick up and learn and intuitive to use Review collected by and hosted on G2.com.

The interface is a little outdated in my opinion but it doesn’t affect the usage Review collected by and hosted on G2.com.

The interface is simple to quickly understand and it is easy to go back of edits without having to make mistakes. The most favorable thing about OpenRefine is that it is open source and is 100% free to use. The software requires that you download some files before it can be run. The ability to view the data similar to a spreadsheet like performing tasks is a positive. Review collected by and hosted on G2.com.

Some of GREL coding language is not consistent with popular languages as the newer versions keep on getting released. For example, using an nested IF/OR statement does not work without putting it in a specific unconventional well. Also, it would be better if a JSON file can be exported directly instead of having to copy the JSON code generated by OpenRefine into a JSON file I create outside of OpenRefine. Review collected by and hosted on G2.com.

The best feature that I like about openrefine is it is easy to import the files and edit them, such as editing y cells or by clustering. And it can import/export into different formats of files. Review collected by and hosted on G2.com.

I had a really hard time building my own code into the different column sections. Review collected by and hosted on G2.com.

The simple UI interface that allows you to look directly at the columns you are working on and changing these values with immediate response Review collected by and hosted on G2.com.

Some jargon is used inside the application. If there was a brief description of some ideas of these jargon, it might be more intuitive Review collected by and hosted on G2.com.

Easy to use. Easy to filter values and create visualizations. Easy to do bi-variate analysis of variables. Review collected by and hosted on G2.com.

Does not scale to analyze large data sets. Basically it is limited to the amount of RAM you have on you computer since it runs locally and not on the cloud. Review collected by and hosted on G2.com.

OpenRefine runs in the browser, supports a wide variety of data formats and is loaded with features to make data cleaning, preparation and structuring a breeze. I especially like the built-in algorithms to identify duplicates of data. In general, OpenRefine saves a lot of time by not having to write custom code to clean and structure data. Review collected by and hosted on G2.com.

The interface could use an update to look a bit more modern, but works very well nonetheless. Review collected by and hosted on G2.com.

The idea that this software is open source is the most attractive portion of the application. Being able to keep track of each change performed and also revert back to them in OpenRefine is also a huge plus. A JSON file can also be exported with all the changes made for proper documentation and allows re-creating the data wrangling steps. Review collected by and hosted on G2.com.

Since the application is open source, it requires storing secondary files in the folder structure where the main application is saved to work correctly. The syntax for the General Refine Expression Language (GREL) seems a bit different compared to other languages out there such as Python and usually takes some time to get used to. Navigating through the application could be confusing at first but it takes some time to get used to and clearly understand where each button is located and what they do. Review collected by and hosted on G2.com.