Return to site

Import a list of Skills through an Excel/CSV file

May 12, 2020 · Skill Management,

Import a list of Skills through an Excel file for a certain category.
  1. To import skills of certain category, visit https://www.onetonline.org/  , search for a category in occupation quick search and select a category.
  2. Under view a report, select details option and download a csv file under skills section.
  3. The headers of the downloaded file are: Importance, Skill and Skill Description. Remove the column Importance and replace it with SkillTypeName. Also, change the header Skill to SkillName and Skill Description to SkillDescription.
  4. To import skills, go to Skills –> Skills.
  5. Click on the “Import Skills” link.
  6. Upload an excel file to import skills.
  7. The supported headers are: SkillTypeName, SkillName, SkillDescription, AssessmentTemplateName where SkillName and AssessmentTemplateName are mandatory fields.
  8. Column names are case-sensitive .