Projects / Student Data Merger
Student Data Merger
LiveCustom-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.
Platform highlights
Drag & drop upload
Upload both CSV files with drag-and-drop or a file picker. No installation or setup required.
Smart matching
Matches records across files using a common identifier with automatic normalisation and formatting tolerance.
Processing summary
Displays total students, matched emails, missing emails, and extra entries ignored after every merge.
One-click download
Download the merged CSV with a single click. Output includes a UTF-8 BOM for Excel compatibility.
Key features
Flexible CSV parsing
Automatically detects comma or semicolon delimiters and handles variable column structures with or without headers.
ID normalisation
Cleans and standardises identifier fields before matching, ensuring records link correctly across systems.
Duplicate handling
Automatically deduplicates records, keeping the most recent entry when multiple rows exist for the same person.
Automatic cleanup
Temporary files are deleted immediately after download. No student data persists on the server.
No database required
Entirely file-based processing. Deploy to any PHP server and it works immediately.
Excel-ready output
Output CSV includes a UTF-8 byte-order mark so Excel opens it with correct character encoding automatically.