Bulk Uploading Student Profile

Summary: Summary: This article provides specific details on bulk uploading student profile - meant to supplement basic student information as well to update student information in the system - using the powerful bulk upload feature.

The Bulk Upload article provides common general instruction on how to bulk upload various information into Grado. The focus here is on the crucial aspects of the CSV template for student profile. We will explore the required fields, clarify what information is essential, outline validation requirements, and show the correct format for a successful upload.

The bulk upload feature allows users to efficiently upload large amount of basic student information.

Prerequisites

Bulk uploading student information requires atthat leastbasic onestudent degreeinformation programis existingalready in the system. ForSome K10,information Elementarymay overlap (elem)such andas Juniorstudent Highnames), schoolin (hs)which programscase alreadythe existsdata in the student profiles CSV will overwrite the existing one in the system.

Bulk Uploading Degree Programs

Please follow the instructions here.

CSV Template Anatomy

Upon opening the CSV template for bulk uploading degreestudent programs,profile, you will see the following headers:

The table below outlines what each header mean as well acceptable values and validations for successful bulk upload of basic student information:profile:

Template Header	Description	Required?	Case-Sensitive?	Acceptable Values	Sample Values
Batch Name	Student batch name.	No.	NO	School batch name	J-2022
Student email	Student's school-provided or personal email address.	Optional depending on school settings. Auto-generated if left blank.	N/A	Student email	juandelacruz@school.edu.ph
Student first name	First name/s.	Yes.YES if no student number or LRN provided	N/AYES	Student first name	Juan
Student middle name	Middle name	YES if no student number or middleLRN initial/s.provided	No.	N/AYES	Student middle name	Carlos
Student last name	Last name	YES if no student number or surname.LRN provided	Yes.	N/AYES	Student last name	Dela Cruz
Student suffix	Name suffixes such as Jr., III etc.	No.No	N/A	Student suffix	Jr
Student numberNumber	School issues	YES if no LRN or student number.name provided	If left blank, system will auto-generate. See Student Number Generation.	N/AYES	Student number	2018-00624
LRN	Student Learner Number. Issued to DepEd K12 students.	No.YES if no student number or student name provided	N/AYES	StudentStuden LRN	108847120106
Educ Program short nameSex	Program shortened name.	Yes,	NO	Degree program short name given on the the schools degree programs	Academic – HUMSS Elem HS
School specialization name	Student's program specialization (e.g. major)	No.	NO	School specialization name	STEM Office Administration
Standing year level	Current study level of the student.	Yes.	NO	["kinder"male", "-12"m"] ["grade 1"female", "grade1", "grade one", "-11"] ["grade 2", "grade2", "grade two", "-10"] ["grade 3", "grade3", "grade three", "-9"] ["grade 4", "grade4", "grade four", "-8"] ["grade 5", "grade5", "grade five", "-7"] ["grade 6", "grade6", "grade six", "-6"] ["grade 7", "grade7", "grade seven", "-5"] ["grade 8", "grade8", "grade eight", "-4"] ["grade 9", "grade9", "grade nine", "-3"] ["grade 10", "grade10", "grade ten", "-2"] ["grade 11", "grade11", "grade eleven", "-1"] ["grade 12", "grade12", "grade twelve", "0"] ["1st year", "1styear", "first year", "1"] ["2nd year", "2ndyear", "second year", "2"] ["3rd year", "3rdyear", "third year", "3"] ["4th year", "4thyear", "fourth year", "4"] ["5th year", "5thyear", "fifth year", "5"] ["6th year", "6thyear", "sixth year", "6"f"]	Grade 1Male Grade 7 Grade 11 Third YearF
StandingStudent termcontact no	Current term	NO	N/A	11 digit contact no	9992214852
birth date		NO	N/A	MM/DD/YYY	10/25/1999
weight number		NO	N/A	Number should be have max precision of the6 studentand ifmax applicable.scale of 2.	Yes.1234.12 123456
weight unit		NO	NO	["1st"kg", "first"kilogram", "1"kilos"] ["2nd"lb", "second", "2"pound"] ["3rd"g", "three", "3"] ["year long", "yearlong", "year_long", "long year"] ["summer", "midsem", "summer/midsem", "midsem/summer", "4"gram"]	FirstKg Year longpound gram
Yearheight of entrynumber	Year the student entered the school.	Yes.NO	N/A	FourNumber digitshould yearbe have max precision of 3 and max scale of 2.	2018 2014 1.23 123 12.3
Yearheight Level on Entryunit	Student's study level upon school entry.	Yes.NO	NO	["m", "meter", "metre"] ["in", "inches", "inch"] ["cm", "centimeter", "centimetre"]	m inches centimetre
nationality		NO	N/A	["kinder", "-12"] ["grade 1", "grade1", "grade one", "-11"] ["grade 2", "grade2", "grade two", "-10"] ["grade 3", "grade3", "grade three", "-9"] ["grade 4", "grade4", "grade four", "-8"] ["grade 5", "grade5", "grade five", "-7"] ["grade 6", "grade6", "grade six", "-6"] ["grade 7", "grade7", "grade seven", "-5"] ["grade 8", "grade8", "grade eight", "-4"] ["grade 9", "grade9", "grade nine", "-3"] ["grade 10", "grade10", "grade ten", "-2"] ["grade 11", "grade11", "grade eleven", "-1"] ["grade 12", "grade12", "grade twelve", "0"] ["1st year", "1styear", "first year", "1"] ["2nd year", "2ndyear", "second year", "2"] ["3rd year", "3rdyear", "third year", "3"] ["4th year", "4thyear", "fourth year", "4"] ["5th year", "5thyear", "fifth year", "5"] ["6th year", "6thyear", "sixth year", "6"]Nationality	Grade 1 Grade 7 Grade 11 Third YearFilipino
CurriculumAddress Authorityhouse Numbernumber		NO	N/A	House number	#224
Address barangay		No.NO	YESN/A	Curriculum’s authority numberBarangay	Acad-HUMSSBrgy. 134 HSSan Jose
Address City or Municipality		NO	N/A	Municipality	Mabalacat City Angeles City
Address Street		NO	N/A	Street	Freesia st. Cabuco st.
Address province		NO	N/A	Province	Pampanga Bulacan
Address region		NO	N/A	Region	Region 3 Region III CALABARZON NCR
father last name		NO	N/A	Last name	Dela Cruz
father first name		NO	N/A	First name	Juanito
father middle name		NO	N/A	Middle name	Cabrera
mother last name		NO	N/A	Last name	Dela Cruz
mother first name		NO	N/A	First name	Maria
mother middle name		NO	N/A	Middle name	Gonzales
mother maiden name		NO	N/A	Mother’s maiden name	Maria Gonzales Carlos
guardian first name		NO	N/A	First name	Leonor
guardian last name		NO	N/A	Last name	Carlos
guardian relationship		NO	N/A	Relationship to guardian	Uncle
father contact no		NO	N/A	11 digit contact no	9374332635
mother contact no		NO	N/A	11 digit contact no	9756623811
guardian contact no		NO	N/A	11 digit contact no	9992214852

Double check information to be uploaded. Of particular note isare the LRN,LRN and contact numbers, which some spreadsheet programs convert to scientific notation. If saved as a CSV file and closed, the format will be retained and cannot be reconverted back to the proper format.