Skip to content
Soljio Docs
Esc
↑↓navigate↵open⌘Jpreview
On this page

Import records

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

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.

Upload your file

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

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.”

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.

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.

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.

Was this page helpful?