SF1 → SF9 Masterlist Converter
Extract learner information from DepEd SF1 and copy the editable SF9 Masterlist columns separately, without touching protected Gender or Age formulas.
Privacy-first: The selected SF1 is read only in this browser tab. Learner data is not uploaded or stored by this tool.
1. Select SF1
Supports .xls, .xlsx and .xlsm. The tool finds the LRN, Name, Sex and Birth Date columns automatically.
Select an SF1 file to begin.
0Total
0Male
0Female
0Needs review
2. Copy editable columns
Important: birthdays are copied as plain DD/MM/YYYY text with no leading apostrophe, so the protected SF9 Age formula can parse them.
Male learners
NamesPaste at C7
BirthdaysPaste at K7
Female learners
NamesPaste at C58
LRNsPaste at H58
BirthdaysPaste at K58
3. Review extracted data
The three copied lists keep the same learner order. Review flagged rows before pasting.
| # | Name | LRN | Gender | Birthday | Age preview | Status |
|---|