Export Submissions

How do I export all of my submissions?

Navigate to your Submission Flow and click the ‘Export Submissions’ menu item.

To export in a spreadsheet format choose Excel or ‘ODS’ (Open Document).

To export your submissions in a format that is easy for a developer to use then use the JSON format.

To export all the files attached to your submissions, like photos, slides etc. choose the ‘Zip’ option.

How do I export a selection of submissions?

On the page with the list of submissions select the rows you want to export.

Then in the ‘bulk actions’ menu scroll down to ‘Export Submissions’ and choose the export format that you want.

To export in a spreadsheet format choose Excel or ‘ODS’ (Open Document).

To export your submissions in a format that is easy for a developer to use then use the JSON format.

To export all the files attached to your submissions, like photos, slides etc. choose the ‘Zip’ option.

How do I export files that have been uploaded to submissions?

When exporting your submissions choose the ‘Zip’ export format, this will export all the files attached to your submissions, like photos, slides etc.

Why does the export spreadsheet have several worksheets?

Your data is presented across multiple sheets to accommodate submissions with multiple speakers.

  • Combined Overview - This sheet shows all your submission data in a single sheet. In the following sets of columns

    • The submission title
    • The submitters name and email
    • The state of the submission
    • The submission created and submitted date
    • The submission questions
    • The speaker questions are repeated as many times as necessary. For example if you have a submission with three speakers associated to it then the there will be 3 sets of speaker columns.
    • The count of accept/maybe/decline review answers and the weighted average
    • The unique identifiers for the submission, the speakers and the reviews. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
  • Submissions - This sheet shows the details on the submission questions. In the following sets of columns

    • The submission title
    • The submitters name and email
    • The state of the submission
    • The submission created and submitted date
    • The submission questions
    • The count of accept/maybe/decline review answers and the weighted average
    • The unique identifiers for the submission, and the reviews. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
  • Speakers - This sheet shows the answers to the speakers question. There is one row per speaker so one submission may have multiple rows in this table. You can identify rows from the same submission using the ‘Submission Title’ or ‘Submission Id’ columns. It has the following set of columns

    • The submission title
    • The speaker questions
    • The submission id and th speaker id. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
  • Submission Reviews - This sheet shows the answers given to reviewers to the submission questions. It has the following set of columns

    • The submission title
    • The reviewers name and email address
    • The state of the review, ASSIGNED, IN_PROGRESS and COMPLETED
    • The reviewers recommendation, if any
    • The weighted score
    • The answers given by the reviewer
    • The answer given by the speaker and in the next column the comments given by the reviewer for that answer
    • The submission id and review id. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
  • Speaker Reviews - This sheet shows the answers given to reviewers to the speaker questions. It has the following set of columns

    • The submission title
    • The reviewers name and email address
    • The state of the review, ASSIGNED, IN_PROGRESS and COMPLETED
    • The reviewers comment on the speaker
    • The speaker answers
    • The submission id, speaker id and review id. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
  • Answers To Table Questions - If you have asked the ‘Table’ question then the answers will appear in this table. The submissions are grouped into rows.

    • The first row shows ‘Submission Details’, followed by the title, name and email address of the submitter
    • The following rows are the answer the submitter gave to the question