Loading Data Using Refine

Upload Data in Refine

Example Data

For the examples in this guide, we will be working with the following dataset: Netherlands_restaurants.csv

Please note that to transform your data to RDF, you need a working GraphDB database and to connect Refine to GraphDB.

Start Refine

  1. Start OpenRefine.
  2. Open http://localhost:7333/ in a browser.

All data files in Refine are organized as projects. One project can have more than one data file.

The Create Project action area consists of three tabs corresponding to the source of data. You can upload a file from your computer, specify the URL of a publicly accessible data, paste data from the clipboard, use Google sheets, or use a database.

Create a Project

  1. Click Create Project ‣ Get data from.

  2. Select one or more files to upload:

    • from your computer

      _images/ontoRefine-upload-file.png
    • from web addresses (URLs)

      _images/ontoRefine-upload-file-url.png
    • from clipboard

      _images/ontoRefine-upload-file-clipboard.png
  3. Click Next.

  4. (Optional) Change the table configurations and update the preview.

    With the first opening of the file, Refine tries to recognize the encoding of the text file and all delimiters.

    _images/ontoRefine-table-configurations.png
  5. Click Create Project.

Import a project

To import an already existing Refine project:

  1. Go to Import Project.

  2. Select a file (.tar or .tar.gz)

  3. Import it.

    _images/ontoRefine-import-project.png

Open a project

Once the project is created:

  1. Go to Open Project.
  2. Click the one you want to work on.
  3. (Optional) You can also delete your project if you want to.
_images/ontoRefine-rename-delete.png

The result of each of these actions is a table similar to that of an Excel or a Google sheet:

_images/ontoRefine-view-project.png