# \#reconciliation **URL:** https://forum.openrefine.org/tag/reconciliation/12.md [Latest](https://forum.openrefine.org/latest.md) · [Categories](https://forum.openrefine.org/categories.md) · [Tags](https://forum.openrefine.org/tags.md) --- ## [Add columns from reconciled values not working via Wikidata](https://forum.openrefine.org/t/add-columns-from-reconciled-values-not-working-via-wikidata/2746)
**Author:** [@datasteward8](https://forum.openrefine.org/u/datasteward8)\ **Replies:** 12\ **Last updated:** [April 14, 2026, 3:40pm UTC](https://forum.openrefine.org/t/add-columns-from-reconciled-values-not-working-via-wikidata/2746 "2026-04-14T15:40:12Z")
Hello everyone! For several days now I encounter an error when reconciling with Wikidata. I reconciled the items via Wikidata Qid without problem but when I try to use the “add columns from reconciled values” it does n… --- ## [“Add column from reconciled values” fails when typing Wikidata properties manually](https://forum.openrefine.org/t/add-column-from-reconciled-values-fails-when-typing-wikidata-properties-manually/2778)
**Author:** [@Miquel\_Centelles](https://forum.openrefine.org/u/Miquel_Centelles)\ **Replies:** 3\ **Last updated:** [April 14, 2026, 12:51pm UTC](https://forum.openrefine.org/t/add-column-from-reconciled-values-fails-when-typing-wikidata-properties-manually/2778 "2026-04-14T12:51:46Z")
Hello, I’m having a problem in OpenRefine when trying to add columns from reconciled values with Wikidata. What I need to do is use Add columns from reconciled values after reconciling my cells with Wikidata. Once I ha… --- ## [Wikidata Reconcilliation](https://forum.openrefine.org/t/wikidata-reconcilliation/2775)
**Author:** [@ChiliZim](https://forum.openrefine.org/u/ChiliZim)\ **Replies:** 0\ **Last updated:** [April 9, 2026, 1:08pm UTC](https://forum.openrefine.org/t/wikidata-reconcilliation/2775 "2026-04-09T13:08:54Z")
Hello Everyone! I’ve run into a, from what I can see in the forum, quite common problem, insomuch that the reconcilliation via Wikidata does not (persumably) pass the firewall of my company and the advice stated in prio… --- ## [New Reconciliation Service (The Movie Database - TMDB)](https://forum.openrefine.org/t/new-reconciliation-service-the-movie-database-tmdb/2731)
**Author:** [@Isadora](https://forum.openrefine.org/u/Isadora)\ **Replies:** 6\ **Last updated:** [March 7, 2026, 11:22pm UTC](https://forum.openrefine.org/t/new-reconciliation-service-the-movie-database-tmdb/2731 "2026-03-07T23:22:18Z")
Hi all, I made a reconciliation service for OpenRefine specifically made to reconcile movies using the API from The Movie Database (TMDB). I have made a local version and a public one (running on render) to facilitate us… --- ## [Reconciliation not getting automatically matched against type](https://forum.openrefine.org/t/reconciliation-not-getting-automatically-matched-against-type/1364)
**Author:** [@Gnoeee](https://forum.openrefine.org/u/Gnoeee)\ **Replies:** 3\ **Last updated:** [January 23, 2026, 9:22pm UTC](https://forum.openrefine.org/t/reconciliation-not-getting-automatically-matched-against-type/1364 "2026-01-23T21:22:21Z")
Greetings Forum Members, I'm encountering an issue while attempting to reconcile data on a Wikibase.Cloud instance and would appreciate some assistance. Here's a breakdown of the problem: Objective: My goal is to reco… --- ## [Reconcile against another project?](https://forum.openrefine.org/t/reconcile-against-another-project/2671)
**Author:** [@martimpassos](https://forum.openrefine.org/u/martimpassos)\ **Replies:** 2\ **Last updated:** [December 17, 2025, 6:42pm UTC](https://forum.openrefine.org/t/reconcile-against-another-project/2671 "2025-12-17T18:42:15Z")
Hi all, is there a way of using a second project as a reconciliation source, similar to \`cross\` but with clustering? My data has singular terms that should be matched against their plural versions, hyphens vs whitespaces… --- ## [Error when adding column from reconciled wikimedia-commons-values](https://forum.openrefine.org/t/error-when-adding-column-from-reconciled-wikimedia-commons-values/2633)
**Author:** [@Claus](https://forum.openrefine.org/u/Claus)\ **Replies:** 0\ **Last updated:** [November 17, 2025, 10:32am UTC](https://forum.openrefine.org/t/error-when-adding-column-from-reconciled-wikimedia-commons-values/2633 "2025-11-17T10:32:13Z")
Hi everyone, I came across an error happening when adding columns from values, that were reconciled with wikimedia commons. I am using OpenRefine Version 3.9.5 on Windows 11. steps for reproduction: Reconcile a colum… --- ## [Error using German reconciliation service](https://forum.openrefine.org/t/error-using-german-reconciliation-service/2631)
**Author:** [@logicdavid](https://forum.openrefine.org/u/logicdavid)\ **Replies:** 5\ **Last updated:** [November 17, 2025, 8:00am UTC](https://forum.openrefine.org/t/error-using-german-reconciliation-service/2631 "2025-11-17T08:00:05Z")
I am trying to reconcile data in CSV file with entities using the endpoint: http://wikidata.reconci.link/de/api I get a whole column fulll of red messages saying variants of The service returned a JSON response withou… --- ## [Help with matching 72,000 institutions to ROR IDs](https://forum.openrefine.org/t/help-with-matching-72-000-institutions-to-ror-ids/2508)
**Author:** [@kassandrarane](https://forum.openrefine.org/u/kassandrarane)\ **Replies:** 1\ **Last updated:** [August 30, 2025, 8:52pm UTC](https://forum.openrefine.org/t/help-with-matching-72-000-institutions-to-ror-ids/2508 "2025-08-30T20:52:21Z")
Hello! I found OpenRefine while looking for the best way to clean up our institutional data so we can align it with the Research Organization Registry (ROR). I see that OpenRefine has a reconciliation feature, and I’ve … --- ## [Problems with VIAF Reconciliation](https://forum.openrefine.org/t/problems-with-viaf-reconciliation/2063)
**Author:** [@Libusama](https://forum.openrefine.org/u/Libusama)\ **Replies:** 31\ **Last updated:** [June 13, 2025, 4:15pm UTC](https://forum.openrefine.org/t/problems-with-viaf-reconciliation/2063 "2025-06-13T16:15:45Z")
Hello everyone! I've experienced some issues with the VIAF reconciliation since the beginnig of 2025. VIAF has recently updated its website, but since then the OpenRefine VIAF Reconciliation service is not working at a… --- ## [Negotiating reconciliation API versions](https://forum.openrefine.org/t/negotiating-reconciliation-api-versions/2250)
**Author:** [@abbe98](https://forum.openrefine.org/u/abbe98)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 1:06pm UTC](https://forum.openrefine.org/t/negotiating-reconciliation-api-versions/2250 "2025-04-17T13:06:52Z")
Hi all, We are currently moving our clients to a 1.0-draft variant of the reconciliation specification, however, for our services to remain compatible with OpenRefine.org we will keep supporting 0.2 for the time being. … --- ## [New MediaWiki extension: ReconciliationAPI](https://forum.openrefine.org/t/new-mediawiki-extension-reconciliationapi/2218)
**Author:** [@D-Groenewegen](https://forum.openrefine.org/u/D-Groenewegen)\ **Replies:** 3\ **Last updated:** [April 9, 2025, 6:50pm UTC](https://forum.openrefine.org/t/new-mediawiki-extension-reconciliationapi/2218 "2025-04-09T18:50:53Z")
To whom it may concern, a couple of weeks ago I released a beta version of a new MediaWiki extension which lets you set up data services on your wiki based on the specifications of the Reconciliation Services API (v0.2).… --- ## [Supporting the Reconciliation Service API for SKOS vocabularies](https://forum.openrefine.org/t/supporting-the-reconciliation-service-api-for-skos-vocabularies/2225)
**Author:** [@acka47](https://forum.openrefine.org/u/acka47)\ **Replies:** 1\ **Last updated:** [April 9, 2025, 1:43pm UTC](https://forum.openrefine.org/t/supporting-the-reconciliation-service-api-for-skos-vocabularies/2225 "2025-04-09T13:43:55Z")
For people working with controlled vocabularies in SKOS, we have to set up a service to upload a SKOS file and get back the URL for a reconciliation service to be used for reconciliation tasks in OpenRefine. For details… --- ## [Problem with wikidata (fr) reconciliation](https://forum.openrefine.org/t/problem-with-wikidata-fr-reconciliation/2151)
**Author:** [@Zimmy](https://forum.openrefine.org/u/Zimmy)\ **Replies:** 7\ **Last updated:** [March 26, 2025, 2:36pm UTC](https://forum.openrefine.org/t/problem-with-wikidata-fr-reconciliation/2151 "2025-03-26T14:36:54Z")
Hello, Since beginning 2025 I can't use reconciliation with wikidata fr "Wikidata reconci.link (fr) " https://wikidata.reconci.link/fr/api and it shows an error message It doesn't make reconciliation anymore. --- ## [Reconciling properties](https://forum.openrefine.org/t/reconciling-properties/1744)
**Author:** [@epfo](https://forum.openrefine.org/u/epfo)\ **Replies:** 7\ **Last updated:** [October 28, 2024, 7:11am UTC](https://forum.openrefine.org/t/reconciling-properties/1744 "2024-10-28T07:11:46Z")
Hi everyone, I have a table of audit data with the following columns: Entity Financial year Audit field Amount And I have over 8,000 lines of this. For now, I have reconciled column one, as I have entities as items. … --- ## [SSL certificate bypass](https://forum.openrefine.org/t/ssl-certificate-bypass/984)
**Author:** [@elainetai](https://forum.openrefine.org/u/elainetai)\ **Replies:** 3\ **Last updated:** [September 22, 2023, 9:15am UTC](https://forum.openrefine.org/t/ssl-certificate-bypass/984 "2023-09-22T09:15:33Z")
I came across this message "javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid cert… --- ## [Working group for reconciliation user interfaces](https://forum.openrefine.org/t/working-group-for-reconciliation-user-interfaces/1614)
**Author:** [@Susanna\_Anas](https://forum.openrefine.org/u/Susanna_Anas)\ **Replies:** 9\ **Last updated:** [September 23, 2024, 8:10am UTC](https://forum.openrefine.org/t/working-group-for-reconciliation-user-interfaces/1614 "2024-09-23T08:10:39Z")
Hi :wave: At the BarCamp in Berlin we agreed to set up WG for reconciliation user interfaces. We did not yet agree on the practices, and I would like to invite the initial team @lozanaross @mack-v and @thadguidry to agre… --- ## [Reconcile Against any MediaWiki Instance](https://forum.openrefine.org/t/reconcile-against-any-mediawiki-instance/1696)
**Author:** [@abbe98](https://forum.openrefine.org/u/abbe98)\ **Replies:** 4\ **Last updated:** [August 6, 2024, 5:21pm UTC](https://forum.openrefine.org/t/reconcile-against-any-mediawiki-instance/1696 "2024-08-06T17:21:48Z")
We built a very experimental OpenRefine reconciliation service which works with most MediaWiki or Wikibase instances. It will change and break in the coming weeks as we bring it in line with our existing services but the… --- ## [Request for Interest: Biodiversity Heritage Library Wikimedian in Residence](https://forum.openrefine.org/t/request-for-interest-biodiversity-heritage-library-wikimedian-in-residence/1656)
**Author:** [@JJ\_Dearborn](https://forum.openrefine.org/u/JJ_Dearborn)\ **Replies:** 0\ **Last updated:** [July 19, 2024, 3:13pm UTC](https://forum.openrefine.org/t/request-for-interest-biodiversity-heritage-library-wikimedian-in-residence/1656 "2024-07-19T15:13:37Z")
Dear OpenRefine Community, Are you interested in building a global biodiversity knowledge graph to generate actionable insights for life on a sustainable planet? Do you know your way around Wikidata and Wikimedia Common… --- ## [Add column from reconciled values: no suggestion nor recognition of entered Property](https://forum.openrefine.org/t/add-column-from-reconciled-values-no-suggestion-nor-recognition-of-entered-property/1637)
**Author:** [@Annika\_Hendriksen](https://forum.openrefine.org/u/Annika_Hendriksen)\ **Replies:** 6\ **Last updated:** [July 11, 2024, 3:10pm UTC](https://forum.openrefine.org/t/add-column-from-reconciled-values-no-suggestion-nor-recognition-of-entered-property/1637 "2024-07-11T15:10:17Z")
hi there, I want to import values for P 'start date' and 'end date' from reconciled items (expeditions) into my OR -project, but I cannot choose these properties (not listed in the suggestions) nor can I manually add … --- ## [OpenRefine 2024 Barcamp:: Reconciliation in OpenRefine](https://forum.openrefine.org/t/openrefine-2024-barcamp-reconciliation-in-openrefine/1629)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 0\ **Last updated:** [July 9, 2024, 1:49pm UTC](https://forum.openrefine.org/t/openrefine-2024-barcamp-reconciliation-in-openrefine/1629 "2024-07-09T13:49:44Z")
Reconciliation in OpenRefine This post merges discussions from the Reconciliation in OpenRefine and Using OpenRefine with Wikidata, Wikibase, and Wikimedia Commons sessions. In this post, the annotation wiki\* refers to W… --- ## [Exact matching on a property during reconcile](https://forum.openrefine.org/t/exact-matching-on-a-property-during-reconcile/1568)
**Author:** [@akoopal](https://forum.openrefine.org/u/akoopal)\ **Replies:** 2\ **Last updated:** [June 7, 2024, 6:16pm UTC](https://forum.openrefine.org/t/exact-matching-on-a-property-during-reconcile/1568 "2024-06-07T18:16:42Z")
I am trying to reconcile an export of a database (all dutch mills in milldatabase.org) and match that against a property in wikidata. For dutch mills this database contains the 'ten-bruggencatenummer (tbc) in the externa… --- ## [Is it possible to get the date precision from Wikibase?](https://forum.openrefine.org/t/is-it-possible-to-get-the-date-precision-from-wikibase/1554)
**Author:** [@Gnoeee](https://forum.openrefine.org/u/Gnoeee)\ **Replies:** 4\ **Last updated:** [June 5, 2024, 9:17am UTC](https://forum.openrefine.org/t/is-it-possible-to-get-the-date-precision-from-wikibase/1554 "2024-06-05T09:17:16Z")
While adding the data from the reconciled columns we can get directly the date value when a property related to dates are selected. But these values doesn't have the precision of the added dates. Is it possible to get … --- ## [Problem adding Commons reconciliation service](https://forum.openrefine.org/t/problem-adding-commons-reconciliation-service/320)
**Author:** [@Adzebill](https://forum.openrefine.org/u/Adzebill)\ **Replies:** 6\ **Last updated:** [May 23, 2024, 8:21pm UTC](https://forum.openrefine.org/t/problem-adding-commons-reconciliation-service/320 "2024-05-23T20:21:30Z")
(Mac OSX, Firefox, OpenRefine 3.7 beta2) Wikidata reconciliation is working fine, but when I go to reconcile image filenames, choose “Add standard service…” and paste “https://commonsreconcile.toolforge.org/en/api”, I g… --- ## ["Search for match" missing during reconciliation, 3.8.0](https://forum.openrefine.org/t/search-for-match-missing-during-reconciliation-3-8-0/1513)
**Author:** [@E11](https://forum.openrefine.org/u/E11)\ **Replies:** 1\ **Last updated:** [May 13, 2024, 4:20pm UTC](https://forum.openrefine.org/t/search-for-match-missing-during-reconciliation-3-8-0/1513 "2024-05-13T16:20:49Z")
I'm attempting to reconcile values to Wikidata using verstion 3.8.0, against no particular type, no auto-matching. When the service offers one or more potential matches, I do see the "Search for match" link in that cell.… --- ## [Wikidata reconciliation: fetch references through 'add columns from reconciled values'](https://forum.openrefine.org/t/wikidata-reconciliation-fetch-references-through-add-columns-from-reconciled-values/1411)
**Author:** [@Pai\_Dekkers](https://forum.openrefine.org/u/Pai_Dekkers)\ **Replies:** 4\ **Last updated:** [March 27, 2024, 1:20pm UTC](https://forum.openrefine.org/t/wikidata-reconciliation-fetch-references-through-add-columns-from-reconciled-values/1411 "2024-03-27T13:20:36Z")
I'm looking to fetch the 'reference' data from reconciled Wikidata items. For example, there is a person ( Q26250609) with a date of birth and that date of birth has a reference. How do I fetch the reference value throug… --- ## [Configuring auto-match with openrefine wikibase reconciliation](https://forum.openrefine.org/t/configuring-auto-match-with-openrefine-wikibase-reconciliation/1406)
**Author:** [@matssk](https://forum.openrefine.org/u/matssk)\ **Replies:** 3\ **Last updated:** [March 24, 2024, 12:03pm UTC](https://forum.openrefine.org/t/configuring-auto-match-with-openrefine-wikibase-reconciliation/1406 "2024-03-24T12:03:40Z")
In OpenRefine when reconciling I can select "Auto-match candidates with high confidence". This does not really work for me, as it confidence value varies between different data sets that I'm matching. What I need is to … --- ## [Is it possible to see the result of autosuggest from Wikidata reconciliation in a language other than English?](https://forum.openrefine.org/t/is-it-possible-to-see-the-result-of-autosuggest-from-wikidata-reconciliation-in-a-language-other-than-english/1283)
**Author:** [@GO5IT](https://forum.openrefine.org/u/GO5IT)\ **Replies:** 7\ **Last updated:** [February 23, 2024, 11:14am UTC](https://forum.openrefine.org/t/is-it-possible-to-see-the-result-of-autosuggest-from-wikidata-reconciliation-in-a-language-other-than-english/1283 "2024-02-23T11:14:57Z")
Hello, Does anybody know if it is possible to see the result of autosuggest from Wikidata reconciliation in a language other than English? I tried typing in a few languages for input. A few European language and Japane… --- ## [Templating - Removing quotation marks in bulk from final output](https://forum.openrefine.org/t/templating-removing-quotation-marks-in-bulk-from-final-output/1238)
**Author:** [@dcastro51](https://forum.openrefine.org/u/dcastro51)\ **Replies:** 1\ **Last updated:** [February 1, 2024, 1:47am UTC](https://forum.openrefine.org/t/templating-removing-quotation-marks-in-bulk-from-final-output/1238 "2024-02-01T01:47:02Z")
Hi Everyone, I'm new to using Open Refine. I'm currently using the templating feature to transform data on a spreadsheet into an xml file that is structured according to the PBCore schema. My question relates to the va… --- ## [Reconciling arrays](https://forum.openrefine.org/t/reconciling-arrays/1228)
**Author:** [@matssk](https://forum.openrefine.org/u/matssk)\ **Replies:** 11\ **Last updated:** [January 31, 2024, 12:22pm UTC](https://forum.openrefine.org/t/reconciling-arrays/1228 "2024-01-31T12:22:31Z")
Hi. I'm trying to figure out an efficient way of reconciling arrays. Reconciling the main entity in a dataset works fine, but I have additional properties that I want to reconcile that are stored in arrays/lists. These p… [Next page](https://forum.openrefine.org/tag/reconciliation/12.md?match_all_tags=true&page=1&tags%5B%5D=reconciliation)