Biodiversity data from excel retriever

This is a NaaVRE workflow component / building block written in R that retrieves, validates, and saves biodiversity data and metadata from an Excel file for further processing. If the input file is not found in either location, the script stops with an error. It reads two sheets from the Excel file: Metadata and Data. It defines required columns for both data and metadata and checks if all required columns are present in the dataframes. If columns are missing or extra columns are present, the script stops with an error message. Finally, it writes the metadata and data to separate CSV files (metadata.csv and data.csv) in the temporary directory.

Date ( Publication): 2025-11-05

Status: Completed

Owner

Senckenberg Society For Nature Research - Andrés Peredo Arce

Version: 1.0

Keywords: R

Keywords: Excel to CSV

Keywords: data management

Keywords: data validation

Keywords: Marco-Bolo

Access constraints: License

Use limitation: MIT license

OnLine resource: Source code on Github (
WWW:LINK-1.0-http--link
)

OnLine resource: Workflow containing the workflow component (requires LifeWatch login) (
WWW:LINK-1.0-http--link
)

Operation name: Template input excel file for Biodiversity data from excel retriever

Web site: https://metadatacatalogue.lifewatch.eu/srv/eng/catalog.search#/metadata/bcc15634-2ea1-4a71-aab9-7ed77ae8a69e

Description: This is a template input file for the Biodiversity data from excel retriever workflow component. The Excel file includes four sheets to define and enable the metadata and data entry.