Skip to main content
SpringerLink
Log in

Linked Data Creation with ExcelRDF

  • Conference paper
  • First Online:
The Semantic Web: ESWC 2020 Satellite Events (ESWC 2020)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 12124))

Included in the following conference series:

Abstract

Constructing an RDF-based knowledge graph requires designing a data model (typically an OWL ontology) and transforming one’s data into an RDF representation that is compliant with said model. This paper introduces ExcelRDF, a plugin for Microsoft Excel that is intended to simplify the latter task. ExcelRDF can translate an OWL ontology into an Excel skeleton file (empty apart from column headers). It can then, once that skeleton file has been filled out with data, translate it back into an RDF graph representation. ExcelRDF is designed to be simple to install and use, and to work with existing Excel-based data management workflows.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://dev.realestatecore.io/ExcelRDF/.

  2. 2.

    https://github.com/marcelotto/spread2rdf.

  3. 3.

    https://github.com/antidot/db2triples.

  4. 4.

    http://openrefine.org/.

  5. 5.

    https://github.com/Data2Semantics/TabLinker.

  6. 6.

    https://www.dotnetrdf.org/.

  7. 7.

    Supported serializations: XML/RDF, Turtle, JSON-LD, NTriples, NQuads, and TriG.

  8. 8.

    Supported serializations: RDF/XML, Turtle, and NTriples.

References

  1. Bizer, C., Seaborne, A.: D2RQ – treating non-RDF databases as virtual RDF graphs. In: Poster at the 3rd International Semantic Web Conference, Hiroshima, Japan, November 2004

    Google Scholar 

  2. Das, S., Sundara, S., Cyganiak, R.: R2RML: RDB to RDF Mapping Language, September 2012. https://www.w3.org/TR/r2rml/

  3. Hammar, K., Wallin, E.O., Karlberg, P., Hälleberg, D.: The RealEstateCore ontology. In: Ghidini, C., et al. (eds.) ISWC 2019. LNCS, vol. 11779, pp. 130–145. Springer, Cham (2019). https://doi.org/10.1007/978-3-030-30796-7_9

    Chapter  Google Scholar 

  4. Langegger, A., Wöß, W.: XLWrap – querying and integrating arbitrary spreadsheets with SPARQL. In: Bernstein, A., et al. (eds.) ISWC 2009. LNCS, vol. 5823, pp. 359–374. Springer, Heidelberg (2009). https://doi.org/10.1007/978-3-642-04930-9_23

    Chapter  Google Scholar 

  5. Lohmann, S., Negru, S., Haag, F., Ertl, T.: Visualizing ontologies with VOWL. Semant. Web 7(4), 399–419 (2016). http://dx.doi.org/10.3233/SW-150200

  6. Maguire, E., González-Beltrán, A., Whetzel, P.L., Sansone, S.A., Rocca-Serra, P.: OntoMaton: a bioportal powered ontology widget for Google spreadsheets. Bioinformatics 29(4), 525–527 (2013). https://doi.org/10.1093/bioinformatics/bts718

  7. Shimizu, C., Hammar, K.: CoModIDE - The comprehensive modular ontology engineering IDE. In: ISWC 2019 Satellites. CEUR Workshop Proceedings, vol. 2456, October 2019. http://urn.kb.se/resolve?urn=urn:nbn:se:hj:diva-46397

  8. Tudorache, T., Nyulas, C., Noy, N.F., Musen, M.A.: WebProtégé: a collaborative ontology editor and knowledge acquisition tool for the Web. Semant. Web 4(1), 89–99 (2013). http://dx.doi.org/10.3233/SW-2012-0057

  9. Wolstencroft, K., et al.: RightField: embedding ontology annotation in spreadsheets. Bioinformatics 27(14), 2021–2022 (2011). https://doi.org/10.1093/bioinformatics/btr312

Download references

Author information

Authors and Affiliations

  1. Jönköping University, Jönköping, Sweden

    Karl Hammar

Authors
  1. Karl Hammar
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Karl Hammar .

Editor information

Editors and Affiliations

  1. University of Erlangen-Nuremberg, Nuremberg, Germany

    Andreas Harth

  2. National Research Council, Rome, Italy

    Valentina Presutti

  3. Eurecom, Sophia Antipolis, France

    Raphaël Troncy

  4. Karlsruhe Institute of Technology, Karlsruhe, Germany

    Maribel Acosta

  5. Institute for Information Business at WU Wien, Vienna, Austria

    Axel Polleres

  6. Institute for Information Business at WU Wien, Vienna, Austria

    Javier D. Fernández

  7. Siemens AG Österreich, Vienna, Austria

    Josiane Xavier Parreira

  8. Linköping University, Linköping, Sweden

    Olaf Hartig

  9. Aalborg University, Aalborg, Denmark

    Katja Hose

  10. Vrije Universiteit Amsterdam, Amsterdam, The Netherlands

    Michael Cochez

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Hammar, K. (2020). Linked Data Creation with ExcelRDF. In: Harth, A., et al. The Semantic Web: ESWC 2020 Satellite Events. ESWC 2020. Lecture Notes in Computer Science(), vol 12124. Springer, Cham. https://doi.org/10.1007/978-3-030-62327-2_18

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-62327-2_18

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-62326-5

  • Online ISBN: 978-3-030-62327-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation