Sonar Tracker

Overview

This article explains how to export data from Sonar Tracker for analysis in applications, for example, Microsoft Excel. It guides you through using the Pupil Data Export Wizard to select pupil groups, characteristics, assessment periods, subjects, and assessment types, then export your data as a CSV file. 

If you have migrated to Sonar Tracker from OTrack or Target Tracker and used reports that are not available in Sonar Tracker, use the Pupil Data Export Wizard to create your own CSV file so that you can curate, compare and analyse specific data based on your school's needs. 

Instructions

Follow these steps to export customised data from Sonar Tracker:

1. Select School.
2. Locate the Exports widget and select Pupil Data Export Wizard.

3. From Filter Pupils of the wizard, select the pupils that you want to export:

   

   1. Select one or more Pupil Groups, and optionally select any of the filters, for example, ethnicity groups, gender, attendance, focus groups, or SEN details.
   2. Select Next Step.

4. From Select Pupil Columns:

   

   1. Optionally, check / uncheck the Pupil Data Columns that you want to display as columns in your report.
   2. Select Next Step.

5. From Select Terms:

   

   1. Select one or more terms from this or previous academic years.
   2. Select Next Step.

6. From Select Subjects:

   

   1. Select one or more subjects whose data you want to include. You can choose EYFS subjects, Primary subjects, or both. Expand the areas as required.
   2. Select Next Step.

7. From Select Assessments :

   

   1. Select one or more Assessment for the assessment data that you want to include. Select one or more from Statutory, Summative, Summative Targets and Test Paper.
   2. Select Next Step.

8. From Review Summary:

   

   1. Review the summary of the data that is going to be exported in your report (based on your selections above).
   2. To continue with the data export, select Queue export.

Outcome

A message explains that your export has been queued:

The CSV file will be generated. 

Select Back to School Page to exit.

You will receive a message in your Sonar Tracker Inbox with a download link when the file is available.

The amount of time that the file takes to generate is dependent upon the amount of data you are exporting. Generally, this takes about 30 seconds, but it may take a few minutes. 

An example of the message is as follows:

Select the CSV file name to download a copy to your device. This can then be manipulated in a spreadsheet (for example, Microsoft Excel) and used for multiple purposes:

1. To create a report that is formatted based on your specific needs to simplify analysis.
2. To share specific data with governors.
3. Passed onto another school as appropriate, for example, when pupils leave.

Updated 31 March 2026 14:32