Loading Data Using 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

     

   • from web addresses (URLs)

     

   • from clipboard

     

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.

   

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.

   

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.

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