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 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.

I use OpenRefine mainly to check tons of data before sending it to the users, and this data might include small and uncaught errors like the weird characters or the extra punctuation or the extra space in the beginning of the cells which might led to show the same info in 2 different ways, and for this OpenRefine is serving me in the best way for that. Review collected by and hosted on G2.com.

some times you have to do the same step several times for multiple columns in Excel for Example, when I use it to check the data from Excel data I have several columns to check and I have to go to each column and do the facet steps, it would be much easier if there are a multiple selection which allow the user to do the same process across several selections. Review collected by and hosted on G2.com.