User Skill Ratings Import
Overview
The User Skill Ratings Import allows you to bulk upload skill ratings for users. This is particularly useful when migrating from another skills management system, conducting large-scale skills assessments, or setting up target skill levels across your organisation.
What You Can Do
Import self-ratings (own ratings) for users
Import manager ratings for users
Import target skill levels
Update existing ratings or add new ones
Process large volumes of skill data efficiently
CSV File Format
Required Fields
Field | Description |
|---|---|
| User's email address or login name (depending on your account settings) |
| Exact name of the skill (must match existing skill in Learn Amp) |
Optional Fields
Field | Description |
|---|---|
| User's self-assessed rating (typically 1-5) |
| Manager's assessment of the user's skill level (typically 1-5) |
| The target skill level for this user (typically 1-5) |
Rating Scale
Skill ratings typically use a 1-5 scale:
Rating | Meaning |
|---|---|
1 | Beginner/No experience |
2 | Basic/Developing |
3 | Intermediate/Competent |
4 | Advanced/Proficient |
5 | Expert/Mastery |
💡 Tip: Your organisation may use custom rating labels—check your Skills settings for the specific descriptions used.
Import Process
Navigate to Settings → Company Settings → Imports → Skills
Click Start Import
Upload your CSV file
Map your CSV columns to the expected fields
Configure import settings (overwrite existing or add only)
Review and confirm the import
Column Mapping
During import, you'll map your CSV columns to Learn Amp fields:
User – The column containing user identifiers
Skill – The column containing skill names
Own Rating – User's self-rating column
Manager Rating – Manager's rating column
Target Rating – Target level column
💡 Tip: You don't need all rating columns—import only the data you have.
Import Settings
Override Existing Data
Setting | Behaviour |
|---|---|
Enabled | Existing ratings are overwritten with values from the CSV |
Disabled | Only new ratings are added; existing ratings are preserved |
Pre-requisites
Role Requirements
Only users with the Owner or Admin role can run User Skill Ratings imports.
Before You Start
Users must exist – All users referenced must have accounts in Learn Amp
Skills must exist – All skills referenced must be created in your Skills settings
User identifier – Know whether your account uses email or login name for user lookup
Exact skill names – Skill names must match exactly (including capitalisation)
Troubleshooting
Issue | Solution |
|---|---|
"User not found" | Verify the email/login name exactly matches the user's account |
"Skill not found" | Check the skill name matches exactly—including spaces and capitalisation |
Ratings not updating | Ensure "Override existing data" is enabled if you want to update existing ratings |
Partial import | Check the results CSV for row-level errors |
Wrong user identifier | Confirm whether your account uses email or login name for lookups |
FAQs
Q: Can I import ratings for skills that don't exist yet?
No—skills must be created first. Use the Skills settings to add skills before importing ratings.
Q: What happens if I import a rating for a user who already has one?
It depends on the "Override existing data" setting. If enabled, the existing rating is replaced. If disabled, the existing rating is preserved.
Q: Can I import partial data (e.g., only own ratings)?
Yes—only map the columns you have. Leave other rating columns unmapped.
Q: How do I identify which user identifier to use?
Check Settings → Company Settings → Login settings. If login names are enabled, you may use either email or login name.
Q: Can I delete ratings via import?
No—imports only add or update ratings. To remove ratings, edit user profiles directly in Learn Amp.
Q: What's the maximum file size?
Large files are supported, but very large imports may take time to process. Consider splitting into batches of 10,000 rows for efficiency.