All guides

Import and export

Download your data as Excel, PDF, CSV or JSON, and bring a student list in from a CSV file.

Who uses this:OwnerAdmin and front deskAdministrators and front desk staff

Before you start

  • Needs one of these permissions: “View students”
  • Importing students needs the “Add students” permission.
On this page
  1. 1. Open Import & export
  2. 2. Pick a format
  3. 3. Export from any list page
  4. 4. Prepare your CSV file
  5. 5. Import students
  6. 6. Check the result
  1. 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. 1. Everything you can export
    2. 2. Student list
    3. 3. Download as Excel

    The Import and export page with the list of exports and format buttons.

    In this screenshot

    1. 1. Everything you can export
    2. 2. Student list
    3. 3. Download as Excel
  2. 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.

  3. 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. 1. Choose a format
    2. 2. For other systems
    3. 3. Go to import

    The Students page with the Export menu open showing Excel, PDF, CSV and JSON.

    In this screenshot

    1. 1. Choose a format
    2. 2. For other systems
    3. 3. Go to import
  4. 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.

  5. 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. 1. Which campus
    2. 2. Your CSV file
    3. 3. Start the import

    The Import students from CSV form with campus, file and Import button.

    In this screenshot

    1. 1. Which campus
    2. 2. Your CSV file
    3. 3. Start the import
  6. 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.

Was this guide helpful?