Research Guides: DSS Social Sciences Workshop Resources: Exporting and Saving Data

Exporting and Saving Data in OpenRefine

Objectives:

1. Export cleaned data from an OpenRefine project.
2. Save an OpenRefine project as a shareable file.

Key Points:

1. Cleaned data, or selected data, can be exported from OpenRefine for use in other applications.
2. Projects can be exported to files that contain the original data and all data cleaning steps you performed.

Exporting and Saving Data in OpenRefine Video Demonstration
Watch the workshop zoom video demonstration on saving and exporting projects. Video length is 7 minutes 49 seconds.
Social Science Workshop Registration
Register for the Social Science Workshop to gain hands-on experience and practice section objectives.

Recommended Guides

Exporting and Saving Data from OpenRefine Guide
Workshop guide provided by Data Carpentry that explains exporting cleaned data, saving a project as a file, and importing a project.
OpenRefine Manual: Exporting your work
Provides an overview using the custom tabular exporter, SQL exporter, and templating exporter, and how to export a full project.

Online Tutorials

OpenRefine Tutorials: How to Export Your Project
RefinePro provides a tutorial on exporting data in Excel or csv format once a project is complete, and using the custom tabular exporter to control which field to export in OpenRefine. Video length is 1 minute and 35 seconds.