Exporting Data from OpenApply

The OpenApply Team
  • Updated
Markdown
Quick answer:

You can export data to Excel or CSV from Settings > Import & Export > Export, or from the Enquiries, Applicants or Students roster using Export. You must enable two-factor authentication (2FA) on your account before you can export.

For admins exporting student data to Excel or CSV.

You must enable two-factor authentication (2FA) on your OpenApply account to export data. See Enabling Two Factor Authentication (2FA).

Export from Settings

  1. Go to Settings > Import & Export > Export.

  2. Choose what to export:

    • by form
    • by status
    • by programme
    • whether to include archived students
  3. Give the export (or export template) a name in the Export Template field.

    Screenshot: Export page in Settings, Import and Export

Export from a roster

You can export a filtered list from the Enquiries, Applicants or Students roster.

  1. Select Filter and filter for the group you need, for example by grade, status, gender or custom fields.

  2. Select all of the students.

  3. Select Export, then New Export or one of your export templates.

    Screenshot: Export menu on a roster with New Export and templates

Choose the fields

  • Drag fields from Available Fields to Export Fields to add them. You can pick fields from several forms.
  • Remove a field you do not need (for example Middle Name(s)) by selecting it in Export Fields.
  • Select Unselect All to clear every field if you only want a few.
  • Drag and drop fields in Export Fields to change their order.
  • System fields such as Student Status, Status Level and Application Date are under Extra Fields.
  • Student profile photos can be exported in bulk.
Screenshot: Available Fields and Export Fields columns
Available Fields and Export Fields columns.

Run and save the export

  1. Choose Excel or CSV format.

  2. If you will run this export again, select Create New Template to save it as a template.

  3. Select Export.

    Screenshot: file format, Create New Template and Export options
    File format, Create New Template and Export options.

You receive an email with a download link within 15 minutes. You can also find the file under Recent Exports at Settings > Import & Export > Export.

Things to know

  • To export the enquiry date, open Extra Fields and select ROI Submission Date.

The Status Level History column (and email variable) lists every recorded status level with its date, not only the current one. History before 9 November 2026 starts from the level each student had then.

Was this article helpful?

6 out of 12 found this helpful