Custom-built efficiency tool for merging student CSV data from multiple sources.
The Student Data Merger is a custom-built efficiency tool that eliminates the manual work of combining student records from different administrative systems. Upload CSV files from separate sources, the tool automatically matches and merges records, and produces a single standardised output file ready for downstream processing or system import.
Upload both CSV files with drag-and-drop or a file picker. No installation or setup required.
Matches records across files using a common identifier with automatic normalisation and formatting tolerance.
Displays total students, matched emails, missing emails, and extra entries ignored after every merge.
Download the merged CSV with a single click. Output includes a UTF-8 BOM for Excel compatibility.
Automatically detects comma or semicolon delimiters and handles variable column structures with or without headers.
Cleans and standardises identifier fields before matching, ensuring records link correctly even with formatting inconsistencies between systems.
Automatically deduplicates records, keeping the most recent entry when multiple rows exist for the same person.
Produces a clean CSV with consistent column order - ready for import into downstream systems.
After every merge, a summary shows how many students were matched, how many are missing emails, and how many extra entries were ignored.
Validates file size, type, and structure before processing. Clear error messages guide users when files don't meet requirements.
Temporary files are deleted immediately after download. No student data persists on the server.
Entirely file-based processing with no database dependency. Deploy to any PHP server and it works immediately.
Output CSV includes a UTF-8 byte-order mark so Microsoft Excel opens it with correct character encoding automatically.
Bootstrap-based UI works on desktops, tablets, and phones. Staff can merge data from any device.
Designed to save staff hours of manual data entry by automating the merge of student records from separate systems.