📊 Attendance Data Import System

✅ System Ready! PhpSpreadsheet is installed and ready to import Excel files.

📥 Download Sample Template

Download our pre-formatted CSV file with sample data. You can open it in Excel, edit the data, and save it as an Excel file (.xlsx) for import.

⬇️ Download Sample CSV Template

📋 How to Use the Template

Download the sample CSV template above
Open the file in Microsoft Excel or Google Sheets
Edit the sample data with your actual attendance records
Save the file as Excel format (.xlsx or .xls)
Upload the file using the form below

Column Format:

Column A: Person ID (e.g., 1001, 1002)
Column B: Name (e.g., John Doe)
Column C: Department (e.g., IT, HR, Sales)
Column D: Date (format: YYYY-MM-DD or MM/DD/YYYY)
Column E: Timetable (e.g., 9:00-17:00)
Column F: Attendance Status (e.g., Present, Absent, Late)
Column G-N: Time tracking data