In OpenRefine you can save or export the project. This means you’re saving the data and all the information about the cleaing steps you’ve done. Once you’ve saved a Project, you can open it up again and be just where you left off.
By default OpenRefine is saving your project. If you close OpenRefine and open it up again, you’ll see a list of your projects. You can click on any one of them to open it up again.
You can also export a project, for instance if you wanted to send it to someone else.
- Go to the
Exportbutton in the top right. Click
Exportproject. This will save a compressed file that you can then open in OpenRefine that contains all the data and steps.
Save your work when you are done by exporting it in the desire format. Save your files with meaningful names, no spaces. Refine does not change your original dataset (hooray!).
- Go to
Exportin the top right. Click on the file type you want to export the data in.
Comma-separated valueswould be good choices.
That file will get exported to your default Download directory and can then be eaily opened in a spreadsheet program or imported into programs like R or Python.