OpenRefine/Training

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 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: Spanish / Español - start course: French / Français - start course: Italian / Italiano - start course: 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):

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: Contact: Will Kent will@wikiedu.org