# Top **URL:** https://forum.openrefine.org/top.md [Latest](https://forum.openrefine.org/latest.md) · [Categories](https://forum.openrefine.org/categories.md) · [Tags](https://forum.openrefine.org/tags.md) --- ## [OR Food Extension](https://forum.openrefine.org/t/or-food-extension/2667)
**Author:** [@Louis](https://forum.openrefine.org/u/Louis)\ **Replies:** 11\ **Last updated:** [March 5, 2026, 3:53pm UTC](https://forum.openrefine.org/t/or-food-extension/2667 "2026-03-05T15:53:24Z")
In January, a team from ulaval.ca will begin to work on a food extension for OpenRefine. I will let you know when there’s more to say about it. If you are interested by food data applications, you can PM me or tell it he… --- ## [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… --- ## [Faster? Clustering](https://forum.openrefine.org/t/faster-clustering/2753)
**Author:** [@thadguidry](https://forum.openrefine.org/u/thadguidry)\ **Replies:** 15\ **Last updated:** [August 28, 2026, 12:04am UTC](https://forum.openrefine.org/t/faster-clustering/2753 "2026-08-28T00:04:17Z")
One of the things I’ve been working on is going back to some old problem areas in Clustering performance I once saw and using AI to see if it might help in some capacity. I knew that there where areas I saw in Simile-Vi… --- ## [Row.record.cells is not an array?](https://forum.openrefine.org/t/row-record-cells-is-not-an-array/2620)
**Author:** [@RolfBly](https://forum.openrefine.org/u/RolfBly)\ **Replies:** 10\ **Last updated:** [November 6, 2025, 3:01pm UTC](https://forum.openrefine.org/t/row-record-cells-is-not-an-array/2620 "2025-11-06T15:01:08Z")
In this record view, I want to label all records in which all values in IN\_lref are identical. I’m not at all familiar with record operations in OR yet, so first, I’m trying to find out how I should address all the value… --- ## [Trouble converting a date string](https://forum.openrefine.org/t/trouble-converting-a-date-string/3022)
**Author:** [@jquartel](https://forum.openrefine.org/u/jquartel)\ **Replies:** 15\ **Last updated:** [October 26, 2026, 5:31pm UTC](https://forum.openrefine.org/t/trouble-converting-a-date-string/3022 "2026-10-26T17:31:17Z")
I have a column with dates in the form "19 May 2026 at 18:55:11 BST" but I can't seem to work out the right way to transform this into a date with the toDate() function. Any hints? Also, the documentation for toDate() ha… --- ## [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… --- ## [Nomination of @abbe98 for the Core Developer Group](https://forum.openrefine.org/t/nomination-of-abbe98-for-the-core-developer-group/2634)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 3\ **Last updated:** [November 25, 2025, 5:00pm UTC](https://forum.openrefine.org/t/nomination-of-abbe98-for-the-core-developer-group/2634 "2025-11-25T17:00:52Z")
Hello Following the OpenRefine Governance Member Election protocol, I would like to nominate @abbe98 to be part of the Core Developer group of OpenRefine. @abbe98 has been contributing regularly since 2020, demonstrati… --- ## [Orcli (Bash) now supports macOS and OpenRefine 3.3 to 3.10](https://forum.openrefine.org/t/orcli-bash-now-supports-macos-and-openrefine-3-3-to-3-10/3005)
**Author:** [@felixlohmeier](https://forum.openrefine.org/u/felixlohmeier)\ **Replies:** 0\ **Last updated:** [October 5, 2026, 7:23pm UTC](https://forum.openrefine.org/t/orcli-bash-now-supports-macos-and-openrefine-3-3-to-3-10/3005 "2026-10-05T19:23:20Z")
Hi all, just a quick update on orcli, my Bash client for scripting OpenRefine (introduced here in 2023). It's not the same as Reinhard's recently announced Python client of the same name. Nice to see more ways to script… --- ## [Wikidata reconciliation service changes / Wikimedia rate limits](https://forum.openrefine.org/t/wikidata-reconciliation-service-changes-wikimedia-rate-limits/2779)
**Author:** [@abbe98](https://forum.openrefine.org/u/abbe98)\ **Replies:** 2\ **Last updated:** [April 22, 2026, 11:45am UTC](https://forum.openrefine.org/t/wikidata-reconciliation-service-changes-wikimedia-rate-limits/2779 "2026-04-22T11:45:29Z")
I have opened a merge request to TiBs repository fixing the User-agent which should increase the number of request reconciliation services are allowed to do. That said when/if merged this would need to be configured and … --- ## [2026 Funding Update and Budget Direction](https://forum.openrefine.org/t/2026-funding-update-and-budget-direction/2743)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 1\ **Last updated:** [March 6, 2026, 7:13am UTC](https://forum.openrefine.org/t/2026-funding-update-and-budget-direction/2743 "2026-03-06T07:13:01Z")
As we enter March, I wanted to provide an update on the project’s fundraising status and direction for 2026. A lot has happened since my last update in December and the discussion regarding the institutional package mode… --- ## [Security Vulnerability CVE-2025-68161: Log4j 2.25.3 Update Request for OpenRefine](https://forum.openrefine.org/t/security-vulnerability-cve-2025-68161-log4j-2-25-3-update-request-for-openrefine/2715)
**Author:** [@Mike\_Tasch](https://forum.openrefine.org/u/Mike_Tasch)\ **Replies:** 1\ **Last updated:** [January 27, 2026, 11:36pm UTC](https://forum.openrefine.org/t/security-vulnerability-cve-2025-68161-log4j-2-25-3-update-request-for-openrefine/2715 "2026-01-27T23:36:33Z")
Dear OpenRefine Team, I am writing to report a security vulnerability affecting OpenRefine and to request information about a potential patch or update. Environment Details: OpenRefine Version: 3.9.5 (latest availabl… --- ## [Funding Opportunity: 2025 Sloan Letter of Interest](https://forum.openrefine.org/t/funding-opportunity-2025-sloan-letter-of-interest/2643)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 2\ **Last updated:** [January 29, 2026, 4:11pm UTC](https://forum.openrefine.org/t/funding-opportunity-2025-sloan-letter-of-interest/2643 "2026-01-29T16:11:14Z")
We have been invited by the Alfred P. Sloan Foundation to submit a Letter of Interest (LOI) to their Open Source in Science program. With the support of @Rory , the Advisory Committee, and CS&S, we centered our propositi… --- ## [Community call: Extension developer guidelines (April 23, 2026)](https://forum.openrefine.org/t/community-call-extension-developer-guidelines-april-23-2026/2772)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 1\ **Last updated:** [May 20, 2026, 11:53am UTC](https://forum.openrefine.org/t/community-call-extension-developer-guidelines-april-23-2026/2772 "2026-05-20T11:53:38Z")
Following the introduction of the community call series, we are planning the first session: Topic: Extension developer guidelines Facilitator: @Rory @jfaurel When: 2026-04-23T14:00:00Z (UTC)→2026-04-23T15:30:00Z (UTC… --- ## [Developer and Community Engagement: January/February 2026](https://forum.openrefine.org/t/developer-and-community-engagement-january-february-2026/2735)
**Author:** [@Rory](https://forum.openrefine.org/u/Rory)\ **Replies:** 0\ **Last updated:** [February 26, 2026, 10:11pm UTC](https://forum.openrefine.org/t/developer-and-community-engagement-january-february-2026/2735 "2026-02-26T22:11:23Z")
Hi all, welcome to my final update in the Developer and Community Engagement Specialist role. Starting next month my activity with OpenRefine will be as a volunteer and not as a paid member of the project. Thank you all … --- ## [Food Applications](https://forum.openrefine.org/t/food-applications/2654)
**Author:** [@Louis](https://forum.openrefine.org/u/Louis)\ **Replies:** 0\ **Last updated:** [December 5, 2025, 9:24pm UTC](https://forum.openrefine.org/t/food-applications/2654 "2025-12-05T21:24:24Z")
Hi, my name is Louis Bastarache. I’m from the Open Food Facts Canada community. I’ve learned about OpenRefine recently. I’m exploring how we could use it or extend it for food data projects. ca.openfoodfacts.org --- ## [Developer and Community Engagement: November/December 2025](https://forum.openrefine.org/t/developer-and-community-engagement-november-december-2025/2706)
**Author:** [@Rory](https://forum.openrefine.org/u/Rory)\ **Replies:** 0\ **Last updated:** [January 14, 2026, 10:24pm UTC](https://forum.openrefine.org/t/developer-and-community-engagement-november-december-2025/2706 "2026-01-14T22:24:10Z")
Hi all, and welcome to another recap of what I've been working on and a look at what I plan to work on next. Since my last update, Julie and I finished the "Creating Community Playbooks" section of the Birdaro course. … --- ## [Future OpenRefine compatibility with Apple Silicon](https://forum.openrefine.org/t/future-openrefine-compatibility-with-apple-silicon/2994)
**Author:** [@MoMo](https://forum.openrefine.org/u/MoMo)\ **Replies:** 6\ **Last updated:** [September 30, 2026, 10:17pm UTC](https://forum.openrefine.org/t/future-openrefine-compatibility-with-apple-silicon/2994 "2026-09-30T22:17:08Z")
Over the weekend my MacOS updated to Tahoe 26.6.2. Upon rebooting OpenRefine this morning, my MacBook initiated a warning that support for Intel-based applications running on Rosetta will be ending with macOS 28. Will th… --- ## [Reconciliation restricted to classes and subclasses](https://forum.openrefine.org/t/reconciliation-restricted-to-classes-and-subclasses/2649)
**Author:** [@logicdavid](https://forum.openrefine.org/u/logicdavid)\ **Replies:** 4\ **Last updated:** [December 10, 2025, 9:34pm UTC](https://forum.openrefine.org/t/reconciliation-restricted-to-classes-and-subclasses/2649 "2025-12-10T21:34:09Z")
I want to match data in a CSV files with wikidata items, that is, find the QID of a matching item if it exists. I use the reconciliation end point and I try would like to restrict the class of item to “literary work” but… --- ## [Community Call: OpenRefine Developer AMA (Ask Me Anything)](https://forum.openrefine.org/t/community-call-openrefine-developer-ama-ask-me-anything/2972)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 1\ **Last updated:** [September 17, 2026, 3:47pm UTC](https://forum.openrefine.org/t/community-call-openrefine-developer-ama-ask-me-anything/2972 "2026-09-17T15:47:15Z")
We are organizing an OpenRefine Community Call as a Developer Ask-Me-Anything session. This session is intended for users, extension developers, code contributors, and anyone interested in understanding how OpenRefine w… --- ## [Issues with Wikidata reconciliation](https://forum.openrefine.org/t/issues-with-wikidata-reconciliation/2641)
**Author:** [@Jason\_Evans](https://forum.openrefine.org/u/Jason_Evans)\ **Replies:** 6\ **Last updated:** [November 26, 2025, 1:31pm UTC](https://forum.openrefine.org/t/issues-with-wikidata-reconciliation/2641 "2025-11-26T13:31:51Z")
Hi, since yesterday afternoon ive had a problem whereby Open Refine will reconcile with Wikidata, and display item previews, but will not search for a match. When i do so i just get “ Sorry, something went wrong. Please… --- ## [跪求：OpenRefine如何docker容器化部署？](https://forum.openrefine.org/t/openrefine-docker/2672)
**Author:** [@guochenliang](https://forum.openrefine.org/u/guochenliang)\ **Replies:** 7\ **Last updated:** [December 28, 2025, 2:54am UTC](https://forum.openrefine.org/t/openrefine-docker/2672 "2025-12-28T02:54:40Z")
跪求：OpenRefine如何docker容器化部署到liunx上面？ --- ## [Exploring an Institutional Package Model](https://forum.openrefine.org/t/exploring-an-institutional-package-model/2642)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 1\ **Last updated:** [January 29, 2026, 4:31pm UTC](https://forum.openrefine.org/t/exploring-an-institutional-package-model/2642 "2026-01-29T16:31:46Z")
Over the last few months, with the Advisory Community and CS&S support, I’ve been working on a more procurement-friendly way for institutions to support OpenRefine. As mentioned in my latest funding update, our current g… --- ## [Community Call: Reconciliation Services Overview](https://forum.openrefine.org/t/community-call-reconciliation-services-overview/2999)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 2\ **Last updated:** [October 19, 2026, 8:33pm UTC](https://forum.openrefine.org/t/community-call-reconciliation-services-overview/2999 "2026-10-19T20:33:05Z")
We are organizing an OpenRefine Community Call focused on reconciliation services. This session will give OpenRefine users a practical overview of several reconciliation services. Date and time: 2026-10-15T17:00:00Z (… --- ## [Enable Yearly Review](https://forum.openrefine.org/t/enable-yearly-review/2666)
**Author:** [@Ainali](https://forum.openrefine.org/u/Ainali)\ **Replies:** 1\ **Last updated:** [December 16, 2025, 1:49am UTC](https://forum.openrefine.org/t/enable-yearly-review/2666 "2025-12-16T01:49:37Z")
Discourse has released a new version of their feature Yearly Review. It is a way to sum up and present the activity of a user over the last year. It is described in more detail in their announcment. The feature can be e… --- ## [Issue with uploading captions to Wiki Commons Files - permission denied / Uploading too fast?](https://forum.openrefine.org/t/issue-with-uploading-captions-to-wiki-commons-files-permission-denied-uploading-too-fast/2613)
**Author:** [@ConBo](https://forum.openrefine.org/u/ConBo)\ **Replies:** 6\ **Last updated:** [November 6, 2025, 1:45pm UTC](https://forum.openrefine.org/t/issue-with-uploading-captions-to-wiki-commons-files-permission-denied-uploading-too-fast/2613 "2025-11-06T13:45:10Z")
Hi everyone, I uploaded 160 pictures in a batch sucessfully to Wiki Commons, but had issues with uploading the captions as well. I always get the error message in the wikibase edit results: \[permissiondenied\] You do n… --- ## [Funding opportunity: OTF FOSS Sustainability Fund](https://forum.openrefine.org/t/funding-opportunity-otf-foss-sustainability-fund/2793)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 4\ **Last updated:** [August 7, 2026, 4:11pm UTC](https://forum.openrefine.org/t/funding-opportunity-otf-foss-sustainability-fund/2793 "2026-08-07T16:11:05Z")
Hi all, I’m preparing an application to the Open Technology Fund’s Free and Open Source Software Sustainability Fund (deadline: May 7). The proposal would focus on strengthening OpenRefine’s core infrastructure, with a… --- ## [VPAT request (accessibility)](https://forum.openrefine.org/t/vpat-request-accessibility/2742)
**Author:** [@Joseph\_Anderson](https://forum.openrefine.org/u/Joseph_Anderson)\ **Replies:** 5\ **Last updated:** [March 5, 2026, 7:26pm UTC](https://forum.openrefine.org/t/vpat-request-accessibility/2742 "2026-03-05T19:26:34Z")
Hello, My institution is undergoing an accessibility review, and we’ve been asked to request VPAT’s (Voluntary Product Accessibility Template) for all the applications we use in our day-to-day work. Based on the documen… --- ## [请问各位大佬OpenRefine 如何用idea搭建开发环境](https://forum.openrefine.org/t/openrefine-idea/2658)
**Author:** [@guochenliang](https://forum.openrefine.org/u/guochenliang)\ **Replies:** 4\ **Last updated:** [December 29, 2025, 6:37pm UTC](https://forum.openrefine.org/t/openrefine-idea/2658 "2025-12-29T18:37:51Z")
请问各位大佬OpenRefine 如何用idea搭建开发环境 --- ## [New Geocoding Extension](https://forum.openrefine.org/t/new-geocoding-extension/2755)
**Author:** [@TihanMo](https://forum.openrefine.org/u/TihanMo)\ **Replies:** 2\ **Last updated:** [March 18, 2026, 7:55am UTC](https://forum.openrefine.org/t/new-geocoding-extension/2755 "2026-03-18T07:55:25Z")
Hi everyone :waving\_hand: I would like to show an extension I wrote. It is a straighforward tool, that geocodes a selected column. It currently supports a few public APIs, namely Photon, Nominatim and Swisstopo (Not… --- ## [Uploading Edits to Wikibase (commons) not working](https://forum.openrefine.org/t/uploading-edits-to-wikibase-commons-not-working/2722)
**Author:** [@izzzabel](https://forum.openrefine.org/u/izzzabel)\ **Replies:** 9\ **Last updated:** [October 27, 2026, 7:57pm UTC](https://forum.openrefine.org/t/uploading-edits-to-wikibase-commons-not-working/2722 "2026-10-27T19:57:14Z")
Hi all, I’ve been adding some structured data to existing Wikimedia files with a small test category, but am not able to upload the changes to Wikibase. I was struggling with this issue so I installed the latest versio… --- ## [Error while reconciliating](https://forum.openrefine.org/t/error-while-reconciliating/2747)
**Author:** [@VictorSadaoAiabe](https://forum.openrefine.org/u/VictorSadaoAiabe)\ **Replies:** 4\ **Last updated:** [August 10, 2026, 6:41am UTC](https://forum.openrefine.org/t/error-while-reconciliating/2747 "2026-08-10T06:41:13Z")
Hello, I’m trying to use OpenRefine, but there are some troubles that have been happening this week. After I enter “Reconcile”, there are many cells showing “No. of recon objects was less than no. of jobs” in red. And w… --- ## [Pull Request (PR) review protocol - feedback requested](https://forum.openrefine.org/t/pull-request-pr-review-protocol-feedback-requested/2942)
**Author:** [@tfmorris](https://forum.openrefine.org/u/tfmorris)\ **Replies:** 4\ **Last updated:** [September 30, 2026, 7:00pm UTC](https://forum.openrefine.org/t/pull-request-pr-review-protocol-feedback-requested/2942 "2026-09-30T19:00:06Z")
As a general rule, I don't specifically request reviews of my PRs unless I think they are particularly suited to a developer's interests or skills, but this practice depends on developers periodically checking the list o… --- ## [Developer and Community Engagement: October and early November 2025](https://forum.openrefine.org/t/developer-and-community-engagement-october-and-early-november-2025/2625)
**Author:** [@Rory](https://forum.openrefine.org/u/Rory)\ **Replies:** 0\ **Last updated:** [November 11, 2025, 9:43pm UTC](https://forum.openrefine.org/t/developer-and-community-engagement-october-and-early-november-2025/2625 "2025-11-11T21:43:19Z")
Hi all, apologies for being a bit delayed on this update post. It’s been a busy time! I’d still like to move my Trello board into GitHub, which I’m hoping to finally make time for later this week. I’ll follow up here onc… --- ## [Community call: 2026 Community Survey preparation and goals review](https://forum.openrefine.org/t/community-call-2026-community-survey-preparation-and-goals-review/2815)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 0\ **Last updated:** [May 13, 2026, 12:37pm UTC](https://forum.openrefine.org/t/community-call-2026-community-survey-preparation-and-goals-review/2815 "2026-05-13T12:37:09Z")
As part of the community call series, here are the details for our May session: Topic: 2026 Community Survey preparation and goals review Facilitator: @Martin When: 2026-05-28T14:00:00Z (UTC)→2026-05-28T15:30:00Z (UTC… --- ## [Funding opportunity: OS4LS proposal around OpenRefine for life-science data curation](https://forum.openrefine.org/t/funding-opportunity-os4ls-proposal-around-openrefine-for-life-science-data-curation/2816)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 3\ **Last updated:** [October 19, 2026, 8:42pm UTC](https://forum.openrefine.org/t/funding-opportunity-os4ls-proposal-around-openrefine-for-life-science-data-curation/2816 "2026-10-19T20:42:14Z")
We are preparing a Letter of Intent for the Open Source for the Life Sciences (OS4LS) funding call. OS4LS is a new program that follows from the EOSS funding program. The LOI is due on June 8, 2026. We are currently loo… --- ## [Community call: OpenRefine LLM Extension Demo](https://forum.openrefine.org/t/community-call-openrefine-llm-extension-demo/2923)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 1\ **Last updated:** [July 27, 2026, 6:10pm UTC](https://forum.openrefine.org/t/community-call-openrefine-llm-extension-demo/2923 "2026-07-27T18:10:55Z")
We are organizing an OpenRefine community call focused on concrete uses of the OpenRefine LLM Extension. This session is intended for anyone interested in using LLMs with OpenRefine. The goal is to show practical exampl… --- ## [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… --- ## [August 6, 2026 Advisory Committee with CS&S](https://forum.openrefine.org/t/august-6-2026-advisory-committee-with-cs-s/2967)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 1\ **Last updated:** [August 7, 2026, 5:43pm UTC](https://forum.openrefine.org/t/august-6-2026-advisory-committee-with-cs-s/2967 "2026-08-07T17:43:17Z")
Attendees CS&S: Linda, Ron OpenRefine: Martin, Esther, Jan Discussions CS&S Dormant Project Status Martin shared the latest cash flow projection. The managing director role is funded until September 30, 2026. Currentl… --- ## [Export to .csv without trimming whitespace](https://forum.openrefine.org/t/export-to-csv-without-trimming-whitespace/2777)
**Author:** [@quackers](https://forum.openrefine.org/u/quackers)\ **Replies:** 5\ **Last updated:** [August 29, 2026, 8:43am UTC](https://forum.openrefine.org/t/export-to-csv-without-trimming-whitespace/2777 "2026-08-29T08:43:49Z")
Hello everyone, in my project, I have cells that contain a newline in the beginning, like so: Entry in Column 1: "line 1 content line 2 content" Entry in Column 2: " line 2 extra info" The linebreak uses “\\r\\n”. … --- ## [Finding words with 9 or more letters](https://forum.openrefine.org/t/finding-words-with-9-or-more-letters/2624)
**Author:** [@Charlotte\_00020](https://forum.openrefine.org/u/Charlotte_00020)\ **Replies:** 4\ **Last updated:** [November 17, 2025, 12:22pm UTC](https://forum.openrefine.org/t/finding-words-with-9-or-more-letters/2624 "2025-11-17T12:22:32Z")
I need to find out how many quotes in the column ‘quotes” in my document have words with 9 or more letters. This has to happen via “add column based on this column”. Does anyone know what GREL functie I need for this? … --- ## [January 8, 2026 Advisory Committee with CS&S](https://forum.openrefine.org/t/january-8-2026-advisory-committee-with-cs-s/2708)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 0\ **Last updated:** [January 15, 2026, 12:53am UTC](https://forum.openrefine.org/t/january-8-2026-advisory-committee-with-cs-s/2708 "2026-01-15T00:53:45Z")
Attendees CS&S: Linda, Danielle OpenRefine: Jan, Martin, Julie, Esther No AC meeting on the week of December 22 and 29, 2025 Discussions Advisory Committee Status Following December 19, 2025 Advisory Committee CS&S ag… --- ## [Pending pull requests from new contributors](https://forum.openrefine.org/t/pending-pull-requests-from-new-contributors/2941)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 6\ **Last updated:** [August 22, 2026, 10:06am UTC](https://forum.openrefine.org/t/pending-pull-requests-from-new-contributors/2941 "2026-08-22T10:06:51Z")
Hello, We currently have several pull requests from new contributors pending review. I know everyone is contributing on a volunteer basis, so I am sharing this mainly to surface the pending items and help with coordinat… --- ## ["No such import job / No technical details"](https://forum.openrefine.org/t/no-such-import-job-no-technical-details/2645)
**Author:** [@jinoji](https://forum.openrefine.org/u/jinoji)\ **Replies:** 3\ **Last updated:** [November 26, 2025, 6:51pm UTC](https://forum.openrefine.org/t/no-such-import-job-no-technical-details/2645 "2025-11-26T18:51:35Z")
Hi, I’m very new to OpenRefine, and I’ve been struggling to import my dataset into the portal as it keeps saying: No such import job No technical details. For context, I am a university student and my project requires … --- ## [Unable to open issues on openrefine-geo-extension](https://forum.openrefine.org/t/unable-to-open-issues-on-openrefine-geo-extension/2621)
**Author:** [@Rory](https://forum.openrefine.org/u/Rory)\ **Replies:** 2\ **Last updated:** [November 5, 2025, 8:44pm UTC](https://forum.openrefine.org/t/unable-to-open-issues-on-openrefine-geo-extension/2621 "2025-11-05T20:44:19Z")
It looks like issues are disabled on the OpenRefine geo extension repository. Could an org admin enable those so we can track tasks for that extension? Thanks! --- ## [2026 OpenRefine User Survey is now open](https://forum.openrefine.org/t/2026-openrefine-user-survey-is-now-open/2960)
**Author:** [@Martin](https://forum.openrefine.org/u/Martin)\ **Replies:** 0\ **Last updated:** [July 27, 2026, 5:20pm UTC](https://forum.openrefine.org/t/2026-openrefine-user-survey-is-now-open/2960 "2026-07-27T17:20:28Z")
The 2026 OpenRefine User Survey is now open. We want to understand how people use OpenRefine, which communities rely on it, and what the project should improve or prioritize next. The survey has two parts: The OpenRef… --- ## [Tutorial - Openrefine and LLM extension](https://forum.openrefine.org/t/tutorial-openrefine-and-llm-extension/2883)
**Author:** [@h\_piedcoq](https://forum.openrefine.org/u/h_piedcoq)\ **Replies:** 1\ **Last updated:** [June 5, 2026, 2:53pm UTC](https://forum.openrefine.org/t/tutorial-openrefine-and-llm-extension/2883 "2026-06-05T14:53:57Z")
Hi, I don't post here very often but remain a loyal reader of this forum. I'm back from DataHarvest2026 where I gave a 30mn session on Openrefine and the wonderful extension AI extension by Sunil Natraj (Kudos and than… --- ## [Will OpenRefine be part of GSoC 2026?](https://forum.openrefine.org/t/will-openrefine-be-part-of-gsoc-2026/2656)
**Author:** [@shivvani](https://forum.openrefine.org/u/shivvani)\ **Replies:** 3\ **Last updated:** [January 20, 2026, 3:01pm UTC](https://forum.openrefine.org/t/will-openrefine-be-part-of-gsoc-2026/2656 "2026-01-20T15:01:29Z")
Hey Community, I’m interested in applying to OpenRefine for GSoC 2026. I know participation was skipped in 2025 due to a lack of mentors, so I wanted to check if the team plans to apply as an organization for 2026? I'd… --- ## [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… --- ## [AI-generated extension for OSINT](https://forum.openrefine.org/t/ai-generated-extension-for-osint/2619)
**Author:** [@Rory](https://forum.openrefine.org/u/Rory)\ **Replies:** 2\ **Last updated:** [November 15, 2025, 1:34pm UTC](https://forum.openrefine.org/t/ai-generated-extension-for-osint/2619 "2025-11-15T13:34:09Z")
@Martin showed me an extension the other day for finding “indicators of compromise” in a dataset: GitHub - herve-checkfirst/refineCTI: A simple CTI extension for OpenRefine This was created by @h\_piedcoq using an LLM (I… --- ## [What happens if I edit a project's source data?](https://forum.openrefine.org/t/what-happens-if-i-edit-a-projects-source-data/2635)
**Author:** [@martimpassos](https://forum.openrefine.org/u/martimpassos)\ **Replies:** 3\ **Last updated:** [November 19, 2025, 12:24pm UTC](https://forum.openrefine.org/t/what-happens-if-i-edit-a-projects-source-data/2635 "2025-11-19T12:24:09Z")
I'm several transforms into a project and realized there's an escaping issue with my CSV, so some rows are being split where they shouldn't and the following columns are shifted to the right. I'm assuming that editing th… [Next page](https://forum.openrefine.org/top.md?page=1&per_page=50)