If your school uses Tes Timetable, you can export your class, student and teacher data directly into a format Atomi can import. This saves you from manually setting up classes and inviting users one by one.
Tes Timetable version 10.7.7 and above includes a dedicated Atomi export option. This guide walks you through the configuration, export and import process.
Before you start
You'll need:
A Tes Timetable (E10) login with administrator or timetable-editor access.
Your school's region is set correctly in Tes Timetable. Go to Setup > School info > Admin and check the region isn't set to "Unknown" or "Other". The Atomi sync option won't appear if the wrong region is selected.
Teacher and student email addresses entered in Tes Timetable. Both staff and student information need to be in the system for the export to work. If either is hosted in a separate student information system, you'll need to get that data into Tes Timetable first. See the troubleshooting section below if emails are missing.
The steps below are for reference and may be out of date from time to time. You can find the latest version on the Tes Timetable guide to Atomi sync (you'll need a Tes login to access it). If you're having issues with the export process, contact Tes support or visit edval.education/contact-us.
Configuring Tes Timetable
Open the File menu, then select Synchronise > Configure.
Click the plus (+) button to add a new sync profile.
Select Atomi from the sync dropdown menu.
Go to the Connection sub-tab.
Click the Browse button and choose a destination folder. This is where Tes Timetable will save the atomi_import.csv file.
Optional: Check the "Sync each time you save" checkbox if you'd like the file to export automatically each time you save.
If you don't see Atomi in the sync dropdown menu, your Edval licence may not have the preset enabled. Choose Custom export instead, or contact Tes support for help adding the Atomi preset.
Exporting from Tes Timetable
Before exporting, check that email addresses are filled in for your teachers and students. Open Students > Student data and Teachers > Teacher data to review them. If any are missing, a warning will pop up during the export.
Make sure you've completed the configuration steps above.
Open the File menu, then select Synchronise > Sync Now.
Select Atomi from the dropdown menu in the top-right corner.
Click the Create TT publish file button.
Select the rotations you want to export.
You can now find the atomi_import.csv file in the folder you set during configuration.
What's in the export
The CSV file contains the following data for each class:
Class name (code)
Year
Subject
Teacher email
Student emails
Example table of data for Class, Student, and Teacher from the exported CSV file.
Importing your data into Atomi
The Atomi team handles the import for you. Send the atomi_import.csv file as an email attachment to your Atomi Customer Success Manager or to provisioning@getatomi.com.
Once the team receives your file, they'll set up your classes and invite your students and teachers to your school account.
Troubleshooting
Tes warns me that emails are missing when I export. Some teachers or students don't have an email address recorded. Open Teacher data or Student data, find the blank rows and fill them in. If there are a lot, you can bulk-import them from a spreadsheet.
Student email addresses are missing from my export. This is the most common issue. Tes is built for timetabling, not for managing contact details, and many schools never enter student emails there. If that's the case, export a student list (name, student code, email) from your student information system instead. You can use the student codes to match it to the Tes export.
To do this, you can use a VLOOKUP formula in your spreadsheet application (such as Microsoft Excel or Google Sheets).
Open your Tes Timetable export file.
Open your student export in a separate sheet or tab.
Make sure both files contain a column with the student code. This is the shared value you'll use to match records.
In the Tes export, click into an empty column next to the student data you want to match.
Enter the following VLOOKUP formula: =VLOOKUP(A2, 'Atomi Export'!$A:$C, 2, FALSE) Here's what each part means:
A2 - the cell containing the student code you want to look up (adjust this to match your column).
'Atomi Export'! A:C - the range in your Atomi export where the formula should search. Column A should contain the student codes, and the other columns should contain the data you want to pull across (such as student email or name).
2 - the column number in that range to return (e.g. 2 for the second column).
FALSE - ensures the formula only returns exact matches.
Press Enter to run the formula.
Drag the formula down to apply it to all rows in the Tes export.
Review the results for any #N/A errors. These indicate a student code in the Tes export that doesn't have a match in the student export; you'll need to investigate these manually.
Where to go for help
For anything specific to Tes Timetable (Edval), including menu changes, missing export options or licence questions, visit the Tes help and support portal or contact Edval support through edval.education/contact-us.
For anything specific to Atomi, including how to use your exported file to set up your school account, email provisioning@getatomi.com.
FAQs
Can I re-run the export if my data changes?
Yes. If you checked the Sync each time you save checkbox during configuration, the export updates automatically. Otherwise, repeat the export steps to generate a fresh atomi_import.csv file and send it through to the team.
How long does it take for Atomi to process the import?
The team typically processes imports within three business days. If you need it sooner, mention the timeline when you send through the file.