Attendance data represents the summary of working hours and absences recorded by an employee over a specific period, categorized by reason. This includes ordinary and overtime hours, as well as various types of absences.
This data can be exported in raw or processed form for the entire company, a specific person, the user themselves, or a specific location or team.
Raw Data: Exported exactly as it was collected; ideal for technical integrations or deep analysis.
Processed Data: Reorganized to provide a clearer, more immediate overview for human reading.
Raw data export formats
Raw data is unprocessed information designed for analysis or data exchange with other systems. These can be exported as CSV files (compatible with spreadsheets or analysis software) or in specific payroll software formats designed exclusively for integration.
A raw attendance file collects all events recorded in a given month, such as:
Ordinary work
Overtime
Absences
Remote work
Each row in the file corresponds to a single daily event and includes:
The date of the event
Duration (in minutes)
The associated person
The associated reason/code (causale)
CSV Format
CSV (comma-separated values) is a text file organized into rows and columns where values are separated by a comma. The Fluida CSV export includes:
Company code
Employee code
Justification/Reason code
Duration (in minutes)
Date (format:
yyyyMMdd)
In this file, absence days show ordinary work hours as zero. Justifications are only exported if an External ID has been assigned in their settings. Ordinary work hours, when present, are identified by code 01.
Payroll Software Formats
These formats are intended solely for integration with specific payroll processing programs. These files are:
Difficult to read without specific software.
Structured according to precise technical specifications.
Based on sequential records or XML files.
Processed data export formats
Processed data is derived from raw data but reorganized to offer a comprehensive overview. These are downloadable in Excel format and can be set to Decimal (e.g., 1.5) or Hours and Minutes (e.g., 1h30m) during export.
Because of their visual structure, they are less suitable for complex formulas compared to raw data.
There are three types of processed files.
Excel - simple
Presents all data on a single sheet.
Daily detail: Ordinary work hours for each person.
Monthly summary: Total absences and extra hours categorized by group (Extra Work, Holidays, Permits, Sick Leaves, and Other Absences).
Excel - full
Also organizes data on a single sheet but with higher detail.
Daily detail: Ordinary work hours and specific absence types.
Monthly summary: Total hours for every single justification code used during the month.
Excel - attendance and timestamps
Available only if the Clock-in clock-out feature is active.
Structure: One person per sheet.
Detail: Displays attendance data side-by-side with actual clock-in records. It includes ordinary hours, the scheduled shift, and justification details, alongside a monthly summary.