Exporting Skills Data

Exporting Skills Data

Overview

Exporting skills data gives you a downloadable record of skill information that you can use for reporting, analysis, or integration with other systems. Whether you need to review an individual's skill profile offline, share data with stakeholders, or perform bulk analysis, Learn Amp makes it easy to export skills to CSV format.


Functionality Breakdown

What You Can Export

User Skills Export

Export a user's complete skill profile including:

  • Skill names

  • Self-rating (numeric value and label)

  • Target rating (numeric value and label)

  • Manager rating (numeric value and label)

Export Format

Exports are provided as CSV files (comma-separated values), which can be opened in:

  • Microsoft Excel

  • Google Sheets

  • Numbers (Mac)

  • Any spreadsheet application

Export Columns

Column

Description

Column

Description

user_name

The user's full name

skill_name

Name of the skill

own_rating_integer

Self-rating as a number (e.g., 3)

own_rating

Self-rating label (e.g., "Competent")

target_rating_integer

Target rating as a number

target_rating

Target rating label

manager_rating_integer

Manager rating as a number

manager_rating

Manager rating label


Pre-requisites

To export skills data, you'll need:

  • Skills feature enabled on your account

  • The user must have skills on their profile

  • Appropriate permissions to view the user's skills

Required User Roles

Action

Roles Required

Action

Roles Required

Export own skills

All users

Export another user's skills

Owner, Admin, HR, or the user's manager


Quick Start Guide

Exporting Your Own Skills

  1. Click your profile image in the top navigation bar

  2. Click your name to open your profile

  3. Select the Skills tab

  4. Click the Export button (or find it in the actions menu)

  5. The export will be prepared and downloaded as a CSV file

Exporting Another User's Skills

  1. Navigate to People in the sidebar → Individuals

  2. Search for and click on the user's profile

  3. Select the Skills tab

  4. Click the Export button

  5. The CSV file will download with that user's skill data

💡 Tip: Large exports may take a moment to process. You'll receive a notification when the file is ready to download.

Working with Exported Data

Once you have your CSV file:

In Excel or Google Sheets:

  1. Open the CSV file directly, or import it into a new spreadsheet

  2. Use filters to focus on specific skills or rating types

  3. Create charts to visualise rating distributions

  4. Use conditional formatting to highlight gaps (where current rating < target rating)

For Reporting:

  • Compare self-ratings vs manager ratings for alignment insights

  • Identify skills with high targets but low current ratings (development priorities)

  • Track progress by exporting periodically and comparing over time


FAQs

Q: Can I export skills for multiple users at once?
Individual exports are done per user. For bulk reporting across multiple users, use the Skills Reports on dashboards which offer aggregated views.

Q: What if a rating shows a dash (-)?
A dash indicates no rating has been recorded for that rating type (self, target, or manager) for that skill.

Q: Are rating labels included?
Yes. Both the numeric value and the label from your rating framework are included, so you see "3" and "Competent" (or whatever your labels are).

Q: Can I export historical skills data?
Exports show current skill ratings. For historical tracking, the audit trail on individual skills shows rating changes over time.

Q: What format is the date in?
The export doesn't include dates by default. Rating timestamps are available in the platform's audit trail.

Q: Can I import skills data back into Learn Amp?
Skills can be imported via the Skills CSV import feature (for creating/updating skills) or via user imports for assigning skills to users in bulk.


Troubleshooting

Issue

Solution

Issue

Solution

Export button not visible

Ensure you have permission to view the user's skills. Managers can export for their reports; admins can export for anyone.

Export file is empty

The user has no skills on their profile. Skills must be added before they appear in exports.

Ratings showing as dashes

No rating has been recorded for that type. The user needs to self-rate, or their manager needs to provide a rating.

Can't open the CSV file

Try opening it with a different application. Ensure your spreadsheet software is set to UTF-8 encoding for special characters.

Export not completing

Large exports may take time. Check your downloads folder or wait for the notification that the file is ready.