Attendance Analyzer
Analyze attendance status or aggregate data from Excel files
Upload Your Excel File
Analyze attendance status or aggregate data from your spreadsheet
Attendance Status
Merge sheets, analyze last N days, auto-detect Active/Absent/Left
Data Aggregation
Count P/A/Leave, sum values, or list unique entries
Multi-Sheet Merge
Combine data from multiple sheets with branch labels
What Can You Do?
Attendance Status
Merge multiple sheets, analyze last N days, auto-detect Active/Absent/Left status for each employee
Data Aggregation
Count P/A/Leave, sum quantities, or list unique values by any column
Multi-Sheet Merge
Combine data from multiple sheets with branch labels into one report
How It Works
Upload Excel File
Upload your attendance report or data file. Supports .xls, .xlsx, and .csv formats.
Choose Mode & Configure
Pick Attendance Status (auto-detects structure) or Data Aggregation. Adjust column mapping and settings.
Analyze & Download
View results with status labels, summary dashboard, and download the report as Excel.
Features
Auto Status Detection
Automatically labels employees as Active, Absent, or Left based on recent attendance
Multi-Sheet Merge
Combine employees from multiple sheets (branches) into one report
Value Grouping
Map multiple values to categories (P, Present, PR → Present)
Excel Export
Download results with status and summary as an Excel file
Frequently Asked Questions
What does the Attendance Status mode do?
It merges data from multiple sheets, analyzes the last N days of attendance, and auto-generates a status for each employee: Active (present recently), Absent (some absences), or Left (absent for all recent days).
How does it detect the last filled date?
The tool scans backwards from the Date End Column to find the last column with actual attendance data (P/A values). It then takes the last N days from that point, so unfilled future dates are skipped automatically.
Can I merge multiple sheets?
Yes! In Attendance Status mode, select multiple sheets (e.g., HO, Branch1, Branch2). The tool merges all employees into one report with a Branch column showing which sheet they came from.
What is the Data Aggregation mode?
Data Aggregation is a general-purpose mode for counting, summing, or listing values. You select a lookup column and extraction range, then choose an aggregation type. Great for attendance counts, inventory, survey data.
Can I group similar values together?
Yes! In Data Aggregation mode, enable value grouping to map multiple values to a single category. For example, map "P, PR, Present" all to "Present" for cleaner reports.
Is my data safe?
Yes. All processing happens in your browser. No data is uploaded to any server. Your files stay completely private.