CINXE.COM

<!DOCTYPE html> <html class="client-nojs" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>Commons:OpenRefine - Wikimedia Commons</title> <script>(function(){var className="client-js";var cookie=document.cookie.match(/(?:^|; )commonswikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"d2ee2824-2cb8-4cbc-b3fe-56c3dff1c86b","wgCanonicalNamespace":"Project","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":4,"wgPageName":"Commons:OpenRefine","wgTitle":"OpenRefine","wgCurRevisionId":918206684,"wgRevisionId":918206684,"wgArticleId":110002972,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"], "wgCategories":["Structured Data on Commons","OpenRefine"],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Commons:OpenRefine","wgRelevantArticleId":110002972,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"commons","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":false,"wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":true,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":20000,"wgInternalRedirectTargetUrl":"/wiki/Commons:OpenRefine","wgTranslatePageTranslation":"source","upwizPropertyTitles":{"P180":"Main subjects visible in this work"},"upwizPropertyPlaceholders":{"P180":"e.g., Angolan giraffe"},"upwizPropertyCopyLabels":{"P180":"Main subjects"}, "wgEditSubmitButtonLabelPublish":true,"wgDiscussionToolsFeaturesEnabled":{"replytool":true,"newtopictool":true,"sourcemodetoolbar":true,"topicsubscription":false,"autotopicsub":false,"visualenhancements":false,"visualenhancements_reply":false,"visualenhancements_pageframe":false},"wgDiscussionToolsFallbackEditMode":"source","wgULSPosition":"personal","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q5583871","wbmiDefaultProperties":["P180"],"wbmiPropertyTitles":{"P180":"Items portrayed in this file"},"wbmiPropertyTypes":{"P180":"wikibase-item"},"wbmiRepoApiUrl":"/w/api.php","wbmiHelpUrls":{"P180":"https://commons.wikimedia.org/wiki/Special:MyLanguage/Commons:Depicts"},"wbmiExternalEntitySearchBaseUri":"https://www.wikidata.org/w/api.php","wbmiSupportedDataTypes":["wikibase-item","string","quantity","time","monolingualtext","external-id","globe-coordinate","url"],"wgCheckUserClientHintsHeadersJsApi":["brands" ,"architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"]};RLSTATE={"ext.gadget.Long-Image-Names-in-Categories":"ready","ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.translate.tag.languages":"ready","mediawiki.page.gallery.styles":"ready","ext.tmh.player.styles":"ready","ext.discussionTools.init.styles":"ready","oojs-ui-core.styles":"ready","oojs-ui.styles.indicators":"ready","mediawiki.widgets.styles":"ready","oojs-ui-core.icons":"ready","skins.vector.styles.legacy":"ready","ext.translate.edit.documentation.styles":"ready","ext.translate":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","codex-search-styles":"ready","ext.uls.pt":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["mediawiki.action.view.redirect","mediawiki.page.gallery","ext.tmh.player","site","mediawiki.page.ready", "skins.vector.legacy.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.translate.pagetranslation.uls","ext.gadget.Slideshow","ext.gadget.ZoomViewer","ext.gadget.CollapsibleTemplates","ext.gadget.fastcci","ext.gadget.Stockphoto","ext.gadget.WatchlistNotice","ext.gadget.AjaxQuickDelete","ext.gadget.WikiMiniAtlas","ext.gadget.LanguageSelect","ext.gadget.PictureOfTheYearEnhancements","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.discussionTools.init","ext.eventLogging","ext.wikimediaEvents","ext.wikimediaEvents.wikibase","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface","ext.checkUser.clientHints","wikibase.sidebar.tracking"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=codex-search-styles%7Cext.discussionTools.init.styles%7Cext.tmh.player.styles%7Cext.translate%2CwikimediaBadges%7Cext.translate.edit.documentation.styles%7Cext.translate.tag.languages%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cmediawiki.page.gallery.styles%7Cmediawiki.widgets.styles%7Coojs-ui-core.icons%2Cstyles%7Coojs-ui.styles.indicators%7Cskins.vector.styles.legacy%7Cwikibase.client.init&only=styles&skin=vector"> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=ext.gadget.Long-Image-Names-in-Categories&only=styles&skin=vector"> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector"> <meta name="generator" content="MediaWiki 1.44.0-wmf.5"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:title" content="Commons:OpenRefine - Wikimedia Commons"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//commons.m.wikimedia.org/wiki/Commons:OpenRefine"> <link rel="alternate" type="application/x-wiki" title="Edit" href="/w/index.php?title=Commons:OpenRefine&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/commons.png"> <link rel="icon" href="/static/favicon/commons.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikimedia Commons"> <link rel="EditURI" type="application/rsd+xml" href="//commons.wikimedia.org/w/api.php?action=rsd"> <link rel="canonical" href="https://commons.wikimedia.org/wiki/Commons:OpenRefine"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/"> <link rel="alternate" type="application/atom+xml" title="Wikimedia Commons Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="//login.wikimedia.org"> </head> <body class="ext-discussiontools-replytool-enabled ext-discussiontools-newtopictool-enabled ext-discussiontools-sourcemodetoolbar-enabled skin-vector-legacy mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-4 ns-subject mw-editable page-Commons_OpenRefine rootpage-Commons_OpenRefine skin-vector action-view"><div id="mw-page-base" class="noprint"></div> <div id="mw-head-base" class="noprint"></div> <div id="content" class="mw-body" role="main"> <a id="top"></a> <div id="siteNotice"></div> <div class="mw-indicators"> </div> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">Commons</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">OpenRefine</span></h1> <div id="bodyContent" class="vector-body"> <div id="siteSub" class="noprint">From Wikimedia Commons, the free media repository</div> <div id="contentSub"><div id="mw-content-subtitle"></div></div> <div id="contentSub2"></div> <div id="jump-to-nav"></div> <a class="mw-jump-link" href="#mw-head">Jump to navigation</a> <a class="mw-jump-link" href="#searchInput">Jump to search</a> <div id="mw-content-text" class="mw-body-content"><div class="mw-pt-translate-header noprint nomobile" dir="ltr" lang="en"><a href="/w/index.php?title=Special:Translate&group=page-Commons%3AOpenRefine&action=page&filter=&action_source=translate_page" title="Special:Translate">Translate this page</a></div><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><div class="mw-pt-languages noprint navigation-not-searchable" lang="en" dir="ltr"><div class="mw-pt-languages-label">Other languages:</div><ul class="mw-pt-languages-list"><li><a href="/wiki/Commons:OpenRefine/de" class="mw-pt-progress mw-pt-progress--complete" title="Commons:OpenRefine (100% translated)" lang="de" dir="ltr">Deutsch</a></li> <li><span class="mw-pt-languages-ui mw-pt-languages-selected mw-pt-progress mw-pt-progress--complete" lang="en" dir="ltr">English</span></li> <li><a href="/wiki/Commons:OpenRefine/fr" class="mw-pt-progress mw-pt-progress--complete" title="Commons:OpenRefine (100% translated)" lang="fr" dir="ltr">français</a></li> <li><a href="/wiki/Commons:OpenRefine/pl" class="mw-pt-progress mw-pt-progress--low" title="Commons:OpenRefine (11% translated)" lang="pl" dir="ltr">polski</a></li> <li><a href="/wiki/Commons:OpenRefine/pt-br" class="mw-pt-progress mw-pt-progress--med" title="Commons:OpenRefine (34% translated)" lang="pt-BR" dir="ltr">português do Brasil</a></li> <li><a href="/wiki/Commons:OpenRefine/ru" class="mw-pt-progress mw-pt-progress--med" title="Commons:OpenRefine (17% translated)" lang="ru" dir="ltr">русский</a></li> <li><a href="/wiki/Commons:OpenRefine/gu" class="mw-pt-progress mw-pt-progress--low" title="Commons:OpenRefine/gu (8% translated)" lang="gu" dir="ltr">ગુજરાતી</a></li> <li><a href="/wiki/Commons:OpenRefine/ja" class="mw-pt-progress mw-pt-progress--low" title="Commons:OpenRefine (12% translated)" lang="ja" dir="ltr">日本語</a></li></ul></div> <p><span id="shortcut" class="coordinates" style="white-space:nowrap;"><a href="/wiki/Commons:Shortcuts" title="Commons:Shortcuts">Shortcut</a>: <span class="plainlinks"><a class="external text" href="https://commons.wikimedia.org/w/index.php?title=Commons:OR&redirect=no">COM:OR</a></span></span> </p> <table width="100%" cellspacing="0" cellpadding="0" border="0" style="background-color: transparent"><tbody><tr><td style="width: 1%; border-bottom: 1px solid #000000"> </td><td style="text-align: center; border-radius: 0px 0px 0 0; padding:0.3em; border: 1px solid #000000; font-size: 110%; background-color: #FFFFFF; white-space: nowrap;" width="3%"><a href="/wiki/Special:MyLanguage/Commons:OpenRefine" title="Special:MyLanguage/Commons:OpenRefine">About</a></td><td style="width: 2%; border-bottom: 1px solid #000000"> </td><td style="text-align: center; border-radius: 0px 0px 0 0; padding:0.3em; border: 1px solid #000000; font-size: 110%; background-color: #FFFFFF; white-space: nowrap;" width="3%"><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Uploading_files_with_OpenRefine" title="Special:MyLanguage/Commons:OpenRefine/Uploading files with OpenRefine">How to: <b>upload files</b></a></td><td style="width: 2%; border-bottom: 1px solid #000000"> </td><td style="text-align: center; border-radius: 0px 0px 0 0; padding:0.3em; border: 1px solid #000000; font-size: 110%; background-color: #FFFFFF; white-space: nowrap;" width="3%"><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Adding_structured_data_with_OpenRefine" title="Special:MyLanguage/Commons:OpenRefine/Adding structured data with OpenRefine">How to: <b>edit files</b></a></td><td style="width: 2%; border-bottom: 1px solid #000000"> </td><td style="text-align: center; border-radius: 0px 0px 0 0; padding:0.3em; border: 1px solid #000000; font-size: 110%; background-color: #FFFFFF; white-space: nowrap;" width="3%"><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Advanced_tips_and_tricks" title="Special:MyLanguage/Commons:OpenRefine/Advanced tips and tricks">Advanced tips and tricks</a></td><td style="width: 2%; border-bottom: 1px solid #000000"> </td><td style="text-align: center; border-radius: 0px 0px 0 0; padding:0.3em; border: 1px solid #000000; font-size: 110%; background-color: #FFFFFF; white-space: nowrap;" width="3%"><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Training" title="Special:MyLanguage/Commons:OpenRefine/Training">Training</a></td><td style="width: 2%; border-bottom: 1px solid #000000"> </td><td style="text-align: center; border-radius: 0px 0px 0 0; padding:0.3em; border: 1px solid #000000; font-size: 110%; background-color: #FFFFFF; white-space: nowrap;" width="3%"><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Projects" title="Special:MyLanguage/Commons:OpenRefine/Projects">Projects</a></td><td style="width: 1%; border-bottom: 1px solid #000000"> </td></tr></tbody></table> <p><br/> </p> <style data-mw-deduplicate="TemplateStyles:r380316416">.mw-parser-output .restwocol-container{margin-bottom:1.125em}.mw-parser-output .restwocol-main{margin-right:2.8075em}@media screen and (max-width:999px){.mw-parser-output .restwocol-container{display:inline-block}.mw-parser-output .restwocol-main{margin-right:0!important}}@media screen and (min-width:1000px){.mw-parser-output .restwocol-container{display:flex}.mw-parser-output .restwocol-main{flex:3}.mw-parser-output .restwocol-additional{flex:2}}</style><div class="restwocol-container"> <div class="restwocol-main"> <p><b>OpenRefine</b> is a free and open source (FOSS) tool with which you can (batch) <b>edit</b> and <b>upload files</b> on <b>Wikimedia Commons</b>. OpenRefine focuses on adding and editing <a href="/wiki/Special:MyLanguage/Commons:Structured_data" title="Special:MyLanguage/Commons:Structured data"><b>structured data</b></a>. OpenRefile is available as a cloud service on <a rel="nofollow" class="external text" href="https://hub-paws.wmcloud.org/hub/login">PAWS</a> to Wikimedia users. </p> <ul class="gallery mw-gallery-packed"> <li class="gallerybox" style="width: 336.66666666667px"> <div class="thumb" style="width: 334.66666666667px;"><span typeof="mw:File"><a href="/wiki/File:OpenRefine_Wikimedia_Commons_project.png" class="mw-file-description" title="A typical Wikimedia Commons project in OpenRefine"><img alt="" src="https://upload.wikimedia.org/wikipedia/commons/thumb/d/d2/OpenRefine_Wikimedia_Commons_project.png/502px-OpenRefine_Wikimedia_Commons_project.png" decoding="async" width="335" height="200" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/d/d2/OpenRefine_Wikimedia_Commons_project.png/753px-OpenRefine_Wikimedia_Commons_project.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/d/d2/OpenRefine_Wikimedia_Commons_project.png/1004px-OpenRefine_Wikimedia_Commons_project.png 2x" data-file-width="1392" data-file-height="832"/></a></span></div> <div class="gallerytext">A typical Wikimedia Commons project in OpenRefine</div> </li> <li class="gallerybox" style="width: 336.66666666667px"> <div class="thumb" style="width: 334.66666666667px;"><span typeof="mw:File"><a href="/wiki/File:OpenRefine_Wikimedia_Commons_schema.png" class="mw-file-description" title="A schema in OpenRefine that prepares edits to Wikimedia Commons"><img alt="" src="https://upload.wikimedia.org/wikipedia/commons/thumb/d/db/OpenRefine_Wikimedia_Commons_schema.png/502px-OpenRefine_Wikimedia_Commons_schema.png" decoding="async" width="335" height="200" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/d/db/OpenRefine_Wikimedia_Commons_schema.png/753px-OpenRefine_Wikimedia_Commons_schema.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/d/db/OpenRefine_Wikimedia_Commons_schema.png/1004px-OpenRefine_Wikimedia_Commons_schema.png 2x" data-file-width="1392" data-file-height="832"/></a></span></div> <div class="gallerytext">A schema in OpenRefine that prepares edits to Wikimedia Commons</div> </li> </ul> <p>This page collects information about OpenRefine for the <b>Wikimedia Commons</b> community. </p> <ul><li>OpenRefine for Wikidata: <a href="https://www.wikidata.org/wiki/Special:MyLanguage/Wikidata:Tools/OpenRefine" class="extiw" title="d:Special:MyLanguage/Wikidata:Tools/OpenRefine"><b>Wikidata:Tools/OpenRefine</b></a></li> <li>General info about OpenRefine for Wikimedians: <a href="https://meta.wikimedia.org/wiki/Special:MyLanguage/OpenRefine" class="extiw" title="meta:Special:MyLanguage/OpenRefine">OpenRefine</a></li></ul> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Frequently_Asked_Questions" data-mw-thread-id="h-Frequently_Asked_Questions"><span data-mw-comment-start="" id="h-Frequently_Asked_Questions"></span>Frequently Asked Questions<span data-mw-comment-end="h-Frequently_Asked_Questions"></span></h2></div> <dl><dt>I have problems installing / opening OpenRefine on my computer. What should I do?</dt></dl> <p>You can <a rel="nofollow" class="external text" href="https://openrefine.org/download.html">download the latest stable version of OpenRefine from its website</a>. OpenRefine's manual <a rel="nofollow" class="external text" href="https://docs.openrefine.org/manual/installing">includes detailed installation instructions</a>; make sure to read these. </p> <ul><li>If you use Windows, then make sure you install the OpenRefine kit with embedded Java.</li></ul> <p>Some users are unable to install OpenRefine because of, for instance, firewall issues, or because their organization or company does not allow users to install external software. In that case, you can use Wikimedia's cloud version of OpenRefine on PAWS, which is described <a href="/wiki/Special:MyLanguage/Commons:OpenRefine#In_the_cloud_(via_Wikimedia_PAWS)" title="Special:MyLanguage/Commons:OpenRefine">elsewhere on this page</a>. </p> <dl><dt>Does OpenRefine allow upload of all types of files that Wikimedia Commons supports?</dt></dl> <p>OpenRefine supports all kinds of media files that can be uploaded to Wikimedia Commons. It does not support the upload of data files. </p><p>Many upload tools, including OpenRefine, sometimes have trouble uploading TIFF files. </p><p>Please note that OpenRefine supports uploading local files up to 100MB, not larger. It is possible to upload larger files from URL though. </p> <dl><dt>What is the maximum size of files that can be uploaded to Wikimedia Commons with OpenRefine?</dt></dl> <p>OpenRefine does not (yet) support Chunked Uploads, and hence only allows uploads of files from your local drive up to 100MB. See <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/issues/4303">GitHub issue</a> (help is very welcome to address and fix this issue). Uploading larger files to Wikimedia Commons is possible via URLs on the web. If that is not an option for you, please use <a href="/wiki/Special:MyLanguage/Commons:Pattypan" title="Special:MyLanguage/Commons:Pattypan">Pattypan</a> or the <a href="/wiki/Special:MyLanguage/Commons:Upload_Wizard" title="Special:MyLanguage/Commons:Upload Wizard">Upload Wizard</a>. </p> <dl><dt>How many files can I upload in one session or project? Can I upload 10,000s or even 100,000s of files at once?</dt></dl> <p>OpenRefine can easily handle datasets of up to tens of thousands (potentially hundreds of thousands) of rows of data. The bottleneck is the speed of uploading files to Wikimedia Commons, which is regulated by the Wikimedia Commons API. For an upload of thousands of files at once (or more), you will need some patience and you will need to keep OpenRefine open. </p> <dl><dt>Can OpenRefine retrieve embedded metadata from files (like EXIF metadata)?</dt></dl> <p>This is not possible inside OpenRefine. We recommend using EXIFtool <a rel="nofollow" class="external free" href="https://exiftool.org">https://exiftool.org</a>. <a rel="nofollow" class="external text" href="https://www.youtube.com/watch?v=zEx09F4hBvQ&ab_channel=LimJetWee">This YouTube video</a> explains the process quite clearly. </p> <dl><dt>What are the (dis)advantages of running OpenRefine locally? What are the (dis)advantages of the cloud (PAWS) version of OpenRefine?</dt></dl> <p>When running OpenRefine locally (on your own computer): </p> <ul><li>On your own computer, it will especially be easier when you want to do file uploads to Wikimedia Commons. You will be able to upload files from your own local harddrive. This is not possible on PAWS.</li> <li>On your own computer, you can do various tasks (especially data cleanup and joining/splitting data) without an internet connection. You do need an internet connect as soon as you want to do reconciliation and upload data and files to Commons and Wikidata.</li></ul> <p>When running OpenRefine in the cloud (via Wikimedia PAWS): </p> <ul><li>The cloud version is convenient when you can't easily install new software on your own computer.</li> <li>You always need a live internet connection for this.</li> <li>With this PAWS/cloud version, it is not possible to upload images from your local computer.</li></ul> <p><br/> </p> <div style="background-color: #eaf3ff; border-left: 5px solid #3366cc; padding: 15px 20px; border-radius: 2px;"> <dl><dt>General links</dt></dl> <ul><li>OpenRefine's website: <a rel="nofollow" class="external free" href="https://www.openrefine.org/">https://www.openrefine.org/</a></li> <li>Download OpenRefine: <a rel="nofollow" class="external free" href="https://openrefine.org/download.html">https://openrefine.org/download.html</a></li> <li>Download and install the Wikimedia Commons extension for OpenRefine: <a rel="nofollow" class="external free" href="https://github.com/OpenRefine/CommonsExtension">https://github.com/OpenRefine/CommonsExtension</a></li> <li>General OpenRefine documentation: <a rel="nofollow" class="external free" href="https://openrefine.org/docs">https://openrefine.org/docs</a></li></ul> <dl><dt>Talk about OpenRefine with its community and with Wikimedia users</dt></dl> <ul><li>Ask questions on OpenRefine's community forum: <a rel="nofollow" class="external free" href="https://forum.openrefine.org">https://forum.openrefine.org</a> - <a rel="nofollow" class="external text" href="http://forum.openrefine.org/new-topic?category=support&tags=wikimedia-commons">Click here to create a new post on OpenRefine's forum</a></li> <li>Telegram group for Wikimedians who use OpenRefine: <a rel="nofollow" class="external free" href="https://t.me/+Qc23Jlay6f4wOGQ0">https://t.me/+Qc23Jlay6f4wOGQ0</a></li></ul> <dl><dt>Bug reports and feature requests</dt></dl> <ul><li>On GitHub (for OpenRefine in general): <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/OpenRefine/issues/new?assignees=&labels=enhancement%2C+to+be+reviewed&template=feature_request.md&title=">Post a feature request on GitHub</a></li> <li>On Wikimedia Phabricator (mainly for Wikimedia Commons reconciliation): <a class="external text" href="https://phabricator.wikimedia.org/maniphest/task/edit/form/43/?tags=openrefine">Post a bug report on Phabricator</a></li></ul> </div> </div> <div class="restwocol-additional"> <div style="background-color: #eaf3ff; border-left: 5px solid #3366cc; padding: 15px 20px; border-radius: 2px;"> <figure class="mw-halign-right" typeof="mw:File/Frameless"><a href="/wiki/File:OpenRefine_logo_(2018-present).svg" class="mw-file-description" title="OpenRefine logo"><img alt="OpenRefine logo" src="https://upload.wikimedia.org/wikipedia/commons/thumb/b/bd/OpenRefine_logo_%282018-present%29.svg/200px-OpenRefine_logo_%282018-present%29.svg.png" decoding="async" width="200" height="57" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/b/bd/OpenRefine_logo_%282018-present%29.svg/300px-OpenRefine_logo_%282018-present%29.svg.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/b/bd/OpenRefine_logo_%282018-present%29.svg/400px-OpenRefine_logo_%282018-present%29.svg.png 2x" data-file-width="817" data-file-height="234"/></a><figcaption>OpenRefine logo</figcaption></figure> <p><big><b><a href="/wiki/Category:Uploaded_with_OpenRefine" title="Category:Uploaded with OpenRefine">527,104</a></b> files have been uploaded with OpenRefine.</big> </p><p><small> </small></p><small> <ul><li><a class="external text" href="https://commons.wikimedia.org/w/index.php?hidebots=1&translations=filter&hidecategorization=1&hideWikibase=1&tagfilter=openrefine-3.7&limit=500&days=30&enhanced=1&title=Special:RecentChanges&urlversion=2">Wikimedia Commons edits with OpenRefine 3.7</a></li> <li><a href="/wiki/Category:Uploaded_with_OpenRefine" title="Category:Uploaded with OpenRefine">Wikimedia Commons files uploaded with OpenRefine</a></li> <li><a class="external text" href="https://ptools.toolforge.org/filesincat.php?category=Uploaded+with+OpenRefine">Uploaded files per month</a></li> <li><a class="external text" href="https://editgroups-commons.toolforge.org/?tool=OR">Last batches on Wikimedia Commons with OpenRefine (via EditGroups)</a></li> <li><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Metrics" title="Special:MyLanguage/Commons:OpenRefine/Metrics">More metrics</a></li></ul> </small><p><small></small> </p> </div> <p><br/> </p> <div style="display:inline-flex; flex-direction:row; align-items: center; background-color: #f2f2f2; border-radius: 4px; border: 1px solid #006b15; float: right; clear: right; box-shadow: 0 2px 1px rgba(0,0,0,0.1); margin: 5px 10px;"> <div style="padding: 7px 10px; background-color: white; border-radius: 4px 0 0 4px;"><span typeof="mw:File"><a href="/wiki/File:Coolest_Tool_Award_2022_square_logo.svg" class="mw-file-description"><img alt="Coolest Tool Award 2022 logo" src="https://upload.wikimedia.org/wikipedia/commons/thumb/8/83/Coolest_Tool_Award_2022_square_logo.svg/120px-Coolest_Tool_Award_2022_square_logo.svg.png" decoding="async" width="120" height="121" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/8/83/Coolest_Tool_Award_2022_square_logo.svg/180px-Coolest_Tool_Award_2022_square_logo.svg.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/8/83/Coolest_Tool_Award_2022_square_logo.svg/240px-Coolest_Tool_Award_2022_square_logo.svg.png 2x" data-file-width="1565" data-file-height="1583"/></a></span></div> <div style="text-align:center; padding: 5px 10px;"> <p style="margin-top: 0;">Open Refine</p> <p style="font-family: Impact, Charcoal, sans-serif; text-transform: uppercase; line-height:1.1;"> <a href="https://meta.wikimedia.org/wiki/Coolest_Tool_Award" class="extiw" title="m:Coolest Tool Award"><span style="font-size: 18px; color: #666666;"><span style="color: #006b15">2022</span> Coolest Tool</span><br/><span style="font-size: 22px; color: black;">Award Winner</span></a> </p> <p style="line-height:1.1; margin-bottom: 0;"> <span style="font-size:smaller">in the category</span> <br/> <span style="font-weight:bold;color:#006b15;">Eggbeater</span> </p> </div> </div> <div style="clear:both;"></div> <p><br/> </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Learn_to_use_OpenRefine_for_Wikimedia_Commons:_WikiLearn_course" data-mw-thread-id="h-Learn_to_use_OpenRefine_for_Wikimedia_Commons:_WikiLearn_course"><span data-mw-comment-start="" id="h-Learn_to_use_OpenRefine_for_Wikimedia_Commons:_WikiLearn_course"></span>Learn to use OpenRefine for Wikimedia Commons: WikiLearn course<span data-mw-comment-end="h-Learn_to_use_OpenRefine_for_Wikimedia_Commons:_WikiLearn_course"></span></h2></div> <p><small>This online course is available at any time, for free, for anyone with a Wikimedia account. It can be followed at your own pace, with computer-graded exercises. Following the course takes an average of 6 to 8 hours.<i></i></small> </p> <div style="background-color: #eee; border-left: 5px solid #3366cc; padding: 15px 20px; border-radius: 2px;"> <figure class="mw-halign-right" typeof="mw:File/Frameless"><a href="/wiki/File:OpenRefine_Wikimedia_commons_course_on_WikiLearn.png" class="mw-file-description"><img src="https://upload.wikimedia.org/wikipedia/commons/thumb/5/59/OpenRefine_Wikimedia_commons_course_on_WikiLearn.png/120px-OpenRefine_Wikimedia_commons_course_on_WikiLearn.png" decoding="async" width="120" height="67" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/5/59/OpenRefine_Wikimedia_commons_course_on_WikiLearn.png/180px-OpenRefine_Wikimedia_commons_course_on_WikiLearn.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/5/59/OpenRefine_Wikimedia_commons_course_on_WikiLearn.png/240px-OpenRefine_Wikimedia_commons_course_on_WikiLearn.png 2x" data-file-width="606" data-file-height="337"/></a><figcaption></figcaption></figure> <p>Start <b><a rel="nofollow" class="external text" href="https://learn.wiki/courses/course-v1:Wikimedia-Foundation+WMF_GLAM001+2023/about">the WikiLearn course: OpenRefine for Wikimedia Commons: the basics</a></b>. </p> </div> <p><br/> </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Upload_files_to_Wikimedia_Commons_with_OpenRefine_(version_3.7)" data-mw-thread-id="h-Upload_files_to_Wikimedia_Commons_with_OpenRefine_(version_3.7)"><span id="Upload_files_to_Wikimedia_Commons_with_OpenRefine_.28version_3.7.29"></span><span data-mw-comment-start="" id="h-Upload_files_to_Wikimedia_Commons_with_OpenRefine_(version_3.7)"></span>Upload files to Wikimedia Commons with OpenRefine (version 3.7)<span data-mw-comment-end="h-Upload_files_to_Wikimedia_Commons_with_OpenRefine_(version_3.7)"></span></h2></div> <p><small>For uploading files to Wikimedia Commons, you need <b>OpenRefine 3.7</b>. <i>Wikimedia Commons upload is <b>not</b> supported in OpenRefine 3.6 or earlier versions.</i></small> </p> <div style="background-color: #eee; border-left: 5px solid #3366cc; padding: 15px 20px; border-radius: 2px;"> <figure class="mw-halign-right" typeof="mw:File/Frameless"><a href="/wiki/File:Data_and_media_partnerships_workflow_-_upload.png" class="mw-file-description"><img src="https://upload.wikimedia.org/wikipedia/commons/thumb/3/36/Data_and_media_partnerships_workflow_-_upload.png/120px-Data_and_media_partnerships_workflow_-_upload.png" decoding="async" width="120" height="98" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/3/36/Data_and_media_partnerships_workflow_-_upload.png/180px-Data_and_media_partnerships_workflow_-_upload.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/3/36/Data_and_media_partnerships_workflow_-_upload.png/240px-Data_and_media_partnerships_workflow_-_upload.png 2x" data-file-width="800" data-file-height="650"/></a><figcaption></figcaption></figure> <p>Follow <b><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Uploading_files_with_OpenRefine" title="Special:MyLanguage/Commons:OpenRefine/Uploading files with OpenRefine">the step by step guide (how-to) to edit Wikimedia Commons files with OpenRefine</a></b>. </p> </div> <p><br/> </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Edit_files_on_Wikimedia_Commons_with_OpenRefine_(version_3.6_and_newer)" data-mw-thread-id="h-Edit_files_on_Wikimedia_Commons_with_OpenRefine_(version_3.6_and_newer)"><span id="Edit_files_on_Wikimedia_Commons_with_OpenRefine_.28version_3.6_and_newer.29"></span><span data-mw-comment-start="" id="h-Edit_files_on_Wikimedia_Commons_with_OpenRefine_(version_3.6_and_newer)"></span>Edit files on Wikimedia Commons with OpenRefine (version 3.6 and newer)<span data-mw-comment-end="h-Edit_files_on_Wikimedia_Commons_with_OpenRefine_(version_3.6_and_newer)"></span></h2></div> <p><small>For editing Wikimedia Commons, you need <b>OpenRefine 3.6</b> or newer. <i>Wikimedia Commons is <b>not</b> supported in OpenRefine 3.5 or earlier versions.</i> It is highly recommended to also install <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/CommonsExtension">OpenRefine's Wikimedia Commons extension</a>.</small> </p> <div style="background-color: #eee; border-left: 5px solid #3366cc; padding: 15px 20px; border-radius: 2px;"> <figure class="mw-halign-right" typeof="mw:File/Frameless"><a href="/wiki/File:Data_and_media_partnerships_workflow_-_enrich.png" class="mw-file-description"><img src="https://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Data_and_media_partnerships_workflow_-_enrich.png/120px-Data_and_media_partnerships_workflow_-_enrich.png" decoding="async" width="120" height="98" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Data_and_media_partnerships_workflow_-_enrich.png/180px-Data_and_media_partnerships_workflow_-_enrich.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Data_and_media_partnerships_workflow_-_enrich.png/240px-Data_and_media_partnerships_workflow_-_enrich.png 2x" data-file-width="800" data-file-height="650"/></a><figcaption></figcaption></figure> <p>Follow <b><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Adding_structured_data_with_OpenRefine" title="Special:MyLanguage/Commons:OpenRefine/Adding structured data with OpenRefine">the step by step guide (how-to) to edit Wikimedia Commons files with OpenRefine</a></b>. </p> </div> <p><br/> </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Advanced_tips_and_tricks" data-mw-thread-id="h-Advanced_tips_and_tricks"><span data-mw-comment-start="" id="h-Advanced_tips_and_tricks"></span>Advanced tips and tricks<span data-mw-comment-end="h-Advanced_tips_and_tricks"></span></h2></div> <div style="background-color: #eee; border-left: 5px solid #3366cc; padding: 15px 20px; border-radius: 2px;"> <p>There is also a page with <b><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Advanced_tips_and_tricks" title="Special:MyLanguage/Commons:OpenRefine/Advanced tips and tricks">advanced tips and tricks</a></b>, which include more instructions on working with manifests and reconciliation, retrieving EXIF, special GREL recipes, and more. Add your own! </p> </div> <p><br/> </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Install_and_run_OpenRefine" data-mw-thread-id="h-Install_and_run_OpenRefine"><span data-mw-comment-start="" id="h-Install_and_run_OpenRefine"></span>Install and run OpenRefine<span data-mw-comment-end="h-Install_and_run_OpenRefine"></span></h2></div> <div class="mw-heading mw-heading3"><h3 id="As_a_local_application_on_your_computer" data-mw-thread-id="h-As_a_local_application_on_your_computer-Install_and_run_OpenRefine"><span data-mw-comment-start="" id="h-As_a_local_application_on_your_computer-Install_and_run_OpenRefine"></span>As a local application on your computer<span data-mw-comment-end="h-As_a_local_application_on_your_computer-Install_and_run_OpenRefine"></span></h3></div> <p>OpenRefine can be downloaded as an application and works on desktop and laptop computers with Windows, Mac and Linux operating systems. It runs a small server on your computer and you then use a web browser to interact with it. It works best with browsers based on Webkit, such as Google Chrome, Chromium, Opera and Microsoft Edge, and is also supported on Firefox. </p><p>You can <a rel="nofollow" class="external text" href="https://openrefine.org/download.html">download OpenRefine here</a>. <a rel="nofollow" class="external text" href="https://docs.openrefine.org/manual/installing">Installation instructions are available in OpenRefine's user manual</a>. </p> <div class="mw-heading mw-heading4"><h4 id="Wikimedia_Commons_extension_for_OpenRefine" data-mw-thread-id="h-Wikimedia_Commons_extension_for_OpenRefine-As_a_local_application_on_your_computer"><span data-mw-comment-start="" id="h-Wikimedia_Commons_extension_for_OpenRefine-As_a_local_application_on_your_computer"></span>Wikimedia Commons extension for OpenRefine<span data-mw-comment-end="h-Wikimedia_Commons_extension_for_OpenRefine-As_a_local_application_on_your_computer"></span></h4></div> <figure class="mw-halign-left" typeof="mw:File/Frameless"><a href="/wiki/File:GitHub_-_Wikimedia_Commons_extension_for_OpenRefine.png" class="mw-file-description"><img alt="Screenshot of GitHub page of the Wikimedia Commons extension for OpenRefine" src="https://upload.wikimedia.org/wikipedia/commons/thumb/a/a0/GitHub_-_Wikimedia_Commons_extension_for_OpenRefine.png/300px-GitHub_-_Wikimedia_Commons_extension_for_OpenRefine.png" decoding="async" width="300" height="266" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/a/a0/GitHub_-_Wikimedia_Commons_extension_for_OpenRefine.png/450px-GitHub_-_Wikimedia_Commons_extension_for_OpenRefine.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/a/a0/GitHub_-_Wikimedia_Commons_extension_for_OpenRefine.png/600px-GitHub_-_Wikimedia_Commons_extension_for_OpenRefine.png 2x" data-file-width="2312" data-file-height="2050"/></a><figcaption></figcaption></figure> <div style="clear:both;"></div> <p>Additionally, you can also install <a rel="nofollow" class="external text" href="https://github.com/OpenRefine/CommonsExtension">OpenRefine's Wikimedia Commons extension</a>. This is not necessary, but helpful for Wikimedia Commons batch editing. It offers: </p> <ul><li>A start screen to load file names directly from Wikimedia Commons categories.</li> <li>Thumbnails of Commons files (not all file formats supported yet).</li> <li>Several dedicated GREL expressions to retrieve data from wikitext for further processing.</li></ul> <p>Download and installation instructions are available at <a rel="nofollow" class="external free" href="https://github.com/OpenRefine/CommonsExtension">https://github.com/OpenRefine/CommonsExtension</a> </p> <div class="mw-heading mw-heading3"><h3 id="In_the_cloud_(via_Wikimedia_PAWS)" data-mw-thread-id="h-In_the_cloud_(via_Wikimedia_PAWS)-Install_and_run_OpenRefine"><span id="In_the_cloud_.28via_Wikimedia_PAWS.29"></span><span data-mw-comment-start="" id="h-In_the_cloud_(via_Wikimedia_PAWS)-Install_and_run_OpenRefine"></span>In the cloud (via Wikimedia PAWS)<span data-mw-comment-end="h-In_the_cloud_(via_Wikimedia_PAWS)-Install_and_run_OpenRefine"></span></h3></div> <p>If you are unable to install OpenRefine on your computer, or if it runs very slowly, then you can also use it in the cloud (on wmcloud.org through <a href="https://wikitech.wikimedia.org/wiki/PAWS" class="extiw" title="wikitech:PAWS">PAWS</a>). Everyone with a Wikimedia account can access OpenRefine here. Visit <a rel="nofollow" class="external free" href="https://hub-paws.wmcloud.org/">https://hub-paws.wmcloud.org/</a>, log in, and click on the OpenRefine (blue diamond) logo. </p><p>The Wikimedia Commons extension (mentioned above) is installed in OpenRefine on PAWS. Please note: with OpenRefine on PAWS it is NOT possible to upload files to Wikimedia Commons from your local computer. </p><p><span class="plainlinks"><a rel="nofollow" class="external text" href="https://hub-paws.wmcloud.org/hub/login"><span class="submit ui-button ui-widget ui-state-default ui-corner-all ui-button-text-icon-primary ui-button-blue ui-button-large" role="button"><span class="ui-button-icon-primary ui-icon ui-icon-play"> </span><span class="ui-button-text"><b>Launch PAWS</b></span></span></a></span> </p><p>Demo: start OpenRefine on Wikimedia PAWS </p> <figure class="mw-halign-left" typeof="mw:File/Frameless"><span><video id="mwe_player_0" poster="https://upload.wikimedia.org/wikipedia/commons/thumb/c/cb/Starting_OpenRefine_on_Wikimedia_PAWS.webm/300px--Starting_OpenRefine_on_Wikimedia_PAWS.webm.jpg" controls="" preload="none" data-mw-tmh="" class="mw-file-element" width="300" height="169" data-durationhint="76" data-mwtitle="Starting_OpenRefine_on_Wikimedia_PAWS.webm" data-mwprovider="local"><source src="https://upload.wikimedia.org/wikipedia/commons/transcoded/c/cb/Starting_OpenRefine_on_Wikimedia_PAWS.webm/Starting_OpenRefine_on_Wikimedia_PAWS.webm.480p.vp9.webm" type="video/webm; codecs="vp9, opus"" data-transcodekey="480p.vp9.webm" data-width="854" data-height="480"/><source src="https://upload.wikimedia.org/wikipedia/commons/transcoded/c/cb/Starting_OpenRefine_on_Wikimedia_PAWS.webm/Starting_OpenRefine_on_Wikimedia_PAWS.webm.720p.vp9.webm" type="video/webm; codecs="vp9, opus"" data-transcodekey="720p.vp9.webm" data-width="1280" data-height="720"/><source src="https://upload.wikimedia.org/wikipedia/commons/c/cb/Starting_OpenRefine_on_Wikimedia_PAWS.webm" type="video/webm; codecs="vp9, vorbis"" data-width="1280" data-height="720"/><source src="https://upload.wikimedia.org/wikipedia/commons/transcoded/c/cb/Starting_OpenRefine_on_Wikimedia_PAWS.webm/Starting_OpenRefine_on_Wikimedia_PAWS.webm.240p.vp9.webm" type="video/webm; codecs="vp9, opus"" data-transcodekey="240p.vp9.webm" data-width="426" data-height="240"/><source src="https://upload.wikimedia.org/wikipedia/commons/transcoded/c/cb/Starting_OpenRefine_on_Wikimedia_PAWS.webm/Starting_OpenRefine_on_Wikimedia_PAWS.webm.360p.vp9.webm" type="video/webm; codecs="vp9, opus"" data-transcodekey="360p.vp9.webm" data-width="640" data-height="360"/><source src="https://upload.wikimedia.org/wikipedia/commons/transcoded/c/cb/Starting_OpenRefine_on_Wikimedia_PAWS.webm/Starting_OpenRefine_on_Wikimedia_PAWS.webm.360p.webm" type="video/webm; codecs="vp8, vorbis"" data-transcodekey="360p.webm" data-width="640" data-height="360"/><track src="/w/api.php?action=timedtext&title=File%3AStarting_OpenRefine_on_Wikimedia_PAWS.webm&lang=en&trackformat=vtt" kind="subtitles" type="text/vtt" srclang="en" label="English ‪(en)‬" data-dir="ltr"/><track src="/w/api.php?action=timedtext&title=File%3AStarting_OpenRefine_on_Wikimedia_PAWS.webm&lang=es&trackformat=vtt" kind="subtitles" type="text/vtt" srclang="es" label="español ‪(es)‬" data-dir="ltr"/><track src="/w/api.php?action=timedtext&title=File%3AStarting_OpenRefine_on_Wikimedia_PAWS.webm&lang=fr&trackformat=vtt" kind="subtitles" type="text/vtt" srclang="fr" label="français ‪(fr)‬" data-dir="ltr"/><track src="/w/api.php?action=timedtext&title=File%3AStarting_OpenRefine_on_Wikimedia_PAWS.webm&lang=it&trackformat=vtt" kind="subtitles" type="text/vtt" srclang="it" label="italiano ‪(it)‬" data-dir="ltr"/></video></span><figcaption></figcaption></figure> <div style="clear:both;"></div> <div style="background-color: #eee; border-left: 5px solid #3366cc; padding: 15px 20px; border-radius: 2px;"> <figure class="mw-halign-right" typeof="mw:File/Frameless"><a href="/wiki/File:PAWS_(no_text).svg" class="mw-file-description"><img alt="PAWS logo" src="https://upload.wikimedia.org/wikipedia/commons/thumb/7/77/PAWS_%28no_text%29.svg/60px-PAWS_%28no_text%29.svg.png" decoding="async" width="60" height="64" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/7/77/PAWS_%28no_text%29.svg/90px-PAWS_%28no_text%29.svg.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/7/77/PAWS_%28no_text%29.svg/120px-PAWS_%28no_text%29.svg.png 2x" data-file-width="246" data-file-height="263"/></a><figcaption></figcaption></figure> <p>OpenRefine via PAWS is <i>not</i> managed by the OpenRefine team; if you have any questions or comments about this service, you can submit a ticket in the <a href="https://phabricator.wikimedia.org/tag/paws/" class="extiw" title="phab:tag/paws/">PAWS project on Phabricator</a> or <a href="https://wikitech.wikimedia.org/wiki/Talk:PAWS" class="extiw" title="wikitech:Talk:PAWS">ask a question on its talk page</a>. </p> </div> </div> </div> <p><br/> </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Log_of_past_activities,_presentations..." data-mw-thread-id="h-Log_of_past_activities,_presentations..."><span id="Log_of_past_activities.2C_presentations..."></span><span data-mw-comment-start="" id="h-Log_of_past_activities,_presentations..."></span>Log of past activities, presentations...<span data-mw-comment-end="h-Log_of_past_activities,_presentations..."></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Commons:OpenRefine&action=edit&section=10" title="Edit section: Log of past activities, presentations..."><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <table class="wikitable"> <tbody><tr> <th>When </th> <th>Activity </th> <th>Links </th></tr> <tr> <td>July 2023-June 2024 </td> <td>OpenRefine and Wikimedia Commons training and sustainability project (funded from Wikimedia Foundation funds) </td> <td> <ul><li><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Training_2023-24" title="Special:MyLanguage/Commons:OpenRefine/Training 2023-24">Project page</a></li></ul> <ul><li><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Train-the-trainer_program_2023-24/Registration_form_questions" title="Special:MyLanguage/Commons:OpenRefine/Train-the-trainer program 2023-24/Registration form questions">Train-the-trainer program</a></li> <li><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Training_2023-24/Midpoint_report" title="Special:MyLanguage/Commons:OpenRefine/Training 2023-24/Midpoint report">Midpoint report</a></li></ul> </td></tr> <tr> <td>August 13, 2022 </td> <td>Tutorial: <a href="https://wikimania.wikimedia.org/wiki/2022:Submissions/Batch_uploading_to_Wikimedia_Commons_with_OpenRefine" class="extiw" title="wmania:2022:Submissions/Batch uploading to Wikimedia Commons with OpenRefine">Batch uploading to Wikimedia Commons with OpenRefine</a> at Wikimania 2022 </td> <td><a href="https://etherpad.wikimedia.org/p/wikimania2022-batch-uploading/timeslider#3261" class="extiw" title="etherpad:p/wikimania2022-batch-uploading/timeslider">Etherpad</a> / Video recording </td></tr> <tr> <td>June 9, 2022 </td> <td>OpenRefine and SDC editing tutorial, <a href="https://pt.wikipedia.org/wiki/Wikip%C3%A9dia:Edit-a-thon/Atividades_em_portugu%C3%AAs/Wikidata_Lab_XXXIV" class="extiw" title="pt:Wikipédia:Edit-a-thon/Atividades em português/Wikidata Lab XXXIV">Wikidata Lab XXXIV</a> </td> <td><a href="/wiki/File:Wikidata_Lab_XXXIV_-_OpenRefine_and_Structured_Data_on_Commons.webm" title="File:Wikidata Lab XXXIV - OpenRefine and Structured Data on Commons.webm">Video recording</a> </td></tr> <tr> <td>May 19, 2022 </td> <td>One hour demo for beginners: Wikimedia Commons batch editing with OpenRefine (tutorial by Sandra Fauconnier), during Image Description Week </td> <td> </td></tr> <tr> <td>March–June 2022 </td> <td>Monthly OpenRefine office hours </td> <td>No notes/recordings (the meetings were informal) </td></tr> <tr> <td>February 22, 2022 </td> <td>OpenRefine community meetup with demo of Structured Data on Commons functionalities </td> <td><a href="/wiki/Special:MyLanguage/Commons:OpenRefine/Community_meetup_22_February_2022" title="Special:MyLanguage/Commons:OpenRefine/Community meetup 22 February 2022">Slides and meeting recording</a> </td></tr> <tr> <td>July 2021 – October 2022 </td> <td>Development of Wikimedia Commons features for OpenRefine (<a href="https://meta.wikimedia.org/wiki/Grants:Project/CS%26S/Structured_Data_on_Wikimedia_Commons_functionalities_in_OpenRefine" class="extiw" title="metawiki:Grants:Project/CS&S/Structured Data on Wikimedia Commons functionalities in OpenRefine">funded by a Wikimedia Foundation Project Grant</a>) </td> <td> <ul><li><a href="https://meta.wikimedia.org/wiki/Grants:Project/CS%26S/Structured_Data_on_Wikimedia_Commons_functionalities_in_OpenRefine/Timeline" class="extiw" title="metawiki:Grants:Project/CS&S/Structured Data on Wikimedia Commons functionalities in OpenRefine/Timeline">Monthly reports</a></li> <li><a href="https://meta.wikimedia.org/wiki/Grants:Project/CS%26S/Structured_Data_on_Wikimedia_Commons_functionalities_in_OpenRefine/Midpoint" class="extiw" title="metawiki:Grants:Project/CS&S/Structured Data on Wikimedia Commons functionalities in OpenRefine/Midpoint">Midpoint report</a></li> <li>Final report (Nov 2022)</li> <li><a rel="nofollow" class="external text" href="https://github.com/orgs/OpenRefine/projects/2/views/1">Project board on GitHub (OpenRefine)</a></li></ul> </td></tr></tbody></table> <p><br/> </p><p><br/> </p> <div role="navigation" class="navbox" aria-labelledby="Structured_Data_on_Wikimedia_Commons" style="padding:3px"><table class="nowraplinks collapsible uncollapsed navbox-inner" lang="en" dir="ltr" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="3"><div class="plainlinks hlist navbar mini"><ul><li class="nv-view"><a href="/wiki/Commons:Structured_data/Navbox" title="Commons:Structured data/Navbox"><span title="View this template" style=";;background:none transparent;border:none;-moz-box-shadow:none;-webkit-box-shadow:none;box-shadow:none; padding:0;">v</span></a></li><li class="nv-talk"><a href="/wiki/Commons_talk:Structured_data/Navbox" title="Commons talk:Structured data/Navbox"><span title="Discuss this template" style=";;background:none transparent;border:none;-moz-box-shadow:none;-webkit-box-shadow:none;box-shadow:none; padding:0;">t</span></a></li><li class="nv-edit"><a class="external text" href="https://commons.wikimedia.org/w/index.php?title=Commons:Structured_data/Navbox&action=edit"><span title="Edit this template" style=";;background:none transparent;border:none;-moz-box-shadow:none;-webkit-box-shadow:none;box-shadow:none; padding:0;">e</span></a></li></ul></div><div id="Structured_Data_on_Wikimedia_Commons" style="font-size:114%;margin:0 4em"><a href="/wiki/Commons:Structured_data" title="Commons:Structured data">Structured Data on Wikimedia Commons</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Features</th><td class="navbox-list navbox-odd hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Commons:File_captions" title="Commons:File captions">File captions</a></li> <li><a href="/wiki/Commons:Depicts" title="Commons:Depicts">Depicts</a></li> <li><a href="/wiki/Commons:Statements" title="Commons:Statements">Statements</a></li> <li><a href="/wiki/Commons:Structured_data/Features_glossary" title="Commons:Structured data/Features glossary">Glossary</a></li></ul> </div></td><td class="navbox-image" rowspan="9" style="width:1px;padding:0 0 0 2px"><div><span typeof="mw:File"><a href="/wiki/File:Wikidata_for_Commons-logo.svg" class="mw-file-description"><img src="https://upload.wikimedia.org/wikipedia/commons/thumb/c/c0/Wikidata_for_Commons-logo.svg/80px-Wikidata_for_Commons-logo.svg.png" decoding="async" width="80" height="108" class="mw-file-element" srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/c/c0/Wikidata_for_Commons-logo.svg/120px-Wikidata_for_Commons-logo.svg.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/c/c0/Wikidata_for_Commons-logo.svg/160px-Wikidata_for_Commons-logo.svg.png 2x" data-file-width="1024" data-file-height="1376"/></a></span></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Tools</th><td class="navbox-list navbox-even hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Commons:Structured_data/Computer-aided_tagging" title="Commons:Structured data/Computer-aided tagging">Computer-aided tagging</a></li> <li><a href="/wiki/Commons:ISA_Tool" title="Commons:ISA Tool">ISA</a></li> <li><a href="/wiki/Commons:Depictor" title="Commons:Depictor">Depictor</a></li> <li><a href="/wiki/Help:Gadget-ACDC" title="Help:Gadget-ACDC">AC/DC</a></li> <li><a href="/wiki/User:Magnus_Manske/sdc_tool.js" title="User:Magnus Manske/sdc tool.js">SDC tool</a></li> <li><a class="mw-selflink selflink">OpenRefine</a></li> <li><a href="https://www.wikidata.org/wiki/Help:QuickStatements" class="extiw" title="d:Help:QuickStatements">QuickStatements</a></li> <li><a href="/wiki/Commons:SPARQL_query_service" title="Commons:SPARQL query service">SPARQL query service</a></li> <li><a class="external text" href="https://image-annotator.toolforge.org/">Image Annotator</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">About</th><td class="navbox-list navbox-odd hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><b><a href="/wiki/Commons:Structured_data/About" title="Commons:Structured data/About">About Structured Commons</a></b></li> <li><a href="/wiki/Commons:Structured_data/About/Why" title="Commons:Structured data/About/Why">Why we work on this</a></li> <li><a href="/wiki/Commons:Structured_data/About/Platforms" title="Commons:Structured data/About/Platforms">Structured data on other projects</a></li> <li><a href="/wiki/Commons:Structured_data/About/Press_and_presentations" title="Commons:Structured data/About/Press and presentations">Press and presentations</a></li> <li><a href="/wiki/Commons:Structured_data/Project_glossary" title="Commons:Structured data/Project glossary">Project glossary</a></li> <li><a href="/wiki/Commons:Structured_data/Stable_Interface_Policy" title="Commons:Structured data/Stable Interface Policy">Stable Interface Policy</a></li> <li><a href="/wiki/Commons:Structured_data/About/Contact" title="Commons:Structured data/About/Contact">Contact</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Get involved</th><td class="navbox-list navbox-even hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><b><a href="/wiki/Commons:Structured_data/Community" title="Commons:Structured data/Community">How to get involved</a></b></li> <li><a href="/wiki/Commons:Structured_data/Get_involved/Finding_data" title="Commons:Structured data/Get involved/Finding data">How to find structured data on Commons</a></li> <li><a href="/wiki/Commons:Structured_data/Modeling" title="Commons:Structured data/Modeling">Help determine how Structured Data metadata should be modelled on Commons</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">GLAM</th><td class="navbox-list navbox-odd hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><b><a href="/wiki/Commons:Structured_data/GLAM" title="Commons:Structured data/GLAM">Structured Data on Commons for Galleries, Libraries, Archives, and Museums</a></b></li> <li><a href="/wiki/Commons:Structured_data/GLAM/Why" title="Commons:Structured data/GLAM/Why">Value for GLAMs</a></li> <li><a href="/wiki/Commons:Structured_data/GLAM/Platform" title="Commons:Structured data/GLAM/Platform">Commons or Wikidata</a></li> <li><a href="/wiki/Commons:Structured_data/GLAM/Uploading" title="Commons:Structured data/GLAM/Uploading">How to upload</a></li> <li><a href="/wiki/Commons:Structured_data/GLAM/Tools" title="Commons:Structured data/GLAM/Tools">Tools for GLAMs</a></li> <li><a href="/wiki/Commons:Structured_data/GLAM/Workflow" title="Commons:Structured data/GLAM/Workflow">Workflow for GLAMs</a></li> <li><a href="/wiki/Commons:Structured_data/GLAM/Projects" title="Commons:Structured data/GLAM/Projects">Examples</a></li> <li><a href="/wiki/Commons:Structured_data/GLAM/Events" title="Commons:Structured data/GLAM/Events">Events and workshops</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Modeling</th><td class="navbox-list navbox-even hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><b><a href="/wiki/Commons:Structured_data/Modeling" title="Commons:Structured data/Modeling">Data modeling: guidelines on how to describe Wikimedia Commons files with structured data</a></b></li> <li><a href="/wiki/Commons:Structured_data/Properties_table" title="Commons:Structured data/Properties table">Properties table</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Discussion</th><td class="navbox-list navbox-odd hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><b><a href="/wiki/Commons_talk:Structured_data" title="Commons talk:Structured data">General talk page</a></b></li> <li><a href="/wiki/Commons_talk:Structured_data/Modeling" title="Commons talk:Structured data/Modeling">Talk page about data modeling</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">In other projects</th><td class="navbox-list navbox-even hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><b><a href="https://phabricator.wikimedia.org/project/board/34/" class="extiw" title="phab:project/board/34/">Phabricator</a></b> (tasks, bug reports)</li> <li><b><a href="https://www.mediawiki.org/wiki/Readers/Structured_Data" class="extiw" title="mw:Readers/Structured Data">mediawiki.org</a></b> (project reports)</li> <li><b><a href="https://meta.wikimedia.org/wiki/Special:MyLanguage/Structured_Data_on_Commons" class="extiw" title="meta:Special:MyLanguage/Structured Data on Commons">meta.wikimedia.org</a></b> (general background)</li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Related</th><td class="navbox-list navbox-odd hlist" style="text-align:left;border-left-width:2px;border-left-style:solid;width:auto;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Commons:Media_search" title="Commons:Media search">Media search</a></li> <li><a href="https://www.mediawiki.org/wiki/Structured_data_across_Wikimedia" class="extiw" title="mw:Structured data across Wikimedia">Structured data across Wikimedia (SDAW)</a></li> <li><a href="/wiki/Commons:International_Image_Interoperability_Framework" title="Commons:International Image Interoperability Framework">International Image Interoperability Framework</a> (IIIF)</li></ul> </div></td></tr><tr><td class="navbox-abovebelow hlist" colspan="3"><div> <ul><li><b><a href="/wiki/Category:Archived_pages_about_Structured_Data_on_Commons" title="Category:Archived pages about Structured Data on Commons">Archived info about Structured Commons</a></b></li> <li><a href="/wiki/Commons:Structured_data/Sloan_Grant" title="Commons:Structured data/Sloan Grant">Information and discussion about the project grant from the Alfred P. Sloan Foundation</a></li></ul> </div></td></tr></tbody></table></div>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1&useformat=desktop" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://commons.wikimedia.org/w/index.php?title=Commons:OpenRefine&oldid=918206684">https://commons.wikimedia.org/w/index.php?title=Commons:OpenRefine&oldid=918206684</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Special:Categories" title="Special:Categories">Categories</a>: <ul><li><a href="/wiki/Category:Structured_Data_on_Commons" title="Category:Structured Data on Commons">Structured Data on Commons</a></li><li><a href="/wiki/Category:OpenRefine" title="Category:OpenRefine">OpenRefine</a></li></ul></div></div> </div> </div> <div id="mw-navigation"> <h2>Navigation menu</h2> <div id="mw-head"> <nav id="p-personal" class="mw-portlet mw-portlet-personal vector-user-menu-legacy vector-menu" aria-labelledby="p-personal-label" > <h3 id="p-personal-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Personal tools</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-uls" class="mw-list-item active"><a class="uls-trigger" href="#"><span>English</span></a></li><li id="pt-anonuserpage" class="mw-list-item"><span title="The user page for the IP address you are editing as">Not logged in</span></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]" accesskey="n"><span>Talk</span></a></li><li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]" accesskey="y"><span>Contributions</span></a></li><li id="pt-createaccount" class="mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=Commons%3AOpenRefine" title="You are encouraged to create an account and log in; however, it is not mandatory"><span>Create account</span></a></li><li id="pt-login" class="mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=Commons%3AOpenRefine" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span>Log in</span></a></li> </ul> </div> </nav> <div id="left-navigation"> <nav id="p-namespaces" class="mw-portlet mw-portlet-namespaces vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-namespaces-label" > <h3 id="p-namespaces-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Namespaces</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-project" class="selected mw-list-item"><a href="/wiki/Commons:OpenRefine" title="View the project page [c]" accesskey="c"><span>Project page</span></a></li><li id="ca-talk" class="mw-list-item"><a href="/wiki/Commons_talk:OpenRefine" rel="discussion" title="Discussion about the content page [t]" accesskey="t"><span>Discussion</span></a></li> </ul> </div> </nav> <nav id="p-variants" class="mw-portlet mw-portlet-variants emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-variants-label" > <input type="checkbox" id="p-variants-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-variants" class="vector-menu-checkbox" aria-labelledby="p-variants-label" > <label id="p-variants-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">English</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> </div> <div id="right-navigation"> <nav id="p-views" class="mw-portlet mw-portlet-views vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-views-label" > <h3 id="p-views-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Views</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected mw-list-item"><a href="/wiki/Commons:OpenRefine"><span>View</span></a></li><li id="ca-edit" class="mw-list-item"><a href="/w/index.php?title=Commons:OpenRefine&action=edit" title="Edit this page [e]" accesskey="e"><span>Edit</span></a></li><li id="ca-history" class="mw-list-item"><a href="/w/index.php?title=Commons:OpenRefine&action=history" title="Past revisions of this page [h]" accesskey="h"><span>History</span></a></li> </ul> </div> </nav> <nav id="p-cactions" class="mw-portlet mw-portlet-cactions emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-cactions-label" title="More options" > <input type="checkbox" id="p-cactions-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-cactions" class="vector-menu-checkbox" aria-labelledby="p-cactions-label" > <label id="p-cactions-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">More</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box"> <h3 >Search</h3> <form action="/w/index.php" id="searchform" class="vector-search-box-form"> <div id="simpleSearch" class="vector-search-box-inner" data-search-loc="header-navigation"> <input class="vector-search-box-input" type="search" name="search" placeholder="Search Wikimedia Commons" aria-label="Search Wikimedia Commons" autocapitalize="sentences" title="Search Wikimedia Commons [f]" accesskey="f" id="searchInput" > <input type="hidden" name="title" value="Special:MediaSearch"> <input id="mw-searchButton" class="searchButton mw-fallbackSearchButton" type="submit" name="fulltext" title="Search the pages for this text" value="Search"> <input id="searchButton" class="searchButton" type="submit" name="go" title="Go to a page with this exact name if it exists" value="Go"> </div> </form> </div> </div> </div> <div id="mw-panel" class="vector-legacy-sidebar"> <div id="p-logo" role="banner"> <a class="mw-wiki-logo" href="/wiki/Main_Page" title="Visit the main page"></a> </div> <nav id="p-navigation" class="mw-portlet mw-portlet-navigation vector-menu-portal portal vector-menu" aria-labelledby="p-navigation-label" > <h3 id="p-navigation-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Navigate</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/Main_Page" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-welcome" class="mw-list-item"><a href="/wiki/Commons:Welcome"><span>Welcome</span></a></li><li id="n-portal" class="mw-list-item"><a href="/wiki/Commons:Community_portal" title="About the project, what you can do, where to find things"><span>Community portal</span></a></li><li id="n-village-pump" class="mw-list-item"><a href="/wiki/Commons:Village_pump"><span>Village pump</span></a></li><li id="n-help" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Help:Contents" title="The place to find out"><span>Help center</span></a></li> </ul> </div> </nav> <nav id="p-participate" class="mw-portlet mw-portlet-participate vector-menu-portal portal vector-menu" aria-labelledby="p-participate-label" > <h3 id="p-participate-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Participate</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-uploadbtn" class="mw-list-item"><a href="/wiki/Special:UploadWizard"><span>Upload file</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes in the wiki [r]" accesskey="r"><span>Recent changes</span></a></li><li id="n-latestfiles" class="mw-list-item"><a href="/wiki/Special:NewFiles"><span>Latest files</span></a></li><li id="n-randomimage" class="mw-list-item"><a href="/wiki/Special:Random/File" title="Load a random file [x]" accesskey="x"><span>Random file</span></a></li><li id="n-contact" class="mw-list-item"><a href="/wiki/Commons:Contact_us"><span>Contact us</span></a></li> </ul> </div> </nav> <nav id="p-tb" class="mw-portlet mw-portlet-tb vector-menu-portal portal vector-menu" aria-labelledby="p-tb-label" > <h3 id="p-tb-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Tools</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/Commons:OpenRefine" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/Commons:OpenRefine" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Commons:OpenRefine&oldid=918206684" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Commons:OpenRefine&action=info" title="More information about this page"><span>Page information</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Special:UrlShortener&url=https%3A%2F%2Fcommons.wikimedia.org%2Fwiki%2FCommons%3AOpenRefine"><span>Get shortened URL</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Special:QrCode&url=https%3A%2F%2Fcommons.wikimedia.org%2Fwiki%2FCommons%3AOpenRefine"><span>Download QR code</span></a></li> </ul> </div> </nav> <nav id="p-coll-print_export" class="mw-portlet mw-portlet-coll-print_export vector-menu-portal portal vector-menu" aria-labelledby="p-coll-print_export-label" > <h3 id="p-coll-print_export-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Print/export</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="/w/index.php?title=Special:Book&bookcmd=book_creator&referer=Commons%3AOpenRefine"><span>Create a book</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=Commons%3AOpenRefine&action=show-download-screen"><span>Download as PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Commons:OpenRefine&printable=yes" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li> </ul> </div> </nav> <nav id="p-wikibase-otherprojects" class="mw-portlet mw-portlet-wikibase-otherprojects vector-menu-portal portal vector-menu" aria-labelledby="p-wikibase-otherprojects-label" > <h3 id="p-wikibase-otherprojects-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In other projects</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="wb-otherproject-link wb-otherproject-meta mw-list-item"><a href="https://meta.wikimedia.org/wiki/OpenRefine" hreflang="en"><span>Meta-Wiki</span></a></li><li class="wb-otherproject-link wb-otherproject-wikidata mw-list-item"><a href="https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine" hreflang="en"><span>Wikidata</span></a></li><li class="wb-otherproject-link wb-otherproject-wikipedia mw-list-item"><a href="https://en.wikipedia.org/wiki/OpenRefine" hreflang="en"><span>Wikipedia</span></a></li><li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q5583871" title="Link to connected data repository item [g]" accesskey="g"><span>Wikidata item</span></a></li> </ul> </div> </nav> <nav id="p-lang" class="mw-portlet mw-portlet-lang vector-menu-portal portal vector-menu" aria-labelledby="p-lang-label" > <h3 id="p-lang-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In Wikipedia</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="interlanguage-link interwiki-ca mw-list-item"><a href="https://ca.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Catalan" lang="ca" hreflang="ca" data-title="OpenRefine" data-language-autonym="Català" data-language-local-name="Catalan" class="interlanguage-link-target"><span>Català</span></a></li><li class="interlanguage-link interwiki-cs mw-list-item"><a href="https://cs.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Czech" lang="cs" hreflang="cs" data-title="OpenRefine" data-language-autonym="Čeština" data-language-local-name="Czech" class="interlanguage-link-target"><span>Čeština</span></a></li><li class="interlanguage-link interwiki-de mw-list-item"><a href="https://de.wikipedia.org/wiki/OpenRefine" title="OpenRefine – German" lang="de" hreflang="de" data-title="OpenRefine" data-language-autonym="Deutsch" data-language-local-name="German" class="interlanguage-link-target"><span>Deutsch</span></a></li><li class="interlanguage-link interwiki-en mw-list-item"><a href="https://en.wikipedia.org/wiki/OpenRefine" title="OpenRefine – English" lang="en" hreflang="en" data-title="OpenRefine" data-language-autonym="English" data-language-local-name="English" class="interlanguage-link-target"><span>English</span></a></li><li class="interlanguage-link interwiki-es mw-list-item"><a href="https://es.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Spanish" lang="es" hreflang="es" data-title="OpenRefine" data-language-autonym="Español" data-language-local-name="Spanish" class="interlanguage-link-target"><span>Español</span></a></li><li class="interlanguage-link interwiki-fi mw-list-item"><a href="https://fi.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Finnish" lang="fi" hreflang="fi" data-title="OpenRefine" data-language-autonym="Suomi" data-language-local-name="Finnish" class="interlanguage-link-target"><span>Suomi</span></a></li><li class="interlanguage-link interwiki-fr mw-list-item"><a href="https://fr.wikipedia.org/wiki/OpenRefine" title="OpenRefine – French" lang="fr" hreflang="fr" data-title="OpenRefine" data-language-autonym="Français" data-language-local-name="French" class="interlanguage-link-target"><span>Français</span></a></li><li class="interlanguage-link interwiki-it mw-list-item"><a href="https://it.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Italian" lang="it" hreflang="it" data-title="OpenRefine" data-language-autonym="Italiano" data-language-local-name="Italian" class="interlanguage-link-target"><span>Italiano</span></a></li><li class="interlanguage-link interwiki-ja mw-list-item"><a href="https://ja.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Japanese" lang="ja" hreflang="ja" data-title="OpenRefine" data-language-autonym="日本語" data-language-local-name="Japanese" class="interlanguage-link-target"><span>日本語</span></a></li><li class="interlanguage-link interwiki-ko mw-list-item"><a href="https://ko.wikipedia.org/wiki/%EC%98%A4%ED%94%88%EB%A6%AC%ED%8C%8C%EC%9D%B8" title="오픈리파인 – Korean" lang="ko" hreflang="ko" data-title="오픈리파인" data-language-autonym="한국어" data-language-local-name="Korean" class="interlanguage-link-target"><span>한국어</span></a></li><li class="interlanguage-link interwiki-no mw-list-item"><a href="https://no.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Norwegian Bokmål" lang="nb" hreflang="nb" data-title="OpenRefine" data-language-autonym="Norsk bokmål" data-language-local-name="Norwegian Bokmål" class="interlanguage-link-target"><span>Norsk bokmål</span></a></li><li class="interlanguage-link interwiki-ro mw-list-item"><a href="https://ro.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Romanian" lang="ro" hreflang="ro" data-title="OpenRefine" data-language-autonym="Română" data-language-local-name="Romanian" class="interlanguage-link-target"><span>Română</span></a></li><li class="interlanguage-link interwiki-sr mw-list-item"><a href="https://sr.wikipedia.org/wiki/OpenRefine" title="OpenRefine – Serbian" lang="sr" hreflang="sr" data-title="OpenRefine" data-language-autonym="Српски / srpski" data-language-local-name="Serbian" class="interlanguage-link-target"><span>Српски / srpski</span></a></li> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-edit wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q5583871#sitelinks-wikipedia" title="Edit interlanguage links" class="wbc-editpage">Edit links</a></span></div> </div> </nav> </div> </div> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 1 September 2024, at 15:26.</li> <li id="footer-info-copyright">Files are available under licenses specified on their description page. All structured data from the file namespace is available under the <a rel="nofollow" class="external text" href="https://creativecommons.org/publicdomain/zero/1.0/">Creative Commons CC0 License</a>; all unstructured text is available under the <a rel="nofollow" class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-ShareAlike License</a>; additional terms may apply. By using this site, you agree to the <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use">Terms of Use</a> and the <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy Policy</a>.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/Commons:Welcome">About Wikimedia Commons</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Commons:General_disclaimer">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/commons.wikimedia.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="//commons.m.wikimedia.org/w/index.php?title=Commons:OpenRefine&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> <script>(RLQ=window.RLQ||[]).push(function(){mw.log.warn("This page is using the deprecated ResourceLoader module \"codex-search-styles\".\n[1.43] Use a CodexModule with codexComponents to set your specific components used: https://www.mediawiki.org/wiki/Codex#Using_a_limited_subset_of_components");mw.config.set({"wgHostname":"mw-web.codfw.main-5c59558b9d-z5gg5","wgBackendResponseTime":112,"wgDiscussionToolsPageThreads":[{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Frequently_Asked_Questions","replies":[],"uneditableSection":true},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Learn_to_use_OpenRefine_for_Wikimedia_Commons:_WikiLearn_course","replies":[],"uneditableSection":true},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Upload_files_to_Wikimedia_Commons_with_OpenRefine_(version_3.7)","replies":[],"uneditableSection":true},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Edit_files_on_Wikimedia_Commons_with_OpenRefine_(version_3.6_and_newer)","replies":[],"uneditableSection":true},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Advanced_tips_and_tricks","replies":[],"uneditableSection":true},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Install_and_run_OpenRefine","replies":[{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-As_a_local_application_on_your_computer-Install_and_run_OpenRefine","replies":[{"headingLevel":4,"name":"h-","type":"heading","level":0,"id":"h-Wikimedia_Commons_extension_for_OpenRefine-As_a_local_application_on_your_computer","replies":[]}]},{"headingLevel":3,"name":"h-","type":"heading","level":0,"id":"h-In_the_cloud_(via_Wikimedia_PAWS)-Install_and_run_OpenRefine","replies":[]}],"uneditableSection":true},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Log_of_past_activities,_presentations...","replies":[]}],"wgPageParseReport":{"discussiontools":{"limitreport-timeusage":"0.019"},"limitreport":{"cputime":"0.233","walltime":"0.447","ppvisitednodes":{"value":3414,"limit":1000000},"postexpandincludesize":{"value":57195,"limit":2097152},"templateargumentsize":{"value":25616,"limit":2097152},"expansiondepth":{"value":13,"limit":100},"expensivefunctioncount":{"value":33,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":4135,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 281.011 1 -total"," 33.05% 92.880 1 Template:Responsive_two-column"," 31.11% 87.424 1 Commons:Structured_data/Navbox"," 28.70% 80.661 1 Template:Navbox"," 24.16% 67.893 33 Template:Pg"," 19.79% 55.611 1 Template:Shortcut"," 15.95% 44.828 1 Commons:OpenRefine/Header"," 13.77% 38.706 1 Template:Start_tab"," 6.84% 19.220 1 Template:Shortcut_text"," 6.18% 17.377 6 Template:Tab"]},"scribunto":{"limitreport-timeusage":{"value":"0.036","limit":"10.000"},"limitreport-memusage":{"value":1569158,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-565d46677b-wrlsw","timestamp":"20241128125901","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>