Can I export data from aligned studies in one spreadsheet?

Yes, it is definitely possible to export the full data set from multiple studies that have aligned participant keys.

  • Log in to the Ocean Portal and navigate to the Studies tab.
  • On one of your aligned studies, click "Export Results".
  • Select a date range for the data you want to export and then check off the "Export related study data" checkbox.
  • Select which aligned studies you want to export together and click "Save".
  • Your data will then be downloaded as a .csv file that can be opened in Microsoft Excel. In aligned study data exports, each row represents one item (i.e. question) that was completed on each form.
Have more questions? Submit a request