Mapping Master: A Flexible Approach for Mapping Spreadsheets to OWL

  • Martin J. O’Connor
  • Christian Halaschek-Wiener
  • Mark A. Musen
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6497)


We describe a mapping language for converting data contained in spreadsheets into the Web Ontology Language (OWL). The developed language, called M2, overcomes shortcomings with existing mapping techniques, including their restriction to well-formed spreadsheets reminiscent of a single relational database table and verbose syntax for expressing mapping rules when transforming spreadsheet contents into OWL. The M2 language provides expressive, yet concise mechanisms to create both individual and class axioms when generating OWL ontologies. We additionally present an implementation of the mapping approach, Mapping Master, which is available as a plug-in for the Protégé ontology editor.


Mapping Language Flexible Approach Mapping Expression Class Axiom Target Ontology 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    Langegger, A., Woss, W.: XLWrap – querying and integrating arbitrary spreadsheets with SPARQL. In: Bernstein, A., Karger, D.R., Heath, T., Feigenbaum, L., Maynard, D., Motta, E., Thirunarayan, K. (eds.) ISWC 2009. LNCS, vol. 5823, pp. 359–374. Springer, Heidelberg (2009)CrossRefGoogle Scholar
  2. 2.
  3. 3.
    Han, L., Finin, T.W., Parr, C.S., Sachs, J., Joshi, A.: RDF123: From spreadsheets to RDF. In: Sheth, A.P., Staab, S., Dean, M., Paolucci, M., Maynard, D., Finin, T., Thirunarayan, K. (eds.) ISWC 2008. LNCS, vol. 5318, pp. 451–466. Springer, Heidelberg (2008)CrossRefGoogle Scholar
  4. 4.
  5. 5.
  6. 6.
    Reck, R.P.: Excel2RDF for Microsoft Windows,
  7. 7.
    Grove, M.: Mindswap Convert2RDF Tool,
  8. 8.
    Huynh, D., Karger, D., Miller, R.: Exhibit: lightweight structured data publishing. In: Proceedings of the 16th International Conference on World Wide Web (2007)Google Scholar
  9. 9.
    O’Connor, M.J., Shankar, R.D., Tu, S.W., Nyulas, C.I., Das, A.K.: Developing a Web-Based Application using OWL and SWRL. In: AAAI Spring Symposium, Stanford, CA, USA (2008)Google Scholar
  10. 10.
  11. 11.
  12. 12.
  13. 13.
    Bizer, C.: D2R MAP - A Database to RDF Mapping Language. In: 12th International World Wide Web Conference, Budapest, Hungary (2003)Google Scholar
  14. 14.
    Gennari, J., Musen, M., Fergerson, R., Grosso, W., Crubezy, M., Eriksson, H., Noy, N., Tu, S.: The evolution of Protégé-2000: An environment for knowledge-based systems development. International Journal of Human-Computer Studies 58(1), 89–123 (2003)CrossRefGoogle Scholar
  15. 15.
    Knublauch, H.: An AI tool for the real world: Knowledge modeling with Protégé. JavaWorld, June 20 (2003)Google Scholar
  16. 16.
    World Health Organization. Production of ICD-11: The overall revision process (2007),
  17. 17.
  18. 18.
    O’Connor, M.J., Halaschek-Wiener, C., Musen, M.: M2: a Language for Mapping Spreadsheets to OWL OWL: Experiences and Directions (OWLED). In: Sixth International Workshop, San Francisco, CA (2010)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Martin J. O’Connor
    • 1
  • Christian Halaschek-Wiener
    • 2
  • Mark A. Musen
    • 1
  1. 1.Stanford Center for Biomedical Informatics ResearchStanfordUSA
  2. 2.Clados ManagementLLCSan MateoUSA

Personalised recommendations