Export to XLSX

Submitted transects can be exported to a tabular format in a .xlsx file for further analysis by clicking the ‘Export To XLSX’ button. Use the 'Filter Method' button next to the search bar to filter the submitted transects based on method. The total transects using the chosen method(s) will appear next to the filter button.

Data can only be exported when online and after transects have been submitted. Data in a test project will not be exported.

Make sure that the project is not a test project. Select which method you would like to download. All records of each sample unit with the same method will be combined into a single spreadsheet. This will begin downloading a .xlsx to your computer. All user levels (admin, observer, and read-only) can export data from a project.

Export submitted sample unit(s) per method by clicking the 'Export To XLSX' button.

To change a project from a "Test Project" to an actual project, click "Data Sharing" in the lefthand menu. Scroll down and uncheck the 'This is a test project' checkbox. Wait approximately 20 minutes for the data to sync with the server, and then you can export your data.

Change a project from a "Test Project" to an actual project by uncheck the 'This is a test project' checkbox.

MERMAID also calculates standard deviations corresponding to estimated sample event (site and date) averages. You can find this information in the exported data, under the Sample Event (SE) tab, or by retrieving sample event data using mermaidr, which gives direct access to MERMAID data through R Studio. 

After exporting your data, you can find the standard deviation values under the Sample Event (SE) tab.

Questions? You can reach out to us when online via the Contact link at the bottom of any page. An offline (pdf) version of this documentation is also available on the left side of the same area.