Import and export
Download your data as Excel, PDF, CSV or JSON, and bring a student list in from a CSV file.
Before you start
- Needs one of these permissions: “View students”
- Importing students needs the “Add students” permission.
Step 1
Open Import & export
On the Students page, click “Import”, or go to /import-export. The “Export” card lists everything you are allowed to download, grouped into People, Academics, Admissions, Finance and Oversight.
In this screenshot
- 1. Everything you can export
- 2. Student list
- 3. Download as Excel
Step 2
Pick a format
Excel keeps numbers, dates and money as real values with your school's name on top. PDF is ready to print. CSV opens anywhere. JSON keeps empty values and leading zeros intact, so use it when moving to another system.
Step 3
Export from any list page
Every list page has its own “Export” button. It keeps the filters you set on that page, so a filtered list downloads exactly as you see it.
In this screenshot
- 1. Choose a format
- 2. For other systems
- 3. Go to import
Step 4
Prepare your CSV file
The first row must be a header row with a full_name column. You can also include date_of_birth, gender, phone, email, parent_name, parent_phone, parent_email, school, grade and status. Each file can have up to 500 rows and be up to 2MB.
Step 5
Import students
Under “Import students from CSV”, choose the campus the students belong to, pick your file and click “Import”. Student codes are generated for you, and a student with no status column is added as active.
In this screenshot
- 1. Which campus
- 2. Your CSV file
- 3. Start the import
Step 6
Check the result
A green message says how many students were created and how many rows were skipped, with the reason for each skipped row, for example a row with no name. The new students appear on the Students page.
Tips
- Try a file with a few rows first, check the result on the Students page, then import the rest.
Frequently asked questions
Why was my whole file refused?
The import checks your plan's student limit for the whole file before adding anyone. If the file would go over the limit, nothing is imported and the message tells you how much room is left.
Why can't I see some exports?
Each export needs the matching permission, for example invoices need permission to view invoices. The audit log export is only for the account owner.
Can I import classes, invoices or staff?
Not from this page. The CSV import adds students only.