RefinePro Knowledge Base for OpenRefine

This is the RefinePro knowledge base about OpenRefine. We build it over the years, and keep adding to it. From great tutorials and how-to, to handy GREL expressions and links to external resources, you will find here one of the most comprehensive list of resources to learn OpenRefine.

For a comprehensive documentation you should refer to the official OpenRefine wiki.

Don't where to get started? Search for a specific function below, or read our most popular article from the right side menu.

30.9.21

OpenRefine September 2021 Review

1:30 PM

We wanted to wish you a very happy October! This month, we decided to share the most relevant and helpful OpenRefine September 2021 community announcements, releases, tutorials, videos, and academic publications with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

30.8.21

OpenRefine August 2021 Review

11:24 AM around the web

We wish you a happy September! This month, we decided to share the most relevant and helpful OpenRefine August 2021 community announcements, releases, tutorials, videos, and academic publications with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

1.8.21

OpenRefine July 2021 Review

6:38 PM around the web

Happy August! This month, we decided to share the most relevant and helpful OpenRefine July 2021 community announcements, releases, tutorials, videos, and academic publications with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

26.6.21

OpenRefine June 2021 Review

8:00 AM around the web

Happy July! This month, we decided to share the most relevant and helpful OpenRefine June 2021 videos, tutorials, and releases with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

31.5.21

OpenRefine May 2021 Review

8:00 AM around the web

Happy June! This month, we decided to share the most relevant and helpful OpenRefine May videos, tutorials, and releases with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

25.5.21

using columnName to bulk fill down columns

11:07 PM fill down, record

Thanks to this StackOverflow question, I finally found a great use case to introduce the columnName variable in OpenRefine.

The columnName variable has been poorly documented (see previous discussions in SO and on the OpenRefine mailing list). The feature got really interesting with the All > Transform option available in OpenRefine 2.7 back in 2017 (yes, this blog post is long overdue!)

30.4.21

OpenRefine April 2021 Review

1:08 PM around the web

For April we took the time to review all your favourite OpenRefine extensions for updates and checked for new ones!

Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.

Subscribe to: Posts (Atom)

Your subscription could not be saved. Please try again.

Your subscription has been successful.

Subscribe to receive our monthly OpenRefine roundups with new tutorials, release updates and community announcements.

First Name

Last Name

Email