> For the complete documentation index, see [llms.txt](https://guide.fariaedu.com/openapply-implementation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://guide.fariaedu.com/openapply-implementation/implementation-phases/kick-off-call/data.md).

# Data

## Importing data to OpenApply

OpenApply can assist to facilitate the importation of various data types, including inquiries, applicant details, student records, and alumni information. Certain fields are mandatory and essential for the successful importation process into OpenApply.

{% hint style="info" %}
It usually takes our team around 1-2 weeks to import data, depending on the quality and quantity of the data.

We recommend ensuring that you are satisfied with the forms and fields in OpenApply before beginning the data import process, as this will help ensure a smoother and more accurate import.
{% endhint %}

\
As listed there, the following fields are required when importing data into OpenApply:

| Required Fields                                                                                                             | Examples                                                                                                                                                         |
| --------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **First Name**                                                                                                              | Henry                                                                                                                                                            |
| **Last Name**                                                                                                               | Epelbaum                                                                                                                                                         |
| **Grade**                                                                                                                   | Pre-K2, Pre-K3, Pre-K4, Kindergarten, Grade 1, Grade 2, Grade 3, Grade 4, Grade 5, Grade 6, Grade 7, Grade 8, Grade 9, Grade 10, Grade 11, Grade 12, Summer Camp |
| **Enrollment Year**                                                                                                         | Academic Year 2023-2024, Academic Year 2022-2023, Academic Year 2021-2022, Academic Year 2020-2021                                                               |
| **Student Status** If blank, the *Pending* status will be used by default.                                                  | Pending, Applied, Admitted, Wait-listed, Declined, Enrolled, Graduated, Withdrawn                                                                                |
| **Campus** Only required if there is more than one campus.                                                                  | Main Campus, Kenting Campus                                                                                                                                      |
| **Parent First Name**                                                                                                       | Thomas                                                                                                                                                           |
| **Parent Last Name**                                                                                                        | Epelbaum                                                                                                                                                         |
| **Parent Email**                                                                                                            | <thomas@example.com>                                                                                                                                             |
| **Parent Gender**                                                                                                           | Male                                                                                                                                                             |
| **Parent Relationship** If blank, a male parent will be set to the *Father* and a female parent will be set to the *Mother* | Father, Mother, Stepfather, Stepmother, Legal Guardian                                                                                                           |

In addition to these mandatory fields, you can also import additional fields that you wish, such as Gender, Birth Date, Nationality, Day/Boarding, etc.

\
Please refer to the attached example template below, showing how the data should look. (If you are importing 2 parents, then you would need to specify if the parent data is for parent 1 or parent 2, the parent fields should spread to the right of the excel file).&#x20;

{% file src="/files/qt5K811rXQZfoEuVjuk2" %}

So you could populate a spreadsheet such as this with your data from your current system, send it back to us, and then we could pass this to our data team for import. \
\
As well as thinking about which fields you want to import, you can also consider which existing data you want to import, e.g. if you are just importing current applicants, or if you are also importing applicants from previous years.