An Excel Template Generator for Darwin Core

Luke Marsden; Olaf Schneider

doi:10.3897/biss.7.111907

Biodiversity Information Science and Standards : Conference Abstract

PDF

Conference Abstract

An Excel Template Generator for Darwin Core

Luke H Marsden^‡,§, Olaf Schneider^|

‡ The University Centre in Svalbard, Longyearbyen, Svalbard and Jan Mayen Islands

§ Norwegian Meteorological In, Oslo, Norway

| Norwegian Polar Institute, Tromsø, Norway

Corresponding author: Luke H Marsden (lukem@unis.no)

Received: 30 Aug 2023 | Published: 31 Aug 2023

This is an open access article distributed under the terms of the Creative Commons Attribution License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.

Citation: Marsden LH, Schneider O (2023) An Excel Template Generator for Darwin Core. Biodiversity Information Science and Standards 7: e111907. https://doi.org/10.3897/biss.7.111907

Abstract

Scientific data is diverse and can be complex, potentially including biotic or abiotic measurements, material samples, DNA derived data and more. Especially for researchers who are new to the Darwin Core standard (Darwin Core Task Group 2009), it is not always obvious what the best practice is for creating a Darwin Core Archive (GBIF 2021) for their data. Which core and extensions should they select? Which Darwin Core terms*1 should they include? We present the 'Learnings from Nansen Legacy template generator' (Marsden and Schneider 2023), a spreadsheet template generator to simplify the creation of Darwin Core Archives. It enables users to create a single Microsoft Excel file that includes one sheet per core or extension using a graphical user interface. The user can select from a complete list Darwin Core terms to use as column headers. There are requirements and recommendations for which terms are selected for each core and extension. Descriptions for all terms are displayed when one hovers over a Darwin Core term, and are stored as notes in the template when one select a relevant cell. The generated template includes cell restrictions to prevent one from inputting data in an incorrect format. A separate configuration is also available to aid researchers in creating CF-NetCDF*2 files for physical data, which are also compliant with the FAIR (Findable, Accessible, Interoperable, Resuable)*3 data management principles.

The Learnings from Nansen Legacy template generator is published (Marsden and Schneider 2023) and can be installed for use on your website or computer by following the instructions on the software's GitHub repository*4. The template generator can be tested where it is currently hosted, by SIOS*5 (Svalbard Integrated Arctic Earth Observing System). One can also refer to a YouTube tutorial*6 on how the template generator works.