To export and / or import competencies and competency frameworks, simply open your competency framework (under 'Company' > 'Competencies') in Leapsome and click on the 'Actions' > 'Import / Export' button.
Exporting your Competency Framework will generate an Excel file containing all your competencies and competency descriptions. If you have set up additional team-specific competencies, levels, and translations in Leapsome, the Excel file will include additional fields and columns. To import new competencies and / or bulk edit existing competencies, please first download your competency framework as an Excel file, make the relevant changes, and then upload it again.
Your changes in the Excel file may also include changing a company-wide competency to a team-specific competency or changing the team for the team-specific competencies, or enforcing competencies for a level. In the column 'Relevant for "level" (yes/no)':
- Type 'Yes' - this will enable the toggle and make the competency relevant for this level
- Type 'No' - this will disable the toggle
- Leave the field empty - uploading a file with the field left empty will enable the toggle in the system
After uploading the Excel file, any updated competencies or additional information added (competencies, teams, levels, categories), will be previewed in a high-level overview before the changes are saved. Therefore, you can see what information was added or changed to ensure the correct edits were made.
Please note: In the Excel export, Leapsome automatically attaches a unique ID to all competencies that have been set up in Leapsome before. If you'd like to edit competencies in the exported file, make sure you keep the unique ID per skill, as otherwise, Leapsome will treat the competency as a new competency when importing the Excel file again.