---
title: Import records
description: Bring households, students, programs, sessions, class dates, and enrollments into Soljio from CSV files. Validate first, then import.
---

If your records live in a spreadsheet, you can import them instead of typing each one. You choose a type of record, upload a CSV file, match its columns to Soljio's fields, check the result, and then import.

**Who can do this:** owners and admins.

## Where to find it

Choose **Imports** in the dashboard menu, under **Administration**. The page shows four steps: **Upload**, **Map fields**, **Validate**, and **Import**. Past imports are listed below under **Recent imports**.

## Choose what to import

**Record type** offers six kinds of record.

| Record type | What it creates | Required columns |
| --- | --- | --- |
| **Households and guardians** | Family accounts and guardian contact records. | None |
| **Students** | Student profiles linked to households. | A name: **Display name**, or **Given name** and **Family name** |
| **Programs** | The top-level lesson types in your catalog. | **Program name** |
| **Sessions** | One-time or recurring sessions under existing programs. | **Session name**, **Program name** |
| **Class dates** | Individual class dates for existing sessions. | **Session name**, **Starts at**, **Ends at** |
| **Enrollments** | Links between existing students and sessions, and optionally class dates. | **Student name**, **Session name** |

Soljio's own description for **Students** adds: to update safety details, include the **Student ID** from an export or identify their household.

### The order to import in

Later types refer to earlier ones, so import them in this order:

1. **Households and guardians**
2. **Students**
3. **Programs**
4. **Sessions**
5. **Class dates**
6. **Enrollments**

If you skip a step, the rows that need it are flagged. For example, "Create or import this program before importing the session." and "Create or import this session before importing class dates." If a session names a **Term**, create that term first: "Create this term before importing sessions into it."

## Import a file

1. **Download a template**

    Pick a **Record type**, then choose **Download template**. It saves a CSV
    named like `soljio-programs-template.csv` with the right column names and
    one sample row. Open it in your spreadsheet app and replace the sample with
    your own records.

2. **Upload your file**

    Under **CSV file**, choose your file. Soljio reads the first row as the
    column names. Use a plain `.csv` file.

3. **Check the field mapping**

    **Field mapping** lists each **Column in your file** next to **Imports as**.
    Soljio matches common names for you, such as "dob" to **Date of birth**. If
    one is wrong or missing, pick the field from the list, or choose **Do not
    import** to skip that column. Required fields are marked with an asterisk.
    If a required field is not mapped, Soljio says, for example, "Program name
    must be mapped."

4. **Validate**

    Choose **Validate rows**. Nothing is imported yet. Soljio shows **Rows**,
    **Ready**, **Warnings**, and **Errors**, a list of **Row issues** with the
    row number and what to fix (row 1 is your header row), and a **Preview** of
    what each row would do: create, update, or skip.

5. **Import**

    When the numbers look right, choose **Import rows** and confirm. Soljio says
    how many rows will be added, and that rows with errors are skipped.

You must validate the current mapping before **Import rows** turns on. If you change the file, the record type, or the mapping, validate again.

:::warning
Import 250 rows or fewer at a time. A longer file is refused. Split it into several files and import them one after another.
:::

:::note
Leaving the page before you import discards your file, your mapping, and any validated rows. Nothing has been imported yet.
:::

## Formats to follow

- **Dates and times** use the form `2026-07-15T09:00:00`. Date of birth uses `2018-03-14`.
- **Timezone** is a name like `America/Los_Angeles`. Leave it blank to use the school's.
- **Capacity** is a whole number.
- **Status** for programs and sessions is `active`, `draft`, or `archived`. For enrollments it is `confirmed`, `pending`, or `waitlisted`.
- **Guardian email** must be a valid email address.

## Records that already exist

If a household, program, session, or class date already exists, Soljio reuses it and shows a warning such as "This household already exists and will be reused." A student who already exists is reused too. If your row includes safety details, such as allergies or medical notes, the preview shows **update** and the student's safety details are updated. A student who already has a current enrollment in a session is flagged with a warning and left as they are.

## See past imports

**Recent imports** lists the latest files with their **Status**, the **Rows**, **Created**, and **Issues** counts, and when each was applied. It reads "No imports yet. Finished imports are listed here." until you run one.

## If something goes wrong

| You see | What to do |
| --- | --- |
| Date of birth must use YYYY-MM-DD. | Fix the date format in your file. |
| Use an ISO date and time, for example 2026-07-15T09:00:00. | Fix the time format. |
| Use a valid IANA timezone, for example America/Los_Angeles. | Use a timezone name, not an abbreviation such as PST. |
| End time must be after start time. | Check the **Ends at** column. |
| Status must be active, draft, or archived. | Use one of the three values. |
| Capacity must be a whole number. | Remove decimals and text from the column. |
| Could not parse this CSV. | Re-save the file as CSV and check for an unclosed quote. |
