Excel 2 RDF API

This is an API that converts an Excel file available at a given URL into RDF, following the template rules described here.

API endpoint

The API is available at https://xls2rdf.sparna.fr/rest/convert

API parameters reference

The synopsis for calling the API is https://xls2rdf.sparna.fr/rest/convert?url=http://encoded.url.of.excel.file&noPostprocessings=true. Full list of parameters is given below :
Parameter name Required ? Description
url Required URL of the Excel file to convert.
To convert a Google spreadsheet, you can :
  1. Share the Sheet with everyone ("Everyone with the link" in Sharing options.) It is not possible to convert private Google Sheets.
  2. Build the Excel download URL of the sheet, which is https://docs.google.com/spreadsheets/d/{ID of your spreadhseet}/export?format=xlsx
  3. Use this as the URL value.
noPostProcessings Optional (recommended) Don't apply SKOS post-processings after conversion. Set this to true only if you are explicitely generating SKOS taxonomies.
format Optional Mime type of the RDF output format (e.g. "application/rdf+xml"). Turtle is returned by default
lang Optional Default language to apply to literal columns.
skosxl Optional Apply SKOS-XL post-processings to reify labels.
broaderTransitive Optional Adds skos:broaderTransitive explicit links.

API example

  1. Google spreadsheet at https://docs.google.com/spreadsheets/d/1S5K7cl-8-JFyqnCZP2pVhI3-E4IK0XgCPElkr657jJg
  2. Excel export of the spreadsheet at https://docs.google.com/spreadsheets/d/1S5K7cl-8-JFyqnCZP2pVhI3-E4IK0XgCPElkr657jJg/export?format=xlsx
  3. Result of RDF conversion at https://xls2rdf.sparna.fr/rest/convert?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1S5K7cl-8-JFyqnCZP2pVhI3-E4IK0XgCPElkr657jJg%2Fexport%3Fformat%3Dxlsx&noPostProcessings=true

Human input form

The RDF converter is integrated in the SKOS Play application where you will find a form to upload an Excel file.

Can I use this API in production ?

Of course not, you fool ! Please refer to the Github repository where you will find the open-source code of the converter as well as a command-line version.