Data Import HR Administrator
Import data in bulk from Excel or CSV files.
Access
Sidebar → Administration → Data Import
Or directly via: /dashboard/data-import
Supported Import Types
| Data type | Format | Description |
|---|---|---|
| Employees | Excel (.xlsx) | Employee list with personal information |
| Financial transactions | Excel (.xlsx) | Financial operations history |
| Daily work | Excel (.xlsx) | Daily task register |
| Attendance | CSV (.csv) | Check-ins and absences |
Import Procedure
1. Prepare the File
Make sure your file meets the expected format:
- Headers: Columns must match system fields
- Encoding: UTF-8 recommended
- Date format: DD/MM/YYYY
Tip
Download the file template available on the import page to see the exact format required.
2. Upload the File
- Click Choose File
- Select your Excel or CSV file
- The system automatically analyses the columns
3. Verify the Mapping
The system displays a preview:
- Detected columns: Mapping to system fields
- Potential errors: Rows with missing or invalid data
- Duplicates: Entries already in the system
4. Run the Import
- Check the data preview
- Correct errors if needed
- Click Import
- Track progress in real time
5. Review the Results
After import:
- Successes: Number of rows imported
- Errors: Rejected rows with reason
- Warnings: Data automatically modified
Important
An import cannot be undone. Always verify the data before confirming.
Best Practices
- Back up your original file before importing
- Test with a small sample first (10-20 rows)
- Check the results after each import
- Document each import (date, source file, row count)