Excel Attendance Table Creation
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I regularly pull attendance records from our online system and download them manually, usually as a CSV or Excel file. I need someone to take those exports, check the entries for obvious errors or duplicates, and then organise everything into a clean, structured table in Excel.
The finished sheet must, at minimum, include:
• Date and time
• Attendance status
If you can set up simple formulas, pivot tables, or conditional formatting that help me spot missing punches or late arrivals more quickly, that would be a plus, but the core deliverable is a well-formatted table ready for weekly reporting.
Because the data comes in via manual export/import, no API work is required this time. All work should be done directly in Excel, keeping the file lightweight and easy for me to update with each new download.
The finished sheet must, at minimum, include:
• Date and time
• Attendance status
If you can set up simple formulas, pivot tables, or conditional formatting that help me spot missing punches or late arrivals more quickly, that would be a plus, but the core deliverable is a well-formatted table ready for weekly reporting.
Because the data comes in via manual export/import, no API work is required this time. All work should be done directly in Excel, keeping the file lightweight and easy for me to update with each new download.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.