Leapsome supports importing full historical employee data beyond just salary and bonus information. This enhanced feature allows you to upload past changes for all employee attributes, including custom attributes, providing complete visibility into employee progression and more accurate analytics.
When to use this feature
Use the 'Employee attribute changes (historical or scheduled)' import when you need to:
- Import historical changes from legacy systems or previous HRIS tools
- Fill analytics gaps by adding past employee data for complete charts and insights
- Create comprehensive change logs showing employee progression over time
- Schedule future attribute updates with specific effective dates
- Maintain historical records for attributes like job titles, departments, locations, or custom fields
How to import historical employee attribute changes
Navigate to Settings > Integrations and imports > Excel imports > select 'Employee attribute changes (historical or scheduled)' from the dropdown menu.
Download the template and populate it with your historical data. The template includes:
Required fields:
- Email* - Email of the user (must be a Leapsome user)
- Effective date* (DD-MM-YYYY) - The date when the change took effect
Optional fields:
- All user attributes as defined in your Profile fields and access settings
- Custom attributes specific to your organization
Key differences from the standard Users template:
- Users template - One row per employee showing current state as of today's date
- Employee attribute changes template - Multiple rows per employee, each with an effective date to capture changes over time
Template guidelines:
Each row should capture at least one attribute change for one employee at the specified effective date. The effective date can be in the past or in the future for scheduled changes.
You can include as many attributes as needed. Leave other columns blank if they didn't change (e.g., only need to update salary? Leave the rest empty).
Import settings:
Keep existing data and add new historical entries (check/unchecked)
Use this when you're adding historical changes without removing current data.
✔ Keeps all existing employee data
✔ Adds new entries to the change log history
✔ Uses the most recent value as the current value in the profile
When it is unchecked:
Only uncheck this if you want to reset and fully replace existing values for the attributes you've filled in for each user in the template.
- Deletes all existing values for these attributes
- Replaces them only with what's in this import
- Removes any scheduled future changes for them
Why this matters:
- All changes will show up in the employee's change log
- Analytics & charts will reflect past attributes for more accurate insights
Once uploaded, you can view the historical changes in each employee's change log by navigating to Company > Employees > select employee > Change log. This provides a complete audit trail of all attribute changes over time.
If a super admin needs to remove entries from the change log to "clean up" the log, you can click the trash icon next to the entry to archive that entry. These archived changes cannot be recovered after doing so.