How to export data from Medical Tracker to a .csv or Excel document

Whether you want to create a back-up of the data on Medical Tracker, respond to a GDPR data request or simply want to conduct your own analysis of your school's records you can export the data to .csv or Excel from within the application.

How do I export the data from Medical Tracker?

Important: If you cannot see the cogwheel to export data you will need to ask the Medical Tracker Administrator of your school to update the permissions of the team your user belongs to. Please click here to find out how to enable this permission.


Within each module, underneath the date range on the left-hand side, there is a cogwheel which allows you to export the data you have filtered within that particular module.

For example in the image below you can see that we have changed the date range to 19 May 2015 and filtered the records by 'Harry Cookson' and pressed 'Export to CSV'. 

Screenshot 2024-04-08 at 14.50.39

This will then export to a .csv as you can see below:

screen shot of data imported to excel


Below we will go through a number of scenarios and detail how you would extract the data for each one: 

GDPR Request from a parent/carer:

Tip: Within each of the following modules you will have to repeat the process below:

  • Medication use
  • Medication expiry
  • Medical conditions
  • Incidents


Step 1: Within each module change the date range back to the date you started using Medical Tracker. If you are unsure when you purchased Medical Tracker for your school change it back to 01 May 2015 (this is when Medical Tracker was launched)*

*Please note that in the 'Medical conditions' and 'Medication expiry' modules you will not have a date range so simply skip to 'Step 2'.

Step 2: Enter the student's name into the 'Student name' column

Step 3: Press the cogwheel and 'Export to .csv'

Screenshot 2024-04-08 at 14.38.55

You will end up with four or five .csv files as your GDPR Data Request to give to the parent/carer.

Exporting all data from Medical Tracker for back-up purposes:

Tip: Within each of the following modules you will have to repeat the process below:

  • Medication use
  • Medication expiry
  • Medical conditions
  • Incidents


Step 1: Within each module change the date range back to the date you started using Medical Tracker or from the date you want to back up the data. If you are unsure when you purchased Medical Tracker for your school change it back to 01 May 2015 (this is when Medical Tracker was launched)*

*Please note that in the 'Medical conditions' and 'Medication expiry' modules you will not have a date range so simply skip to 'Step 2'.

Step 2: Press the cogwheel and 'Export to .csv'*

*Please note that within the 'Medical conditions' module you will have to repeat the process for the 'Archived' conditions

Screenshot 2024-04-08 at 14.45.01

You will end up with four or five .csv files as your data back up

Exporting filtered data for a specific purpose - in this example we will use 'Students gone to hospital' in the academic year 2021/22:

When exporting data from Medical Tracker it will automatically only export the data you have filtered within the module. In this example, we are going to export all the injuries in the academic year 2021/22 that have resulted the student going to hospital.

Step 1: Go to the incidents module and click the 'Injury' filter on the left-hand side

Step 2: Change the date range to 01/09/2021 to 31/08/2022

Step 3: Filter the 'What happened next' column to 'Student went to hospital'

Step 4: Press the cogwheel and 'Export to .csv'



This will then export to a .csv as you can see below:

Screenshot of imported CSV file to excel

How do I give users permission to export data from Medical Tracker?

1. The ability to export data is a permission-based feature controlled within the team the user belongs to that is controlled within 'Settings' -> 'Users and teams'. 

2. You will need to select the team the user/s are a part of

3. Select 'Team actions -> 'Edit team'

Diagram of how to give permission to export data

4. Within the 'Team' permission select 'Admin' and enable 'Export data'

5. Hit 'Save' - each user will need to log-out and log-in again for the updated permissions to take effect

Permission form with export data toggled to on position

If you have any feedback or questions, please reach out to our team by using our contact form. We're available 9am to 5pm Monday to Friday and happy to help!