This page contains help videos for schools which cover different data/spreadsheet topics. Aimed at giving advice which makes difficult-looking tasks easier, with step by step instructions, we hope these videos help you with your data and spreadsheet headaches.

These videos are hosted on Vimeo.com (a fancy video hosting website like, a bit like YouTube). If your school blocks access to Vimeo.com you will not be able to watch these videos.

Click here to try to watch these videos on a page where we host them on YouTube instead.

Topics include:

  • Common Primary, Junior and Infant School Data Spreadsheet Issues

  • Common Secondary and High School Data Spreadsheet Issues
  • Copying All Your Register Classes from your Spreadsheet to the Software

  • How to Add A Year ‘Prefix’ to Your Student Reg Class Data

  • Removing Additional Student Details from Rows in your Spreadsheet That Should Be Blank

  • Removing Duplicate Student, Parent and Teacher Records from your Spreadsheet

  • Removing Duplicate Student and Parent Rows Without Affecting the Teacher Rows

  • Removing Special Characters from your Data

  • Encoding your Data Spreadsheet so that Foreign Characters Upload Properly

Common Primary, Junior and Infant School Data Spreadsheet Issues

This video helps Primary Schools, Junior Schools and Infant Schools format their spreadsheet correctly, and check it for common errors or problems, so that it works perfectly in the Parents’ Evening Booking System. In this spreadsheet you will be taught how to check all of the main columns have data in them (and how to add data to them if they are missing some), how to check that all students have at least 1x parent (and how to add them if they don’t) and how to add teachers to each class if they are missing.

Common Secondary and High School Data Spreadsheet Issues

This video helps High Schools and Secondary Schools (and schools with more than 1x teacher per child) format their spreadsheet correctly. It helps you check your data for common upload errors or problems, so that it works perfectly in the Parents’ Evening Booking System.

In this spreadsheet you will be taught how to check all that all students have at least 1x parent (and how to add them if they don’t) and how to check which teachers are responsible for a class you know is a ‘split class’ (and how to change them if necessary).

Copying All Your Register Classes from your Spreadsheet to the Software

This short help video explains how you can copy the data from your spreadsheet and paste it into your Parents’ Evening Booking System to create a new event. This video simply shows a quick couple of hints and tips which will make the job very simple.

How to Add A Year ‘Prefix’ to Your Student Reg Class Data

This tutorial quickly shows you how to add a Year ‘Prefix’ to your Student Reg Class column in your school’s data spreadsheet. For example, if you need to add an ’11’ in front of all your Student Reg Classes, this videos shows you how.

Removing Additional Student Details from Rows in your Spreadsheet That Should Be Blank

This video helps schools remove additional/extra student details from rows in their data spreadsheet that should be blank.

Removing Duplicate Student, Parent and Teacher Records from your Spreadsheet

This tutorial explains how to remove duplicate rows in your data spreadsheet when students, parents and teachers have all been duplicated on a number of rows.

All we need to do is use Excel’s ‘Delete Duplicates’ tool to fix this.

Removing Duplicate Student and Parent Rows Without Affecting the Teacher Rows

This help video explains how to use a bolt-on for Excel called Kutools to remove Student and Parent rows fro a spreadsheet (when they have been duplicated) without deleting or affecting the Teacher rows. This is useful when you only want to show the student and parent on the top row, deleting the duplicates without deleting the teachers or the rows.

Removing Special Characters from your Data

This video helps you remove special characters, such as ” ‘ ” (apostrophy) or symbols, from your spreadsheet of data.

Encoding your Data Spreadsheet so that Foreign Characters Upload Properly

If your school has students, parents or teachers who have international/foreign characters in their names, your spreadsheet will not have coped with these properly in the past UNLESS you follow this guide, which explains how to ‘encode’ your spreadsheet properly, using Notepad++, so that the file uploads properly.