Importing your Waitlist - User Guide for CSV file – Help Centre

Guide to CSV spreadsheet Column Headers
Request Date*	The date the parent submitted a waitlist request. Format is DD-MM-YYYY.
Care Required Date*	The date the parent needs childcare for their child. Format is DD-MM-YYYY.
Child First Name*	The first name of the child e.g. John. If left blank, the field will be assigned N/A.
Child Last Name*	The last name of the child e.g. Smith. If left blank, the field will be assigned N/A.
Parent1 First Name*	The first name of the parent1. e.g. Margaret. If left blank, the field will be assigned N/A.
Parent1 Last Name*	The last name of parent1. e.g. Smith. If left blank, the field will be assigned N/A.
Parent1 Email	The email address of the parent e.g. margaret.smith@gmail.com
Parent1 Mobile	The mobile number of the parent e.g. 0414456132. You do not need to use international dialling codes, you can present the number in its local format. This field can be left blank.
Parent2 First Name	The first name of parent2. e.g. Charlie. If left blank, the field will be assigned N/A.
Parent2 Last Name	The last name of parent2. e.g. Smith. If left blank, the field will be assigned N/A.
Parent2 Email	The email address of the second parent e.g.charlie.smith@gmail.com This field can be left blank.
Parent 2 Mobile	The mobile number of the second parent e.g. 0414456132. You do not need to use international dialling codes, you can present the number in its local format. This field can be left blank.
Parent1 Home Phone	The home phone number of the parent e.g. 0298890013. You do not need to use international dialling codes, you can present the number in its local format. This field can be left blank.
Parent1 Workphone	The work phone number of the parent e.g. 0298890013. You do not need to use international dialling codes, you can present the number in its local format. This field can be left blank.
Parent 2 Home Phone	The home phone number of the second parent e.g. 0298890013. You do not need to use international dialling codes, you can present the number in its local format. This field can be left blank.
Parent 2 Workphone	The work phone number of the second parent e.g. 0298890013. You do not need to use international dialling codes, you can present the number in its local format. This field can be left blank.
Address	The street address of the family's physical address. This field can be left blank.
Suburb	The suburb of the family's physical address. This field can be left blank.
State	The state of the family's physical address. Use acronyms e.g. NSW. This field can be left blank.
Postcode	The postcode of the family's physical address. Must be a numerical value. This field can be left blank.
Child DOB*	The date of birth of the child. Format is DD-MM-YYYY.
Gender	1 = Male, 2 = Female, 3 = To Be Announced (TBA). This field can be left blank.
Country	The country of the family's physical address. This field can be left blank.
Monday*	Indicate if the family needs Monday as a day of care. 1 = Yes, 0 = No
Tuesday*	Indicate if the family needs Tuesday as a day of care. 1 = Yes, 0 = No
Wednesday*	Indicate if the family needs Wednesday as a day of care. 1 = Yes, 0 = No
Thursday*	Indicate if the family needs Thursday as a day of care. 1 = Yes, 0 = No
Friday*	Indicate if the family needs Friday as a day of care. 1 = Yes, 0 = No
Flexible	Indicate if the family is flexible with their required days. 1 = Yes, 0 = No. This field can be left blank.
Note 1 Subject	Notes will be attached to the Interactions History of the child's waitlist. Indicate a subject for note 1 e.g. Phone Call. This field can be left blank.
Note 1 Body	Notes will be attached to the Interactions History of the child's waitlist. Provide further detail for note 1 e.g. Phoned mum and she asked to change their cate date to July. This field can be left blank.
Note 2 Subject	Notes will be attached to the Interactions History of the child's waitlist. Indicate a subject for note 2 e.g. Tour. This field can be left blank.
Note 2 Body	Notes will be attached to the Interactions History of the child's waitlist. Provide further detail for note 2 e.g. Toured in April with Centre Manager and seemed to enjoy the service. This field can be left blank.
Note 3 Subject	Notes will be attached to the Interactions History of the child's waitlist. Indicate a subject for note 3 e.g. Email. This field can be left blank.
Note 3 Body	Notes will be attached to the Interactions History of the child's waitlist. Provide detail for note 3 e.g. Emailed in October advising of January enrolments season. This field can be left blank.
Waitlist No. of Days Requested	Indicate the number of days the family needs childcare. Enter a numerical value of 1,2,3,4 or 5. This field can be left blank.
Waitlist Priority (1,2,3)	All Australian approved services with the exception of Occasional Care must adhere to Priority of Access Guidelines to ensure there is a fair child care system. Children can be assigned a numerical value of 1, 2 or 3. For more information on how to assign priority to children, see: https://docs.education.gov.au/system/files/doc/other/instruction_sheet_10_-_priority_of_access_guidelines_for_child_care_services_0.pdf. This field can be left blank.. This field can be left blank.
Referral Source (1-24)	Google = 1, CareforKidsWebsite = 2, MyChildWebsite = 3, OurWebsite = 4, WordOfMouthReferral = 6, DriveWalkPast = 7, Other = 8, Imported = 10, MyWaitlist = 11, Facebook/Social Media = 12, Newspaper = 13, Flyer = 14, Employer = 15, Event = 16, OutdoorAdvertising = 17, CoffeeCupAdvertising = 18, VacancyCare = 19, ChildCareNearMe = 20, CentreTransfer = 21, ReturningFamily = 22, Expo = 23, Toddle = 24

Guide to CSV spreadsheet Column Headers

Related articles