# OpenRefine documentation **URL:** https://forum.openrefine.org/c/community/documentation/9.md [Latest](https://forum.openrefine.org/latest.md) · [Categories](https://forum.openrefine.org/categories.md) · [Tags](https://forum.openrefine.org/tags.md) --- ## [About the OpenRefine documentation category](https://forum.openrefine.org/t/about-the-openrefine-documentation-category/50)
**Author:** [@Sandra](https://forum.openrefine.org/u/Sandra)\ **Replies:** 0
Topics and discussion related to documentation about OpenRefine; of course including OpenRefine’s own manual at https://docs.openrefine.org --- ## [Start a YouTube account for OpenRefine to curate playlists?](https://forum.openrefine.org/t/start-a-youtube-account-for-openrefine-to-curate-playlists/686)
**Author:** [@Ainali](https://forum.openrefine.org/u/Ainali)\ **Replies:** 7\ **Last updated:** [August 29, 2026, 5:34pm UTC](https://forum.openrefine.org/t/start-a-youtube-account-for-openrefine-to-curate-playlists/686 "2026-08-29T17:34:00Z")
On YouTube, there are plenty of OpenRefine videos of many different sorts. I sense that there is an opportunity here to act as a curator of all this useful content. I propose that we start an official YouTube account wit… --- ## [AI-generated OpenRefine documentation on DeepWiki](https://forum.openrefine.org/t/ai-generated-openrefine-documentation-on-deepwiki/2489)
**Author:** [@Rory](https://forum.openrefine.org/u/Rory)\ **Replies:** 3\ **Last updated:** [January 12, 2026, 7:07pm UTC](https://forum.openrefine.org/t/ai-generated-openrefine-documentation-on-deepwiki/2489 "2026-01-12T19:07:24Z")
Hi all, I recently heard about the site DeepWiki, which hosts AI-generated documentation for open source projects. Naturally, the first repo I looked for was OpenRefine, and behold: OpenRefine/OpenRefine | DeepWiki It s… --- ## [Misunderstood requirements preventing the use of OpenRefine](https://forum.openrefine.org/t/misunderstood-requirements-preventing-the-use-of-openrefine/1865)
**Author:** [@b2m](https://forum.openrefine.org/u/b2m)\ **Replies:** 9\ **Last updated:** [November 13, 2025, 9:21pm UTC](https://forum.openrefine.org/t/misunderstood-requirements-preventing-the-use-of-openrefine/1865 "2025-11-13T21:21:29Z")
I receive more and more messages from colleagues working in the GLAM sector, stating that they are not allowed to use OpenRefine for (sometimes) quite the strange reasons. I will collect some "blockers" here and you may… --- ## [Improving the documentation with a new section, “External tools and Services”](https://forum.openrefine.org/t/improving-the-documentation-with-a-new-section-external-tools-and-services/1864)
**Author:** [@Antoine2711](https://forum.openrefine.org/u/Antoine2711)\ **Replies:** 8\ **Last updated:** [November 7, 2024, 8:07pm UTC](https://forum.openrefine.org/t/improving-the-documentation-with-a-new-section-external-tools-and-services/1864 "2024-11-07T20:07:14Z")
I would like to have more available informations on the external tools, clients and services (particularly the Reconciliation services, except Wikidate/wikibase/Wikimedia Commons). A new section for that would make it e… --- ## [Many Approved PRs awaiting for merge](https://forum.openrefine.org/t/many-approved-prs-awaiting-for-merge/1727)
**Author:** [@thadguidry](https://forum.openrefine.org/u/thadguidry)\ **Replies:** 2\ **Last updated:** [August 20, 2024, 12:59am UTC](https://forum.openrefine.org/t/many-approved-prs-awaiting-for-merge/1727 "2024-08-20T00:59:22Z")
Pull requests · OpenRefine/openrefine.org (github.com) Generally, there are many awaiting review. @Martin are you the primary maintainer for the OpenRefine.org site? --- ## [Algolia configuration for searching website](https://forum.openrefine.org/t/algolia-configuration-for-searching-website/1456)
**Author:** [@thadguidry](https://forum.openrefine.org/u/thadguidry)\ **Replies:** 1\ **Last updated:** [April 16, 2024, 12:46pm UTC](https://forum.openrefine.org/t/algolia-configuration-for-searching-website/1456 "2024-04-16T12:46:48Z")
Hi @antonin\_d , I'm setting up Algolia for https://db2rest.com but have been having problems with it working. It seems to be indexing just fine. But we don't see results being returned when using the search box on th… --- ## [Video: Intro to OpenRefine for Data Cleaning and Reconciliation (Martin Magdinier)](https://forum.openrefine.org/t/video-intro-to-openrefine-for-data-cleaning-and-reconciliation-martin-magdinier/1021)
**Author:** [@reshamas](https://forum.openrefine.org/u/reshamas)\ **Replies:** 1\ **Last updated:** [February 23, 2024, 8:14pm UTC](https://forum.openrefine.org/t/video-intro-to-openrefine-for-data-cleaning-and-reconciliation-martin-magdinier/1021 "2024-02-23T20:14:44Z")
This 1-hour video presents the following: About OpenRefine (purpose, its user base, and its historical evolution) Demo (installation, filtering, etc) Community (contributing, avenues for contribution, documentation) O… --- ## [Standard for Public Code assessment](https://forum.openrefine.org/t/standard-for-public-code-assessment/1213)
**Author:** [@Ainali](https://forum.openrefine.org/u/Ainali)\ **Replies:** 3\ **Last updated:** [January 31, 2024, 2:29pm UTC](https://forum.openrefine.org/t/standard-for-public-code-assessment/1213 "2024-01-31T14:29:22Z")
In my day job at Foundation for Public Code I am one of the maintainers of the Standard for Public Code. As OpenRefine is being used by both academics, GLAM staff etc. it could arguably fit into the definition of what we… --- ## [Demo video on how to do 'some value' / 'no value' / 'unknown value' type of Wikibase statements with OpenRefine (2023 situation)](https://forum.openrefine.org/t/demo-video-on-how-to-do-some-value-no-value-unknown-value-type-of-wikibase-statements-with-openrefine-2023-situation/1184)
**Author:** [@Sandra](https://forum.openrefine.org/u/Sandra)\ **Replies:** 0\ **Last updated:** [January 15, 2024, 7:07am UTC](https://forum.openrefine.org/t/demo-video-on-how-to-do-some-value-no-value-unknown-value-type-of-wikibase-statements-with-openrefine-2023-situation/1184 "2024-01-15T07:07:45Z")
Support for 'some value' / 'unknown value' / 'no value' types of values in Wikibase statements has been requested a while ago (see GitHub issue). Some time ago a partial approach/solution for this issue has already been … --- ## [Documentation for the Wikimedia Common decription field](https://forum.openrefine.org/t/documentation-for-the-wikimedia-common-decription-field/1126)
**Author:** [@Antoine2711](https://forum.openrefine.org/u/Antoine2711)\ **Replies:** 1\ **Last updated:** [January 1, 2024, 6:24pm UTC](https://forum.openrefine.org/t/documentation-for-the-wikimedia-common-decription-field/1126 "2024-01-01T18:24:42Z")
I think this should be documented, I just don't know where… @Sandra, any idea? This is to put in the wiki code to include, in the description of Wikimédia Commons images, some data from SDC or WD: Module:Wikidata Mod… --- ## [Wikibase recipes - added GREL to populate Wikitext from multiple columns](https://forum.openrefine.org/t/wikibase-recipes-added-grel-to-populate-wikitext-from-multiple-columns/895)
**Author:** [@datadotgay](https://forum.openrefine.org/u/datadotgay)\ **Replies:** 1\ **Last updated:** [August 7, 2023, 6:14am UTC](https://forum.openrefine.org/t/wikibase-recipes-added-grel-to-populate-wikitext-from-multiple-columns/895 "2023-08-07T06:14:58Z")
Kia ora koutou, I've just added a Wikibase section to the Recipes wiki page, and added some documentation about how to build Wikitext for images you're uploading. It has instructions for conditional inclusion of values … --- ## [Translating the docs](https://forum.openrefine.org/t/translating-the-docs/646)
**Author:** [@Martim\_Passos](https://forum.openrefine.org/u/Martim_Passos)\ **Replies:** 8\ **Last updated:** [May 18, 2023, 1:58am UTC](https://forum.openrefine.org/t/translating-the-docs/646 "2023-05-18T01:58:52Z")
Hi all, I see links for contributing to the interface translation but nothing about the docs. Is that possible/wanted? I’d be happy to work on a Brazilian Portuguese version so my colleagues can learn how to use it. --- ## [Openrefine: wikidata](https://forum.openrefine.org/t/openrefine-wikidata/638)
**Author:** [@Pushpanjali](https://forum.openrefine.org/u/Pushpanjali)\ **Replies:** 3\ **Last updated:** [March 19, 2023, 6:31pm UTC](https://forum.openrefine.org/t/openrefine-wikidata/638 "2023-03-19T18:31:09Z")
What unit should be given to student count in open refine? : --- ## [How to sum the value of a specific cell](https://forum.openrefine.org/t/how-to-sum-the-value-of-a-specific-cell/597)
**Author:** [@xiaoyu](https://forum.openrefine.org/u/xiaoyu)\ **Replies:** 2\ **Last updated:** [March 13, 2023, 9:34pm UTC](https://forum.openrefine.org/t/how-to-sum-the-value-of-a-specific-cell/597 "2023-03-13T21:34:35Z")
How to sum the other values of this column to the specific cell of this column？ --- ## [Communication discontinuities](https://forum.openrefine.org/t/communication-discontinuities/180)
**Author:** [@tfmorris](https://forum.openrefine.org/u/tfmorris)\ **Replies:** 4\ **Last updated:** [December 1, 2022, 5:43am UTC](https://forum.openrefine.org/t/communication-discontinuities/180 "2022-12-01T05:43:28Z")
Tom Morris \ 12:55 PM (12 minutes ago) to openrefine-dev I intend to have a go at restructuring and improving the technical documentation on the website (in an effort to keep migrating out of… --- ## [Forget me nots! Seeking feedback on documentation for completed project](https://forum.openrefine.org/t/forget-me-nots-seeking-feedback-on-documentation-for-completed-project/154)
**Author:** [@datadotgay](https://forum.openrefine.org/u/datadotgay)\ **Replies:** 0\ **Last updated:** [November 21, 2022, 8:16pm UTC](https://forum.openrefine.org/t/forget-me-nots-seeking-feedback-on-documentation-for-completed-project/154 "2022-11-21T20:16:09Z")
Kia ora koutou (hello all), Te Papa in New Zealand recently completed a project to load images of Myosotis (forget me not) specimens to the Commons. We used OpenRefine to facet and filter down our selection, create Wiki… --- ## [smartSplit() syntax is not following it's help documentation](https://forum.openrefine.org/t/smartsplit-syntax-is-not-following-its-help-documentation/45)
**Author:** [@thadguidry](https://forum.openrefine.org/u/thadguidry)\ **Replies:** 1\ **Last updated:** [November 2, 2022, 3:41pm UTC](https://forum.openrefine.org/t/smartsplit-syntax-is-not-following-its-help-documentation/45 "2022-11-02T15:41:10Z")
When I tried the expression value.smartSplit(/(\[A-Z\])\\w+/) or just value.smartSplit(/\\W/) on a String value of k\_\_Archaea;p\_\_Crenarchaeota;c\_\_Thaumarchaeota;o\_\_Cenarchaeales;f\_\_Cenarchaeaceae;g\_\_;s\_\_ I got an error…