Google Sheet and MS Excel Expert

We work with multiple Excel and Google Sheets files for one school (attendance, academics, remarks, co-scholastic, etc.).

Your task is to combine these multiple data sources into one master sheet.
Most schools follow a similar structure, but some schools have different formats or logic, so flexibility is important. A fixed template will not work in all cases.

Scope of Work
Read data from multiple Excel and Google Sheets files
Clean and align mismatched columns
Merge data into one master sheet
Write formulas and/or Google Apps Script where required
Handle exceptions when formats differ
Debug and fix issues like blank outputs or broken logic

Skills Required
Google Sheets (advanced formulas)
Microsoft Excel
Google Apps Script
Strong data logic and problem-solving skills

Ideal Freelancer
Comfortable working with messy or non-standard data
Able to adjust logic school by school
Can explain their approach clearly

Deliverable
A working master sheet per school
Reusable logic with minor customisation when needed

Project Type
Ongoing / long-term work possible