G2

Dami A.

Senior Engineer

Mid-Market (51-1000 emp.)

Originally submitted 1/28/2019

"Awesome Utility Tool for Data Wrangling"

4/5

What do you like best about OpenRefine?

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.

What do you dislike about OpenRefine?

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.

Recommendations to others considering OpenRefine:

When releasing newer versions, please make sure that previous GREL commands can still work. It would be great if OpenRefine can be accessed as a package through Python or at least integrated with Python someday. Being able to call the OpenRefine library through Python will prevent the need to download it and having to run an application in the background. Review collected by and hosted on G2.com.

What problems is OpenRefine solving and how is that benefiting you?

I have used OpenRefine to wrangle my data by finding matching cells within a column that might be formatted with different capitalization. I have also used it to perform filtering on empty rows, split columns, and run GREL to bin rows. Review collected by and hosted on G2.com.