How to Export CSV file/s from your Timetable System

Use this article if:

Your school does not have a Timetable Integration with Edrolo, but uses one of the following timetable systems:

• Timetabling Solutions
• TES (E10)
• Griddle

Note: If you don’t have one of these timetable systems or an integration, please follow this article to complete Edrolo’s CSV timetable template.

Export Requirements

• We require the school’s full exported Timetable data files to set up your Edrolo classes
• Even after the initial set up, timetable data must contain all teachers, students and class details for all of your Edrolo classes
  • If any classes, teachers or students are missing it will result in them being removed from Edrolo when the timetable data in processed

Timetabling Solutions Export

If you use the TTS Desktop version, follow these steps to generate the required files:

1. Open your TTS file and ensure the correct date for your 2027 timetable is selected.
2. From the top menu, click File, then select Export Data —> Admin System.
3. From the drop-down list, select Edrolo, then click Next.
4. Click Export to export the files to your configured Export folder, or select a different location.
   • This will create three files titled:
     • Edrolo-Classes
     • Edrolo-Students
     • Edrolo-Teachers
5. Click Yes to close the export wizard.
6. Upload all three files in the Admin Hub

   1. Remember to choose Timetabling Solutions in the drop-down menu when attaching the 3 files

      

TES Edval Export

1. Navigate to File > Synchronise > Configure
2. Select the 'Sync' tab
3. Click on the blue plus button and select 'Edrolo (flat files)

4. 

5. Click on the Configure button, or, select the 'Connection' tab.
6. Destination Folder: Browse to select the folder where the two csv export files are to be saved, OK
7. Perform the Export
   1. Go to File > Synchronise > Sync now
   2. Select 'Edrolo (flat files)' from the Filter menu
   3. Select 'Create TT publish file'

8. The sync will create 2 CSV files in the folder specified earlier

   

9. Upload the csv file in the Admin Hub
   1. Remember to choose TES in the drop-down menu when attaching the two CSV files

Griddle Export

For instructions on exporting from Griddle, please refer to the attached PDF guide.

1. To export student allocations navigate to Reports > Student Allocations.
2. To generate the report select the relevant year level/s. Then click the export button.
3. Clicking the export button will download a .csv file of all selected student allocation data.

   1. Selecting Student Allocation data
      Note ‘Select All’ or ‘Deselect All’ in the options for the Year Level drop-down toggle.

      Clicking Select All will check all boxes, allowing for all data from all year levels to be
      exported. This can be useful if spreadsheet manipulation is required to produce whole
      school reports

4. Upload the csv file in the Admin Hub
   1. Remember to choose Griddle in the drop-down menu when attaching the CSV file

How to Send Your Exported Data to Us

Complete this step of the process once you have the required files in the correct format

1. Log in to the Admin Hub
2. Navigate to Timetabling and click on Upload CSV

3. In the ‘Timetable format’ drop down, select your schools Timetable system

4. In the ‘Timetable data is for’ drop down, select the Academic Year the data is for

5. Upload the correct number of files for your timetable system
6. You will get an on-screen notification that they have ben sent to Edrolo

Next steps:

1. A member of the Edrolo team will review your data to ensure it’s been correctly uploaded
2. Edrolo will then notify you that your data is ready to be mapped in Admin Hub
3. Once this is complete, you can refer to this article to complete Class Mapping

Need Help?

If something doesn't look right at any step, email us with:

• Your school's name.
• The academic year you're setting up (for example, 2027).
• Which timetabling software your CSV export came from (for example, TES or Edval).
• A description or screenshot of what you're seeing.

If you have any questions, please feel free to contact us at help@edrolo.com.au and our friendly Customer Care team will be happy to help.