# Importing Students

You can import data from a spreadsheet into EnterNOW

The spreadsheet will need to be exported or saved as a csv file

**The following fields are required, the rest are optional**

- First Name
- Last Name
- Date of Birth
- Gender

The following column headers are recognised, they are case insensitive, anything that doesn't match will be ignored.

**Student ID Number**

- cm.special(20)
- local student id
- id number
- pupil id
- student id
- reference
- slsnz id number

**Remote Unique Identifier** (used to match external systems)

- contactid

**Student Last Name**

- legal surname
- surname (preferred)
- surname
- last name
- family name
- preferred family name
- surname (legal)

**Student First Name**

- preferred firstname
- first name (preferred)
- first name
- first names
- preferred name
- first name (legal)
- first

**Gender** (Acceptable Values M or F)

- gender
- sex

**Date of Birth** (Expected format YYYY-MM-DD)

<div id="bkmrk-date-of-birth-%28yyyym">- date of birth (yyyymmdd)
- birthdate
- dob

</div>**Enrollment Date**

- first attendance
- date started here
- first started school

**Year Level**

- year level
- this year
- year

<div id="bkmrk-previous-school">**Previous School** </div>- previous school
- previous schools

<div id="bkmrk-email"><div>**Email**</div></div><div id="bkmrk-email-0"><div>- email

</div></div>**Phone**

<div id="bkmrk-phone-0">- phone

</div>**Address**

<div id="bkmrk-address-0"><div>- address

</div></div>**Suburb**

<div id="bkmrk-suburb-0"><div>- suburb

</div></div>**Town / City**

<div id="bkmrk-town%2Fcity-city"><div>- town/city
- city

</div></div>**Ethnicity**

<div id="bkmrk-ethnicity-0"><div>- ethnicity

</div></div>### The following applications should generate files with these headers

<div id="bkmrk-kamar"><div><div>**Kamar**</div></div></div>ID Number,Surname (Preferred),First Name (Preferred),Gender,Date of Birth,First Attendance,Year Level,Previous School 1 Name

<div id="bkmrk-musac"><div><div>**Musac**</div></div></div>Local student ID, Family Name, First Names, This Year, Gender, DOB, Date started here, Previous schools

<div id="bkmrk-etap"><div><div>**eTAP**</div></div></div>Pupil ID, Preferred Family name, Preferred name, Year level, Gender, Date of birth, First started school, Previous school

<div id="bkmrk-surf-life-saving-nz"><div><div>**Surf Life Saving NZ**</div></div></div>ContactID, SLSNZ ID Number, First Name, Last Name, Birthdate, Gender