OpenRefine/Training

• Welcome
• Download
• Activities
• Training
• Presentations
• Events
• Funded projects
• Contact

OpenRefine is a free data wrangling tool that can be used to process, manipulate and clean tabular (spreadsheet) data and connect it with knowledge bases ("spreadsheets on steroids" / "a swiss army knife for data"). It is widely used by librarians, in the cultural sector, by journalists and scientists, and is taught in many curricula and workshops around the world.

Self-paced online training

The following online training programs are available entirely for free and can be followed at your own pace.

	General OpenRefine introduction: Library Carpentry course The online Library Carpentry course for OpenRefine is a standard, and is highly recommended. While it is written for librarians and information workers, it is very relevant for all OpenRefine users, including Wikimedians. Language: English. Entirely free and self-paced. Approximate time to do course: 2 hours.
	OpenRefine for Wikidata: WikiLearn course (coming soon) Can be done by anyone with a Wikimedia account. Click here to start the course. Language: English Entirely free and self-paced Approximate time to do course:
	OpenRefine for Wikimedia Commons: WikiLearn course Can be done by anyone with a Wikimedia account. Languages: English - start course: OpenRefine for Wikimedia Commons: the basics Spanish / Español - start course: OpenRefine para Wikimedia Commons: conceptos básicos French / Français - start course: OpenRefine pour Wikimedia Commons : les bases Italian / Italiano - start course: Introduzione all'uso di OpenRefine per Wikimedia Commons Portuguese (coming soon). Entirely free and self-paced, with computer-graded tests and exercises. Approximate time to do course: 6 to 8 hours.

In-person training

Do you want to receive individual or group training and advice around OpenRefine? You can contact the following people and organization(s).

Individuals

Certified trainers

The following trainers have successfully completed the 6-month OpenRefine-Wikimedia Train-the-trainer program (2023-24):

• Ada Jakubowska (Wikimedia Poland)
• Bart Magnus (meemoo, Belgium)
• Carla Toro Fernández (Wikimedia Chile)
• Tamsin Braisher (Wikimedia Aotearoa New Zealand)
• Giovanna Fontenelle (Culture & Heritage team, Wikimedia Foundation)

• Jinoy Tom Jacob (Wikimedians of Kerala User Group)
• Max Kristen (Kristbaum, Germany)
• Lucas Nascimento Belo (Wiki Movimento Brasil)
• Rute Correia (Wikimedia Portugal)
• Sara Thomas (Wikimedia UK)
• Will Kent (Wiki Education Foundation)

Other OpenRefine-Wikimedia trainers

The following people also offer OpenRefine training related to Wikimedia:

• Pierre-Yves Beaudouin (Wikimedian in residence, Université Côte d'Azur)
• (your (user)name here)

You can also find trainers in the category OpenRefine trainers here on meta.wikimedia.org.

Organizations

	The Wiki Education Foundation Paid courses; both standardized and customized to your needs For individuals and organizations, also cultural institutions Offers training in English Web: https://wikiedu.org/ Contact: Will Kent will@wikiedu.org