This is the second beta release of the 3.7 series. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• Most text exposed to users in OpenRefine's UI can now be translated. Some strings (generated server-side) were not translatable so far. To help translators catch up on this backlog, do not hesitate to join us on Weblate. (#5030)
• New media files can be uploaded to Wikibase instances such as Wikimedia Commons. The wikitext of existing files can also be edited thanks to the new fields introduced. (#4682)
• A button "Discover Wikibase instances…" was added on the dialog which lists the registered Wikibase instances (#5007), whose design was improved (#5009)
• In the Wikibase schema editor, statements with non-standard datatypes (such as EDTF dates or musical notations) are now supported, assuming they use strings as underlying representation (#3263)
• The Wikibase issues tab now makes it possible to locate which rows are responsible for certain issues, using facets (#5033)
• The default throttle delay for the "Add column by fetching URLs" operation was reduced to 500ms and the error reporting for this field was improved (#5188)
• Wikibase templates (incomplete Wikibase schemas) can be saved and shared, as a way of helping contributors use the same way of structuring data in a Wikibase instance (#5043, #5303)
• The line-based importer now supports a custom delimiter, instead of only newlines (#4103)
• The Excel importer can be configured to import all cells as text, disabling the use of other datatypes supported by OpenRefine (#4838)
• The "some value" and "no value" Wikibase values can now be uploaded by OpenRefine (#5360)
• The Excel importer will also avoid coercing cell values to OpenRefine datatypes which do not fully fit them, such as representing a date as a date with time (#5389, #5390).

GREL changes

• Improved error handling in number formatting with the GREL toString function (#816)
• The behaviour of the GREL function wholeText() has changed slightly in the way it handles newlines, following an upstream change in the jsoup library (jsoup issue #1636)
• A new parent GREL function, to obtain the parent element of an XML element, was added (#5176)

For developers

• Some column metadata fields, which had never been exposed in the UI, have been removed (#5276)
• A new extension point to customize cell rendering was introduced (#5154)

And many bug fixes, see the full list of changes for 3.7.

This is the first beta release of the 3.7 series. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• Most text exposed to users in OpenRefine's UI can now be translated. Some strings (generated server-side) were not translatable so far. To help translators catch up on this backlog, do not hesitate to join us on Weblate. (#5030)
• New media files can be uploaded to Wikibase instances such as Wikimedia Commons. The wikitext of existing files can also be edited thanks to the new fields introduced. (#4682)
• A button "Discover Wikibase instances…" was added on the dialog which lists the registered Wikibase instances (#5007), whose design was improved (#5009)
• In the Wikibase schema editor, statements with non-standard datatypes (such as EDTF dates or musical notations) are now supported, assuming they use strings as underlying representation (#3263)
• The Wikibase issues tab now makes it possible to locate which rows are responsible for certain issues, using facets (#5033)
• The default throttle delay for the "Add column by fetching URLs" operation was reduced to 500ms and the error reporting for this field was improved (#5188)
• Wikibase templates (incomplete Wikibase schemas) can be saved and shared, as a way of helping contributors use the same way of structuring data in a Wikibase instance (#5043, #5303)
• The line-based importer now supports a custom delimiter, instead of only newlines (#4103)
• The Excel importer can be configured to import all cells as text, disabling the use of other datatypes supported by OpenRefine (#4838)
• The "some value" and "no value" Wikibase values can now be uploaded by OpenRefine (#5360)
• The Excel importer will also avoid coercing cell values to OpenRefine datatypes which do not fully fit them, such as representing a date as a date with time (#5389, #5390).

GREL changes

• Improved error handling in number formatting with the GREL toString function (#816)
• The behaviour of the GREL function wholeText() has changed slightly in the way it handles newlines, following an upstream change in the jsoup library (jsoup issue #1636)
• A new parent GREL function, to obtain the parent element of an XML element, was added (#5176)

For developers

• Some column metadata fields, which had never been exposed in the UI, have been removed (#5276)
• A new extension point to customize cell rendering was introduced (#5154)

And many bug fixes, see the full list of changes for 3.7.

Download

• Linux
• MacOS
• Windows without embedded JRE
• Windows with embedded JRE

This is the third stable release of the 3.6 series. Please backup your workspace directory before installing and report any problems that you encounter.

Starting with version 3.6, OpenRefine requires Java 11 or later.

New in 3.6.2

• An overflow issue with the reconciliation dialog was fixed (#5286)

New features

• The user is now warned when applying the "Fill down" or "Blank down" operations with a pending sorting criterion (#3256)
• The import preview refreshing can be disabled (#4009)
• Menu items to reveal collapsed columns were added to the column menus (#4067)
• The path to the refine.ini configuration file can now be changed on the command line (#4113)
• It is now possible to download the JSON representation of the operation history, without resorting to copy and paste (#4498)
• It is now possible to work with Wikibase instances with federation enabled (#4287)
• The merge strategy for statements can be configured in the Wikibase schema editor. This also adds support for deleting statements. Beware that schemas created with earlier versions of OpenRefine will still use the original merge strategy. (#3383, #2116, #4130)
• OpenRefine can edit MediaInfo entities and not just Items (#4270)
• It is possible to disable the new version notification by setting the configuration variable refine.display.new.version.notice=false (#4410)
• The dialog to reorder and delete columns was improved to easily delete most columns (#4557)
• The maximum editing speed and the Wikibase tag to apply to all Wikibase edits is now configurable for each Wikibase instance via its manifest (#3359)
• Extra URL fields in the starting page can be removed thanks to a new button (#4606)
• The "Use values as identifiers" operation now warns that it does not validate the identifiers (#3172)

GREL changes

• A new GREL function, parent, was introduced to obtain the parent element of an XML element (#4181)
• A new GREL function, scriptText, was introduced to obtain the text contained in a <script> or <style> element in HTML (#4189)
• The random (previously randomNumber) GREL function was improved (#3143)
• A new GREL function parseUri was introduced (#1857)
• A new GREL function detectLanguage was introduced (#642)
• New GREL functions encode and decode were introduced (#148)
• The error handling of the pow and exp functions was improved (#3062)
• The division operator returns NaN when computing 0/0 (#377)
• A function timeSinceUnixEpochToDate was introduced, to convert a duration since Epoch to a date object (#608)
• A function replaceEach was introduced, to replace multiple substrings in one go (#2606)

For extension developers

• (from 3.6-rc1 on) We migrated to jQuery 3.6.0. If you are using jQuery in your extension, some jQuery syntaxes that have been deprecated earlier might have been removed. If your extension runs with OpenRefine 3.5.2, you can check the web developer console for warning messages when the extension is used: fixing those should be enough for your extension to be compatible with OpenRefine 3.6 (#4891)

And many bug fixes, see the complete list of changes for 3.6.

Download

• Linux
• MacOS
• Windows without embedded JRE
• Windows with embedded JRE

This is the second stable release of the 3.6 series. Please backup your workspace directory before installing and report any problems that you encounter.

Starting with version 3.6, OpenRefine requires Java 11 or later.

New in 3.6.1

• The editing of redirected Wikibase entities was fixed (#5162)
• A bug with selection of clusters in the clustering dialog was fixed (#5138)
• Date handling in the Google data extension was fixed (#5107)
• A packaging issue in MacOS was tentatively fixed (#5160)

New features

• The user is now warned when applying the "Fill down" or "Blank down" operations with a pending sorting criterion (#3256)
• The import preview refreshing can be disabled (#4009)
• Menu items to reveal collapsed columns were added to the column menus (#4067)
• The path to the refine.ini configuration file can now be changed on the command line (#4113)
• It is now possible to download the JSON representation of the operation history, without resorting to copy and paste (#4498)
• It is now possible to work with Wikibase instances with federation enabled (#4287)
• The merge strategy for statements can be configured in the Wikibase schema editor. This also adds support for deleting statements. Beware that schemas created with earlier versions of OpenRefine will still use the original merge strategy. (#3383, #2116, #4130)
• OpenRefine can edit MediaInfo entities and not just Items (#4270)
• It is possible to disable the new version notification by setting the configuration variable refine.display.new.version.notice=false (#4410)
• The dialog to reorder and delete columns was improved to easily delete most columns (#4557)
• The maximum editing speed and the Wikibase tag to apply to all Wikibase edits is now configurable for each Wikibase instance via its manifest (#3359)
• Extra URL fields in the starting page can be removed thanks to a new button (#4606)
• The "Use values as identifiers" operation now warns that it does not validate the identifiers (#3172)

GREL changes

• A new GREL function, parent, was introduced to obtain the parent element of an XML element (#4181)
• A new GREL function, scriptText, was introduced to obtain the text contained in a <script> or <style> element in HTML (#4189)
• The random (previously randomNumber) GREL function was improved (#3143)
• A new GREL function parseUri was introduced (#1857)
• A new GREL function detectLanguage was introduced (#642)
• New GREL functions encode and decode were introduced (#148)
• The error handling of the pow and exp functions was improved (#3062)
• The division operator returns NaN when computing 0/0 (#377)
• A function timeSinceUnixEpochToDate was introduced, to convert a duration since Epoch to a date object (#608)
• A function replaceEach was introduced, to replace multiple substrings in one go (#2606)

For extension developers

• (from 3.6-rc1 on) We migrated to jQuery 3.6.0. If you are using jQuery in your extension, some jQuery syntaxes that have been deprecated earlier might have been removed. If your extension runs with OpenRefine 3.5.2, you can check the web developer console for warning messages when the extension is used: fixing those should be enough for your extension to be compatible with OpenRefine 3.6 (#4891)

And many bug fixes, see the complete list of changes for 3.6.

Download

• Linux
• MacOS
• Windows without embedded JRE
• Windows with embedded JRE

This is the first stable release of the 3.6 series. Please backup your workspace directory before installing and report any problems that you encounter.

Starting with version 3.6, OpenRefine requires Java 11 or later.

New features

• The user is now warned when applying the "Fill down" or "Blank down" operations with a pending sorting criterion (#3256)
• The import preview refreshing can be disabled (#4009)
• Menu items to reveal collapsed columns were added to the column menus (#4067)
• The path to the refine.ini configuration file can now be changed on the command line (#4113)
• It is now possible to download the JSON representation of the operation history, without resorting to copy and paste (#4498)
• It is now possible to work with Wikibase instances with federation enabled (#4287)
• The merge strategy for statements can be configured in the Wikibase schema editor. This also adds support for deleting statements. Beware that schemas created with earlier versions of OpenRefine will still use the original merge strategy. (#3383, #2116, #4130)
• OpenRefine can edit MediaInfo entities and not just Items (#4270)
• It is possible to disable the new version notification by setting the configuration variable refine.display.new.version.notice=false (#4410)
• The dialog to reorder and delete columns was improved to easily delete most columns (#4557)
• The maximum editing speed and the Wikibase tag to apply to all Wikibase edits is now configurable for each Wikibase instance via its manifest (#3359)
• Extra URL fields in the starting page can be removed thanks to a new button (#4606)
• The "Use values as identifiers" operation now warns that it does not validate the identifiers (#3172)

GREL changes

• A new GREL function, parent, was introduced to obtain the parent element of an XML element (#4181)
• A new GREL function, scriptText, was introduced to obtain the text contained in a <script> or <style> element in HTML (#4189)
• The random (previously randomNumber) GREL function was improved (#3143)
• A new GREL function parseUri was introduced (#1857)
• A new GREL function detectLanguage was introduced (#642)
• New GREL functions encode and decode were introduced (#148)
• The error handling of the pow and exp functions was improved (#3062)
• The division operator returns NaN when computing 0/0 (#377)
• A function timeSinceUnixEpochToDate was introduced, to convert a duration since Epoch to a date object (#608)
• A function replaceEach was introduced, to replace multiple substrings in one go (#2606)

For extension developers

• (from 3.6-rc1 on) We migrated to jQuery 3.6.0. If you are using jQuery in your extension, some jQuery syntaxes that have been deprecated earlier might have been removed. If your extension runs with OpenRefine 3.5.2, you can check the web developer console for warning messages when the extension is used: fixing those should be enough for your extension to be compatible with OpenRefine 3.6 (#4891)

And many bug fixes, see the complete list of changes for 3.6.

Download

• Linux
• MacOS
• Windows without embedded JRE
• Windows with embedded JRE

This is the first release candidate of the 3.6 series. Please backup your workspace directory before installing and report any problems that you encounter.

Starting with version 3.6, OpenRefine requires Java 11 or later.

New features

• The user is now warned when applying the "Fill down" or "Blank down" operations with a pending sorting criterion (#3256)
• The import preview refreshing can be disabled (#4009)
• Menu items to reveal collapsed columns were added to the column menus (#4067)
• The path to the refine.ini configuration file can now be changed on the command line (#4113)
• It is now possible to download the JSON representation of the operation history, without resorting to copy and paste (#4498)
• It is now possible to work with Wikibase instances with federation enabled (#4287)
• The merge strategy for statements can be configured in the Wikibase schema editor. This also adds support for deleting statements. Beware that schemas created with earlier versions of OpenRefine will still use the original merge strategy. (#3383, #2116, #4130)
• OpenRefine can edit MediaInfo entities and not just Items (#4270)
• It is possible to disable the new version notification by setting the configuration variable refine.display.new.version.notice=false (#4410)
• The dialog to reorder and delete columns was improved to easily delete most columns (#4557)
• The maximum editing speed and the Wikibase tag to apply to all Wikibase edits is now configurable for each Wikibase instance via its manifest (#3359)
• Extra URL fields in the starting page can be removed thanks to a new button (#4606)
• The "Use values as identifiers" operation now warns that it does not validate the identifiers (#3172)

GREL changes

• A new GREL function, parent, was introduced to obtain the parent element of an XML element (#4181)
• A new GREL function, scriptText, was introduced to obtain the text contained in a <script> or <style> element in HTML (#4189)
• The random (previously randomNumber) GREL function was improved (#3143)
• A new GREL function parseUri was introduced (#1857)
• A new GREL function detectLanguage was introduced (#642)
• New GREL functions encode and decode were introduced (#148)
• The error handling of the pow and exp functions was improved (#3062)
• The division operator returns NaN when computing 0/0 (#377)
• A function timeSinceUnixEpochToDate was introduced, to convert a duration since Epoch to a date object (#608)
• A function replaceEach was introduced, to replace multiple substrings in one go (#2606)

For extension developers

• (from 3.6-rc1 on) We migrated to jQuery 3.6.0. If you are using jQuery in your extension, some jQuery syntaxes that have been deprecated earlier might have been removed. If your extension runs with OpenRefine 3.5.2, you can check the web developer console for warning messages when the extension is used: fixing those should be enough for your extension to be compatible with OpenRefine 3.6 (#4891)

And many bug fixes, see the complete list of changes for 3.6.

Download

• Linux
• MacOS
• Windows without embedded JRE
• Windows with embedded JRE

This is the second beta release of the 3.6 series. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• The user is now warned when applying the "Fill down" or "Blank down" operations with a pending sorting criterion (#3256)
• The import preview refreshing can be disabled (#4009)
• Menu items to reveal collapsed columns were added to the column menus (#4067)
• The path to the refine.ini configuration file can now be changed on the command line (#4113)
• It is now possible to download the JSON representation of the operation history, without resorting to copy and paste (#4498)
• It is now possible to work with Wikibase instances with federation enabled (#4287)
• The merge strategy for statements can be configured in the Wikibase schema editor. This also adds support for deleting statements. Beware that schemas created with earlier versions of OpenRefine will still use the original merge strategy. (#3383, #2116, #4130)
• OpenRefine can edit MediaInfo entities and not just Items (#4270)
• It is possible to disable the new version notification by setting the configuration variable refine.display.new.version.notice=false (#4410)
• The dialog to reorder and delete columns was improved to easily delete most columns (#4557)
• The maximum editing speed and the Wikibase tag to apply to all Wikibase edits is now configurable for each Wikibase instance via its manifest (#3359)
• Extra URL fields in the starting page can be removed thanks to a new button (#4606)
• The "Use values as identifiers" operation now warns that it does not validate the identifiers (#3172)

GREL changes

• A new GREL function, parent, was introduced to obtain the parent element of an XML element (#4181)
• A new GREL function, scriptText, was introduced to obtain the text contained in a <script> or <style> element in HTML (#4189)
• The random (previously randomNumber) GREL function was improved (#3143)
• A new GREL function parseUri was introduced (#1857)
• A new GREL function detectLanguage was introduced (#642)
• New GREL functions encode and decode were introduced (#148)
• The error handling of the pow and exp functions was improved (#3062)
• The division operator returns NaN when computing 0/0 (#377)
• A function timeSinceUnixEpochToDate was introduced, to convert a duration since Epoch to a date object (#608)
• A function replaceEach was introduced, to replace multiple substrings in one go (#2606)

And many bug fixes, see the complete list of changes for 3.6.

For technical reasons this release was skipped, refer to 3.6-beta2 instead.

This is the third stable release of the 3.5 series. Please backup your workspace directory before installing and report any problems that you encounter.

New in 3.5.2

• Log4j was upgraded to 2.17.1

New in 3.5.1

• Log4j was upgraded to version 2.16.0
• OpenRefine is compatible with Java versions 8 to 17 (#4106)

New features in 3.5

• Wikidata support has been generalized to arbitrary Wikibase instances. (#1640)
• The cross function now accepts implicit project and column names (#2504)
• The left panel can be collapsed (#1038) and resized (#2771)
• Support for more Wikidata constraints was added (multi-value, difference within range, conflicts with, and citation needed constraints) (#2354)
• Splitting multi-valued cells is now possible by transition between uppercase/lowercase (#2238)
• When importing multiple archive files, importers can store the filename of the archive file each row was extracted from (#1963)
• It is now possible to go to a page of the project table directly (#2638)
• The pagination sizes offered by the UI can now be configured by setting the ui.browsing.pageSize preference to values such as [100,500,1000,2000] (#2624)
• Format detection at the import stage was improved (#2805, #2800)
• The split/join multivalued cells dialogs now remember the last separator used (#2197)
• The forEach GREL function works on JSON objects (#3149)
• A new GREL function wholeText can be used to extract all the text inside an XML element (including in its children) (#3180)
• A dialog to confirm the removal of starred expressions was added (#501)
• HTTP host validation was added (#3288)
• The Wikibase extension can now be used to add BCE dates (#3816)
• The common cell transforms can be run on a selection of columns easily (#1843)
• Greater numbers of rows per page can now be selected (#3249) (after 3.5-beta1)

See the full list of changes for 3.5.

Checksums

• openrefine-linux-3.5.2.tar.gz: SHA f5b295d62179a9ba218607a74b7d53d0b16e44ce
• openrefine-win-3.5.2.zip: SHA e3d457b8a6366ae7837f0dac8878d63a75236e04
• openrefine-win-with-java-3.5.2.zip: SHA f47910898c92d61d3610a5b5a18076a6ce9669c2
• openrefine-mac-3.5.2.dmg: SHA 7f0f1ed81ca41ea7a2f57852cc672d1781adc7b7

This is the first alpha release of the 4.0 series. Expect many bugs: your help is welcome to test this new architecture.

Main changes

• This new version uses a different workspace: your projects from OpenRefine 3.x will not appear in this version. They will not be deleted though: you can always open them again by running OpenRefine 3.x. Project archives exported from OpenRefine 3.x can be read in OpenRefine 4.x, but the operation history will be discarded.
• Project data no longer needs to fit in the working memory (RAM) of your machine. This makes it easier to work on large datasets. (#242)
• It is possible to execute OpenRefine operations in Apache Spark (#1433). The execution engine used by OpenRefine is currently selected at startup with the -r (Unix) or /r (Windows) parameter (it is foreseen that this will change before a stable release as Spark support will be moved to an extension, see #4396).
• Facet statistics are computed on a sample of rows by default. The size of the sample can be configured.
• The CSV/TSV importer supports a new option which controls whether rows are allowed to span multiple lines of the source file.

Documentation about those new features will be published soon.

For developers

Most extensions will be incompatible with this new version, as many incompatible changes have been introduced.

• OpenRefine now uses the org.openrefine namespace instead of com.google.refine.
• The code base was split into more granular Maven modules. Those modules are published to Maven Central to ease the development of extensions (currently in the snapshot repository as their structure is not final yet). Feedback about the module structure is welcome.
• The architecture of the data processing engine changed to make it extensible. The execution of workflows can happen fully in memory, off disk or in an Apache Spark, or in other execution engines if the corresponding runners are implemented. Feedback about the data model API is welcome.

A documentation of the new architecture will be published soon.

This is the second stable release of the 3.5 series. Please backup your workspace directory before installing and report any problems that you encounter.

New in 3.5.1

• Log4j was upgraded to version 2.16.0
• OpenRefine is compatible with Java versions 8 to 17 (#4106)

New features in 3.5

• Wikidata support has been generalized to arbitrary Wikibase instances. (#1640)
• The cross function now accepts implicit project and column names (#2504)
• The left panel can be collapsed (#1038) and resized (#2771)
• Support for more Wikidata constraints was added (multi-value, difference within range, conflicts with, and citation needed constraints) (#2354)
• Splitting multi-valued cells is now possible by transition between uppercase/lowercase (#2238)
• When importing multiple archive files, importers can store the filename of the archive file each row was extracted from (#1963)
• It is now possible to go to a page of the project table directly (#2638)
• The pagination sizes offered by the UI can now be configured by setting the ui.browsing.pageSize preference to values such as [100,500,1000,2000] (#2624)
• Format detection at the import stage was improved (#2805, #2800)
• The split/join multivalued cells dialogs now remember the last separator used (#2197)
• The forEach GREL function works on JSON objects (#3149)
• A new GREL function wholeText can be used to extract all the text inside an XML element (including in its children) (#3180)
• A dialog to confirm the removal of starred expressions was added (#501)
• HTTP host validation was added (#3288)
• The Wikibase extension can now be used to add BCE dates (#3816)
• The common cell transforms can be run on a selection of columns easily (#1843)
• Greater numbers of rows per page can now be selected (#3249) (after 3.5-beta1)

See the full list of changes for 3.5.

Checksums

• openrefine-linux-3.5.1.tar.gz: SHA d2b4298db9c771a85b955f20e923d3c0bf70c658
• openrefine-win-3.5.1.zip: SHA 1d30a812060c7832580b56d6de31a85f4a4c4deb
• openrefine-win-with-java-3.5.1.zip: SHA c0102e157db8470dd4d3da0f8cd9bf085f3f28c6
• openrefine-mac-3.5.1.dmg: SHA 40f8a40c18b366a142777ef49c8c7e87dbffeb06

This is the first stable release of the 3.5 series. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• Wikidata support has been generalized to arbitrary Wikibase instances. (#1640)
• The cross function now accepts implicit project and column names (#2504)
• The left panel can be collapsed (#1038)
• Support for more Wikidata constraints was added (multi-value, difference within range, conflicts with, and citation needed constraints) (#2354)
• Splitting multi-valued cells is now possible by transition between uppercase/lowercase (#2238)
• When importing multiple archive files, importers can store the filename of the archive file each row was extracted from (#1963)
• It is now possible to go to a page of the project table directly (#2638)
• The pagination sizes offered by the UI can now be configured by setting the ui.browsing.pageSize preference to values such as [100,500,1000,2000] (#2624)
• Format detection at the import stage was improved (#2805, #2800)
• The split/join multivalued cells dialogs now remember the last separator used (#2197)
• The forEach GREL function works on JSON objects (#3149)
• A new GREL function wholeText can be used to extract all the text inside an XML element (including in its children) (#3180)
• A dialog to confirm the removal of starred expressions was added (#501)
• HTTP host validation was added (#3288)
• The Wikibase extension can now be used to add BCE dates (#3816)
• The common cell transforms can be run on a selection of columns easily (#1843)
• Greater numbers of rows per page can now be selected (#3249) (after 3.5-beta1)

See the full list of changes for 3.5.

Checksums

• openrefine-linux-3.5.0.tar.gz: SHA 49354715470f0a71b3f5ec9911071f87adf54275
• openrefine-win-3.5.0.zip: SHA 42c8971afc996c8015d19b98af33dc4ae8602ee3
• openrefine-win-with-java-3.5.0.zip: SHA 055f185796ce2849f945485ee171a3a857982a6b
• openrefine-mac-3.5.0.dmg: SHA a7d34ac4c8528ecd53e84de1f90ad453a0ecc256

This is the second beta release for the 3.5 series. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• Wikidata support has been generalized to arbitrary Wikibase instances. (#1640)
• The cross function now accepts implicit project and column names (#2504)
• The left panel can be collapsed (#1038)
• Support for more Wikidata constraints was added (multi-value, difference within range, conflicts with, and citation needed constraints) (#2354)
• Splitting multi-valued cells is now possible by transition between uppercase/lowercase (#2238)
• When importing multiple archive files, importers can store the filename of the archive file each row was extracted from (#1963)
• It is now possible to go to a page of the project table directly (#2638)
• The pagination sizes offered by the UI can now be configured by setting the ui.browsing.pageSize preference to values such as [100,500,1000,2000] (#2624)
• Format detection at the import stage was improved (#2805, #2800)
• The split/join multivalued cells dialogs now remember the last separator used (#2197)
• The forEach GREL function works on JSON objects (#3149)
• A new GREL function wholeText can be used to extract all the text inside an XML element (including in its children) (#3180)
• A dialog to confirm the removal of starred expressions was added (#501)
• HTTP host validation was added (#3288)
• The Wikibase extension can now be used to add BCE dates (#3816)
• The common cell transforms can be run on a selection of columns easily (#1843)
• Greater numbers of rows per page can now be selected (#3249) (after 3.5-beta1)

See the full list of changes for 3.5.

Checksums

• openrefine-linux-3.5-beta2.tar.gz: SHA 20eee16459a3d246381aa6b64c8686e77063478d
• openrefine-win-3.5-beta2.zip: SHA 9799aa8d5bfc30edee44e64796979118c9c9e983
• openrefine-win-with-java-3.5-beta2.zip: SHA 9faf14441c588ae21dc6bd675acbb24a8c3640bb
• openrefine-mac-3.5-beta2.dmg: SHA c12423caac7b9227614554ea48c35eccb94ceabe

This is the first beta release for the 3.5 series. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• Wikidata support has been generalized to arbitrary Wikibase instances. (#1640)
• The cross function now accepts implicit project and column names (#2504)
• The left panel can be collapsed (#1038)
• Support for more Wikidata constraints was added (multi-value, difference within range, conflicts with, and citation needed constraints) (#2354)
• Splitting multi-valued cells is now possible by transition between uppercase/lowercase (#2238)
• When importing multiple archive files, importers can store the filename of the archive file each row was extracted from (#1963)
• It is now possible to go to a page of the project table directly (#2638)
• The pagination sizes offered by the UI can now be configured by setting the ui.browsing.pageSize preference to values such as [100,500,1000,2000] (#2624)
• Format detection at the import stage was improved (#2805, #2800)
• The split/join multivalued cells dialogs now remember the last separator used (#2197)
• The forEach GREL function works on JSON objects (#3149)
• A new GREL function wholeText can be used to extract all the text inside an XML element (including in its children) (#3180)
• A dialog to confirm the removal of starred expressions was added (#501)
• HTTP host validation was added (#3288)
• The Wikibase extension can now be used to add BCE dates (#3816)
• The common cell transforms can be run on a selection of columns easily (#1843)

See the full list of changes for 3.5.

Checksums

• openrefine-linux-3.5-beta1.tar.gz: SHA ada5f7b6d6efd670b4aef8632fc5571cc4dd2ea5
• openrefine-mac-3.5-beta1.dmg: SHA c11d156f04eb968740e1c8e724a13cc31996baa0
• openrefine-win-3.5-beta1.zip: SHA b594f3a9b2617cff6a18b13cba73c9595c14c858
• openrefine-win-with-java-3.5-beta1.zip: SHA dcfc3135c3e1ebff28b805c8a290c71fdedbc03c

This is a bug fix release for the 3.4 series. Please backup your workspace directory before installing and report any problems that you encounter.

Bug fixes

• The MacOS build displays the correct version number (#3196)
• The Google Drive and Google Sheets integration was fixed.

See the full list of changes for 3.4.

Checksums

• openrefine-linux-3.4.1.tar.gz: SHA bcff1764f9a6420024267e2a87b3e6b88641dd3d
• openrefine-mac-3.4.1.dmg: SHA ca1567dff7e83bc1d0f748df7631e67c1f5d8e25
• openrefine-win-3.4.1.zip: SHA e7f4183111fddf42ce2b51e9bb7d0715f00db50e
• openrefine-win-with-java-3.4.1.zip: SHA f38320d957da3ebf15471cb0727045e47ff0b051

This is the final release for OpenRefine 3.4. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• We now offer a Windows package with embedded Java runtime engine (no need to install Java with this one) (#2272)
• SQLite importer added (#1951)
• More languages including Bengali, Chinese (Simplified), Czech, and Punjabi, as well as better coverage for existing languages including Cebuano, English (UK), French, German, Hungarian, Italian, Japanese, Korean, Norwegian Bokmål, and Portuguese (Brazil).
• Clojure updated to 1.10 (#2608)
• Modal dialogs can now be closed with the ESC key (#1018)
• A cell.errorMessage field has been added, to fetch the error message stored in a cell (it was originally cell.error in 3.4 beta) (#525)
• Google OAuth credentials for Google Sheets and Google Drive integration are configurable (#2383)
• A new menu item was created to extract entity identifiers from a reconciled column (#1975)
• It is now possible to quote all cell values in the custom tabular exporter (#1869)
• An option was added in the CSV/TSV importer to strip whitespace in cell values (#791)
• The Google Sheets and Google Drive export have been added to the main "Export" menu (#2453)
• The cross function now supports any value for input (instead of just cells) and is no longer restricted to the column where it is invoked (#1950)
• The cross function now works for any type of cell value (#2461)
• It is now possible to configure the maxlag value used by the Wikidata extension by setting wikibase.upload.maxLag to some integer in the preferences (in 3.4 beta, it was wikibase:upload:maxLag and that was renamed later to match the naming convention of other preferences) (#2304)
• Facets can be minimized (#2553)
• Excel XLSX export column limit increased from 256 to 16K columns (#2600)
• Character encoding detection added for import (#486)

See the full list of changes.

Checksums

• openrefine-linux-3.4.tar.gz: SHA e75a4b1c7a4e5c0af2a1d2d278f7707980a59e18
• openrefine-mac-3.4.dmg: SHA f0aa34025b3137c6ccd6b49ee243cbdf06195995
• openrefine-win-3.4.zip: SHA d2bd2b36c9304dca8408d7b5719216286b0662c7
• openrefine-win-with-java-3.4.zip: SHA 1a57b8811af1aabe8a7632697b991db6a10f7ef4

This is the second beta release of OpenRefine 3.4. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• We now offer a Windows package with embedded Java runtime engine (no need to install Java with this one) (#2272)
• Importing data from SQLite is now possible (#1951)
• Modal dialogs can now be closed with the ESC key (#1018)
• A cell.errorMessage field has been added, to fetch the error message stored in a cell (it was originally cell.error in 3.4 beta) (#525)
• Google OAuth credentials for Google Sheets and Google Drive integration are configurable (#2383)
• A new menu item was created to extract entity identifiers from a reconciled column (#1975)
• It is now possible to quote all cell values in the custom tabular exporter (#1869)
• An option was added in the CSV/TSV importer to strip whitespace in cell values (#791)
• The Google Sheets and Google Drive export have been added to the main "Export" menu (#2453)
• The cross function now supports any value for input (instead of just cells) and is no longer restricted to the column where it is invoked (#1950)
• The cross function now works for any type of cell value (#2461)
• It is now possible to configure the maxlag value used by the Wikidata extension by setting wikibase.upload.maxLag to some integer in the preferences (in the first beta, it was wikibase:upload:maxLag and that was renamed later to match the naming convention of other preferences) (#2304)
• Facets can be minimized (#2553)

See the full list of changes.

Checksums

• openrefine-linux-3.4-beta2.tar.gz: SHA afdb901d67c7cb65ae1edd704a2050986f9f829e
• openrefine-mac-3.4-beta2.dmg: SHA f74eb021a4949790d01f1a92ad96431d532ef8ff
• openrefine-win-3.4-beta2.zip: SHA 751c25b7a0750e0e4a34ba356616248b904a0e58
• openrefine-win-with-java-3.4-beta2.zip: SHA c99a5974f0bf240f2b2cc3aef80236b3b7650c03

This is the first beta release of OpenRefine 3.4. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• We now offer a Windows package with embedded Java runtime engine (no need to install Java with this one) (#2272)
• Importing data from SQLite is now possible (#1951)
• Modal dialogs can now be closed with the ESC key (#1018)
• A cell.errorMessage field has been added, to fetch the error message stored in a cell (#525)
• A new menu item was created to extract entity identifiers from a reconciled column (#1975)
• It is now possible to quote all cell values in the custom tabular exporter (#1869)
• An option was added in the CSV/TSV importer to strip whitespace in cell values (#791)
• The Google Sheets and Google Drive export have been added to the main "Export" menu (#2453)
• The cross function is no longer restricted to source values from the column where it is invoked (#1950)
• The cross function now works for any type of cell value (#2461)
• It is now possible to configure the maxlag value used by the Wikidata extension by setting wikibase:upload:maxLag to some integer in the preferences (#2304)
• Facets can be minimized (#2553)

See the full list of changes.

This is the final release for OpenRefine 3.3. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• A new menu for joining (concatenating) columns has been added (#2109)
• Commonly used fields in dialogs now have autofocus (#2130)
• The Wikidata extension now supports adding dates with custom calendars (#2136)
• Calling reconciliation services via CORS is now supported (#2260)
• All columns can be blanked down or filled down at once (#2280)
• New "Blank values per column" and "Blank records per column" facets were added (#2220)

Vulnerabilities fixed

• A cross-site scripting vulnerability in the database extension was fixed (#2151)
• Cross-Site Request Forgery (CSRF) protection was added to POST API endpoints. If you rely on OpenRefine's server API you will need to adapt your calls accordingly (#2164)

See the full list of changes.

This is the first release candidate for OpenRefine 3.3. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• A new menu for joining (concatenating) columns has been added (#2109)
• Commonly used fields in dialogs now have autofocus (#2130)
• The Wikidata extension now supports adding dates with custom calendars (#2136)
• Calling reconciliation services via CORS is now supported (#2260)

Vulnerabilities fixed

• A cross-site scripting vulnerability in the database extension was fixed (#2151)
• Cross-Site Request Forgery (CSRF) protection was added to POST API endpoints. If you rely on OpenRefine's server API you will need to adapt your calls accordingly (#2164)

See the full list of changes.

This is the first beta release of OpenRefine 3.3. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• A new menu for joining (concatenating) columns has been added (#2109)
• Commonly used fields in dialogs now have autofocus (#2130)
• The Wikidata extension now supports adding dates with custom calendars (#2136)

Vulnerabilities

• A cross-site scripting vulnerability in the database extension was fixed (#2151)
• Cross-Site Request Forgery (CSRF) protection was added to POST API endpoints. If you rely on OpenRefine's server API you will need to adapt your calls accordingly (#2164)

See the full list of changes.

This is the final release of OpenRefine 3.2. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• New action to replace smart quotes to their ASCII equivalent (#1676)
• New phonetic clustering methods are available: Beider-Morse (#926) and Daitch-Mokotoff (#927)
• The "Uses values as identifiers" operation now accepts cells with RDF uris instead of just identifiers, using the identifierSpace declared by the reconciliation service (#1953)
• References in the Wikidata schema can be copied across statements and items (#1912)
• Items suggested by auto-complete can now be clicked with the middle button, which opens their URL in a new tab (#1934)
• Reconciliation previews are now shown when hovering the candidate (no click is needed). Clicking the candidate opens its page in a new tab. It is possible to disable this feature for matched cells by adding cell-ui.previewMatchedCells=false in the preferences. (#1943)

See the full list of changes.

This is the beta release of OpenRefine 3.2. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• New action to replace smart quotes to their ASCII equivalent (#1676)
• New phonetic clustering methods are available: Beider-Morse (#926) and Daitch-Mokotoff (#927)
• The "Uses values as identifiers" operation now accepts cells with RDF uris instead of just identifiers, using the identifierSpace declared by the reconciliation service (#1953)
• References in the Wikidata schema can be copied across statements and items (#1912)
• Items suggested by auto-complete can now be clicked with the middle button, which opens their URL in a new tab (#1934)
• Reconciliation previews are now shown when hovering the candidate (no click is needed). Clicking the candidate opens its page in a new tab. It is possible to disable this feature for matched cells by adding cell-ui.previewMatchedCells=false in the preferences. (#1943)

See the full list of changes.

This is the final release of OpenRefine 3.1. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• Importing n-triples, ttl, and JSON-LD files is now possible (#1758)
• The smartSplit function now supports any string, not just a single character. (#1761)
• A new menu to search and replace was added (#1742)
• A field to specify custom column names was added in the CSV/TSV importer
• It is now possible to import and export a Wikidata schema in JSON (#1776)
• Strings are now automatically trimmed in Wikidata schemas. The corresponding issues have been removed. (#1781)
• Browser-based autocomplete has been enabled for Wikidata edit summaries. (#1596)
• It is now possible to mark a column of identifiers as reconciled without calling the reconciliation service (#1778)
• The GREL function parseXml was added (#1818)
• The way text facets handle non-text values was changed. If you rely on this, make sure you add .toString() to the expressions used for text facets in your workflows. (#1662)

See the full list of changes.

OpenRefine is funded by the Google News Initiative.

This is the beta release of OpenRefine 3.1. Please backup your workspace directory before installing and report any problems that you encounter.

New features

• Importing n-triples, ttl, and JSON-LD files is now possible (#1758)
• The smartSplit function now supports any string, not just a single character (#1761)
• A new menu to search and replace was added (#1742)
• A field to specify custom column names was added in the CSV/TSV importer
• It is now possible to import and export a Wikidata schema in JSON (#1776)
• Strings are now automatically trimmed in Wikidata schemas. The corresponding issues have been removed. (#1781)
• Browser-based autocomplete has been enabled for Wikidata edit summaries. (#1596)
• It is now possible to mark a column of identifiers as reconciled without calling the reconciliation service. (#1778)

See the full list of changes.

OpenRefine is funded by the Google News Initiative.

This is the release of OpenRefine 3.0. Please backup your workspace directory before installing and report any problems that you encounter.

See the full list of changes.

OpenRefine is funded by Google News Initiative

This is the RC release of OpenRefine 3.0. Please backup your workspace directory before installing and report any problems that you encounter.

New features:

• Wikidata extension
• Data package metadata
• Tag system
• Google drive API
• OpenRefine Database Import Extension
• Add coalesce function
• Implement "Facet by null" and "Facet by empty string" and add to customized facets menu
• Feature Request: Export SqlDump
• Migrate from JRDF to JENA library
• Added option to toggle show/hide null values in cells in data-table
• Unify the internal date type
• Update OpenRefine logo
• Set http req headers
• Add find function
• Some bug fixes

See the full list of changes.

OpenRefine is funded by Google News Initiative

This is the beta release of OpenRefine 3.0. Please backup your workspace directory before installing and report any problems that you encounter.

New features:

• Wikidata extension
• Data package metadata
• Tag system
• Google drive API
• OpenRefine Database Import Extension
• Add coalesce function
• Implement "Facet by null" and "Facet by empty string" and add to customized facets menu
• Feature Request: Export SqlDump
• Migrate from JRDF to JENA library
• Added option to toggle show/hide null values in cells in data-table
• Unify the internal date type
• Update OpenRefine logo
• Set http req headers
• Add find function
• Some bug fixes

See the full list of changes.

OpenRefine is funded by Google News Initiative

This is the official release of OpenRefine 2.8. Please backup your workspace directory before installing and report any problems that you encounter.

New features:

• Project metadata support
• Enhancement of the reconciliation API
• Support split multivalued-cells by regex/special characters
• Text filter exclude
• Add free memory detection and Notification to user
• Improved UI for better usability
• New importer for Wikitables
• Some bug fixes

See the full list of changes.

OpenRefine is funded by Google News Initiative

This is the official release of OpenRefine 2.7. Please backup your workspace directory before installing and report any problems that you encounter.

New features:

• Wikidata Reconcile (replaced old Freebase Reconcile service) and hosted by Wikimedia Foundation.
• Export Clusters button on Clustering dialog.
• Japanese translation
• Support multiple "logical and" and "logical or" instead of just 2
• "Transform All" support to apply the operations to multiple columns
• Some bug fixes

See the full list of changes.