Importing & Exporting Data

Oh My School supports importing and exporting records directly from the admin panel, making data management quick and easy.

Importing Data

You can bulk-import student records from Excel (.xlsx) or CSV files. The engine automatically maps your file columns to the Fields you defined when creating the service.

Import Process

1. Locate your service name in the admin panel sidebar menu (e.g., "Graduation 2026" — a custom menu is automatically generated for each service you create).
2. Click on the service menu.
3. Click the Import button in the top action bar.
4. Upload your Excel or CSV file.
5. The engine displays a preview, validates the data, and runs duplicate checks.
6. Review any validation errors and confirm the import to insert the data.

Validation & Error Reporting

• Required Fields: All configured Identifier fields must have non-empty values.
• Duplicate Detection: Duplicate identifier values within the file or existing database are flagged before insertion.
• Header Mapping: Column headers in the spreadsheet must match the defined Field labels.
• Per-Row Error Reporting: If the validation fails, the interface reports exact errors on a per-row basis, telling you exactly which row and field caused the problem.
• Import Limits: Supports up to 10,000 rows per import batch.

Exporting Data

In addition to importing, Oh My School allows you to export existing service records at any time.

• Supported Formats: Excel (.xlsx) and CSV files.
• Purpose: Useful for backup, migrating data, or generating reports for school management.