d9fc8450-10d0-4774-92af-257a1fc4e488 1.0 Biodiversity data from excel retriever 2025-11-05 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. Andrés Peredo Arce Senckenberg Society For Nature Research andres.peredo@senckenberg.de 1.0 https://metadatacatalogue.lifewatch.eu/srv/api/records/d9fc8450-10d0-4774-92af-257a1fc4e488/attachments/data%20management.jpg data management.jpg R Excel to CSV data management data validation Marco-Bolo MIT license https://github.com/QCDIS/Biodiversity_time_series_analyses_from_European_marine_ecosystems/blob/main/codebase/Data_cleaning_analysis_Example_1_03.ipynb WWW:LINK-1.0-http--link Source code on Github https://beta.naavre.net/jupyter/hub/user-redirect/lab/tree/Virtual%20Labs/Biodiversity%20Time%20Series%20Analyses/Git%20public/workflows/Biodiversity_time_series_analyser.naavrewf?profile=biotisan-euromarec WWW:LINK-1.0-http--link Workflow containing the workflow component (requires LifeWatch login) Template input excel file for Biodiversity data from excel retriever https://metadatacatalogue.lifewatch.eu/srv/eng/catalog.search#/metadata/bcc15634-2ea1-4a71-aab9-7ed77ae8a69e 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. Input file Species occurrence data https://metadatacatalogue.lifewatch.eu/srv/eng/catalog.search#/metadata/9f1f4f08-7bf3-45de-8fca-83b47619148e CSV file of species occurrence data. Output file Species occurrence metadata https://metadatacatalogue.lifewatch.eu/srv/eng/catalog.search#/metadata/e11ed9fe-6679-435a-9f2c-e87fa44ef908 CSV file of species occurrence metadata. Output file data processing https://helpdesk.lifewatch.eu