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.

Showing posts with label around the web. Show all posts
Showing posts with label around the web. Show all posts

1.11.22

OpenRefine October 2022 Review

Happy November! This month, we decided to share the most relevant and helpful OpenRefine October 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!

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

30.9.22

OpenRefine September 2022 Review

Happy October! This month, we decided to share the most relevant and helpful OpenRefine September 2022 announcements, tutorials, videos, and academic publications with you. Read on to discover them!

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

28.7.22

OpenRefine July 2022 Review

We wish you a very happy August This month, we decided to share the most relevant and helpful OpenRefine July 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!

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

2.5.22

OpenRefine April 2022 Review

Happy May! For this month, we decided to share the most relevant and helpful OpenRefine April 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!


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

4.3.22

OpenRefine February 2022 Review

Happy March! For this month, we decided to share the most relevant and helpful OpenRefine February 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!

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

1.12.21

OpenRefine November 2021 Review

Happy December! Didn't 2021 just fly by? For the last month of this year, we decided to share the most relevant and helpful OpenRefine November 2021 community announcements, releases, tutorials, and videos with you.


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

29.10.21

OpenRefine October 2021 Review

Happy November to all! This month, we shared the most relevant and helpful OpenRefine October 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

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

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

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

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!

30.4.21

OpenRefine April 2021 Review

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.

29.3.21

OpenRefine March 2021 Review

With spring at our doors, we have a new section on our monthly update: Academic Publication. Here we will list recent academic publications about OpenRefine, or papers that use OpenRefine in their process. This should be a trove of more advanced use cases promoting reproducible science. 



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

26.2.21

OpenRefine February 2021 Review

Here is a summary of all the interesting tutorials and videos published about OpenRefine through February. 

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

29.1.21

OpenRefine January 2021 Review

2021 starts big with the release of the new user documentation for OpenRefine. It took over six months of hard work to migrate the documentation from GitHub wiki to Docusaurus. It was also the opportunity to update the content. 

We also listed below new tutorials and videos published about OpenRefine through January along with the update of the NER and RDF extensions. 



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

22.12.20

OpenRefine December 2020 Review

Here is a summary of all the interesting tutorials and videos published about OpenRefine through December. Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.


30.11.20

OpenRefine November 2020 Review


Here is a summary of all the interesting tutorials and videos published about OpenRefine through November. Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.

30.10.20

OpenRefine October 2020 Review

Through September and October, the BD Guidance team in Colombia ran numerous workshops on data quality and preparation with OpenRefine (all in Spanish). Fortunately, they recorded everything if you want to catch up. 

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



2.10.20

OpenRefine September 2020 Review

Here is a summary of all the interesting tutorials and videos published about OpenRefine through September. Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.


2.9.20

The Best Online Courses for OpenRefine 3.3- 2020 version

September often means back to school. If OpenRefine is on your list of new software to learn, we listed below (in no particular order) the best courses released in 2020 for OpenRefine 3.3. They all provide a complete overview of OpenRefine from installation to more advanced features like GREL and reconciliation. All courses combine detailed walkthroughs in text and video with hands-on tutorials to get your new skills in practice. Courses are available in 🇬🇧 English, 🇪🇸Spanish and 🇳🇱 Dutch. 


Of course, the Library, Social Science, Ecology Carpentries and Programming Historian lessons are still relevant and being kept up to date. You can also consult our OpenRefine Foundation class (using OpenRefine 2.6).


We listed their curriculum below to ease the comparison. Let us know in the comment if we missed something! Happy learning. 

Map & Data Library, University of Toronto


https://mdl.library.utoronto.ca/tools/openrefine

Course Content: 

  1. (Optional) OpenRefine Installation Instructions
  2. OpenRefine Tutorial 1. Survey of Household Spending Activity
  3. OpenRefine Tutorial 2. Citizen Science Activity
  4. OpenRefine Tutorial 3. Regular Expressions (Regex) Activity
  5. OpenRefine Tutorial 4. 311 Calls Activity
  6. OpenRefine Augmenting Activity 1: Preparing the data
  7. OpenRefine Augmenting Activity 2: Using Reconciliation Services
  8. OpenRefine Augmenting Activity 3: Using Add Column by Fetching URLs
  9. OpenRefine Augmenting Activity 4: Using Python

Griffith Library

With direct access to their video:


🇪🇸 GBIF | Global Biodiversity Information Facility: Guía de Uso Básico de OpenRefine para la limpieza de datos sobre biodiversidad


Under Progress documentation in Spanish: https://doi.org/10.15468/doc-gzjg-af18

Course Content: 
  • 1. Carga de datos y creación de un proyecto
  • 2. Limpieza de datos
  • 2.1. Manejo básico de columnas
    • 2.2. Uso de Facetas
    • 2.3. Uso de Filtros
    • 2.4. Uso de Agrupamientos
    • 2.5. Deshacer y rehacer cambios
    • 2.6. Marcado de registros: banderas y estrellas
  • 3. Guardado y exportación de datos y proyectos
    • 3.1. Guardado de datos y proyectos
    • 3.2. Exportación de datos y proyectos
  • 4. Consultas a servicios externos
    • 4.1. Consultas externas a través de URLs
  • Epílogo
    • Agradecimientos
  • Apéndice 1: instalación de OpenRefine

🇳🇱 Platform ZelfDoen: online cursus OpenRefine


A Dutch translation of the Library Carpentries course: https://www.zelfdoeninzh.nl/info-tips/online-cursus-openrefine/

Course Content: 

  • hoofdstuk 1: OpenRefine: tool voor het opschonen van collectie data
  • hoofdstuk 2: Voorbereiding: download het programma en een voorbeeld dataset
  • hoofdstuk 3: Importeren van data in OpenRefine
  • hoofdstuk 4: De lay out van OpenRefine (rijen en records)
  • hoofdstuk 5: Over facetten en filters
  • hoofdstuk 6: Over clusteren van gegevens
  • hoofdstuk 7: Werken met kolommen en sorteren
  • hoofdstuk 8: Transformaties: introductie
  • hoofdstuk 9: Transformaties: redo en undo
  • hoofdstuk 10: Transformaties: tekst, getallen, data en booleaans
  • hoofdstuk 11: Transformaties: arrays of reeksen
  • Hoofdstuk 12: Exporteren van je dataset