Upload spreadsheets

Good news! You can now upload your existing data or 'legacy data' directly to MERMAID using our R package mermaidr.
Watch our step-by-step guide in uploading spreadsheest using the historical fishbelt data as an example.

If you are new to MERMAID and have existing data from past surveys in other formats that you would like to add to MERMAID, you can use our R package mermaidr to upload this old data into MERMAID. 

The workflow for uploading data should only be used for existing 'legacy' data. For an ongoing project, it is easier and better to enter your underwater observations directly in the app.

The ingestion workflow.

Steps for ingestion using the mermaidr package:

  1. Create a project in MERMAID with sites, management regimes, and users added.

  2. Adjust your data format to the MERMAID template. You can download the template for each method using the mermaid_import_get_template_and_options function from the MERMAID R package mermaidr. More information on how to use it can be seen here.

  3. Ensure the mandatory fields are filled. Mandatory fields include an asterisk (*) sign in the column name. Download our example of PIT data using the MERMAID template here.

  4. Check each field to make sure it matches allowed field options for importing data for a given method. To check each field, use the mermaid_import_check_options function from the MERMAID R package mermaidr. More information and example on how to use it can be seen here. A field that matches will produce a green check sign.

  5. After all fields have passed the checking process, you can import your data using the mermaid_import_project_data function from the MERMAID R package mermaidr. Detailed information and an example can be seen here.

All ingested data will appear on the Collecting page. These data will need to go through the regular validation and submission process. For an example how to ingest your legacy data using the MERMAID R package mermaidr, head to the ingesting fishbelt data example.

Unsubmitted ingested transects appear on the Collecting page of the user who did the ingesting. To transfer unsubmitted sample units to another user, a project admin can use the project's Users page.

Ingested data will appear in your collecting page and will be shown on the Project Page under the COLLECTING tab. The number in the red circle shows the number of sample units in your collecting page, while the number without the red circle show the total unsubmitted sample units in a project.

Read and download here the step-by-step guide on how to upload your existing data into MERMAID using the mermaidr package in R.