18.1.21

OpenRefine: Create an empty column

 Sometimes you just need to add a new empty column to your OpenRefine project. The process is straight forward as we show in this video tutorial.


  • From any existing column select the option Edit column and then Add a column based on this column ... 
  • By default, the GREL formula repeat the value from the column you selected
  • Just replace the value with two quotes like this ""  to create an empty string. You can add any text between the quotes. OpenRefine will add it for all the rows selected by your facet.
  • Give your new column and name and click OK
  • and you are done! 
We made a quick video tutorial to show you the steps: