Overview
The Import/Export feature allows SkillsDB administrators to load large volumes of data into the platform without manual entry. Instead of adding employees, certifications, or career assignments one record at a time, admins can prepare a spreadsheet and upload it in bulk. SkillsDB supports the following import types, each on its own tab of the Import page:Prerequisites
Before running any import, you need:- Permission level: Administrator role
- File format: CSV or XLSX files. The Skills import also accepts Markdown (
.md) files, and the Training Files import accepts a ZIP archive. - File size: Maximum 15 MB per import file (25 MB for Training History, 1 GB for the Training Files ZIP)
- Access: Navigate to Company > Import
Importing People (Employees)
Use the People import to add new employees, update existing employee records, or assign managers in bulk. SkillsDB identifies each employee by their email address — new email addresses create new records, and existing email addresses update existing records.Prepare your file
- Navigate to Company > Import.
- Select the People tab.
- Select Download template to get the
SkillsDB_People_Import_Template.csvfile. - Open the template and populate your data using the columns below.
- Save your completed file as CSV or XLSX.
Upload and run the import
- Navigate to Company > Import and select the People tab.
- Drag and drop your file into the upload zone, or select Add file to browse your computer.
- Select Start Import to begin processing.
- SkillsDB processes the file in three stages: Validating → Processing → Uploading.
- When processing completes, the results panel displays a count of successes and a breakdown of any failures by error category.
Understand people import results
If records fail, the results panel groups errors into categories so you know exactly what to fix:Importing Employee Certifications
Use the Employee Certifications import to bulk-assign certification records to employees. All certifications imported this way are automatically set to Approved status and become each employee’s active certification record.Find your SkillsDB Certification IDs
The certifications import requires a SkillsDB Certification ID for each row. To find these IDs:- Navigate to Company > Import.
- Select the Employee Certifications tab.
- Select Export all certifications list.
- Open the downloaded
SkillsDB_Certifications_List.csvto view all available certification IDs and their names. - Copy the relevant IDs into your import file.
Prepare your file
- On the Employee Certifications tab, select Download template to get the
Employee_Certifications_Import_Template.csvfile. - Complete the file using the following columns:
- Save your completed file as CSV or XLSX.
Upload and run the import
- Navigate to Company > Import and select the Employee Certifications tab.
- Drag and drop your file into the upload zone, or select Add file to browse.
- Select Start Import to begin processing.
- Review the results summary when processing completes.
Understand certification import behavior
When you import a certification for an employee who already has an active record of the same certification type, SkillsDB marks the previous record as inactive and sets the imported record as the new active certification. The full certification history is preserved and remains accessible.Understand certification import results
Importing Skills
Use the Skills import to bulk-load skills into your Skills library, or to update the descriptions of skills that already exist.- Navigate to Company > Import and select the Skills tab.
- Select Download template to get the template, and complete it.
- Add your file. Optionally, turn on Update descriptions only to update existing skills’ descriptions instead of creating skills.
- Select Dry Run to check the file without making changes. The results read “Dry Run Results — no changes were made”.
- Select Start Import.
Importing skills from a Markdown file
The Skills import also accepts Markdown (.md) files. Each skill starts with a ## Skill Name heading, and everything below it until the next heading becomes the skill’s description, with formatting such as numbered lists, bullets, and bold text preserved. A skill can optionally start with a # id line holding the skill’s ID in your library. Normal imports match skills by name and ignore the ID line. With Update descriptions only enabled, every skill must have an ID line, and only the matched skill’s description is updated.
Importing Training Resources
Use the Training import to bulk-load learning resources into your Training library.- Navigate to Company > Import and select the Training tab.
- Download the template, complete it, and save.
- Add your file and select Start Import. Resources become available in the Training library and can be assigned to skills, careers, and learning plans.
Importing Library Certifications
Use the Library Certifications import to bulk-load certification definitions into your Certifications library. This import is distinct from the Employee Certifications import, which records which people hold which certification.- Navigate to Company > Import and select the Library Certifications tab.
- Download the template, complete it, and save.
- Add your file and select Start Import. Certification definitions become available to assign to employees, either individually or through the Employee Certifications import.
Importing People Flags
Use the People Flags import to add administrator-defined people flags (for example,High potential, Available, Successor – Director) to employees, or remove them, in bulk.
- Navigate to Company > Import and select the People Flags tab.
- Select Export all people flags list to download the people flag IDs for your company.
- Download the template, complete one row per employee and flag, and save.
- Add your file and select Start Import.
Importing Careers (Library)
Use the Careers import to add careers to your Careers library in batch. The file has one required column,CareerName (for example, Software Engineer).
- Navigate to Company > Import and select the Careers tab.
- Select Download template, complete the file, and save.
- Add your file and select Start Import.
Importing Career Structure
Use the Career Structure import to create or update the structure of one career in bulk — its sections, skills, level applicability, skill labels, training requirements, and benchmarks. The import is a four-step wizard: Select Career, Review Structure, Download Template, and Upload & Import.- Navigate to Company > Import and select the Career Structure tab.
- Select Career: search for and select the career whose structure you want to update.
- Review Structure: inspect the career’s existing skills, sections, levels, labels, and grading scale before you download the template.
- Download Template: choose a template type, then select Download Template. The template is preformatted for the selected career.
- Upload & Import: upload your completed CSV and select Start Import.
Career_ID, Section_Name_Or_ID (a numeric ID matches an existing section; a name creates a new one), Section_Description, SkillsDB_Skill_ID (leave blank to create a new skill), Skill_Name, Skill_Description, one Level_<level name> column per level (yes or no), and Skill_Labels (comma-separated label IDs). Training Dates templates add Training_Required, Training_Attachment_Required, and Training_Comment_Required. Proficiency templates add one Benchmark_<level name> column per level, or a single Benchmark column if the career has no levels; benchmark values must match the grading scale. Each row needs either SkillsDB_Skill_ID or Skill_Name.
Importing Career Assignments
Use the Career Assignment import to assign existing employees to careers and levels in bulk, or to change the level or initiation date of existing assignments. The import is a two-step wizard: Prepare and Upload and import.Prepare your file
- Navigate to Company > Import and select the Career Assignment tab.
- Select Export career list to download
Career_Assignment_Reference_List.csv. It lists every career in your company with itsCareer_IDand number of levels. - Select Download template to get
Career_Assignment_Import_Template.csv. - Complete one row per person and career:
Assignment_Date column is still accepted and is treated as Initiation_Date. The same User_Email and Career_ID pair may appear only once. To assign several people to the same career, add one row per person.
Upload and run the import
- Upload your CSV or XLSX file (maximum 15 MB and 5,000 rows).
- Optionally, turn on Dry run (preview only) to validate the file and see what the import would do without writing any changes. The preview counts new assignments that would be created, existing assignments whose level would change, existing assignments whose initiation date would be set or overwritten, and rows that are unchanged.
- Run the import.
Career_ID, a bad level, a duplicate, or an invalid date — the entire import is rejected with no changes. Existing assignments are updated in place, and only their level and initiation date can change. Assignments that are not in the file are never removed.
Importing Training History
Use the Training History import to load employees’ past training records — for example, when you move to SkillsDB from another system. The import is a three-step wizard: Reference & Template, Upload & Import, and Results.- Navigate to Company > Import and select the Training History tab.
- Select a career, then select Export Career Reference to download the skills for that career, and Download Import Template to get the template.
- Complete one row per person and skill:
- Select Continue to Upload, upload your file, and select Validate & Import.
- Review the preview and select Confirm Import.
Importing Training Files
Use the Training Files import to attach evidence files to training records you imported with Training History. Upload a ZIP archive whose folder structure matches the attachment paths given for the training records. SkillsDB matches each file to its training record and attaches it as evidence.- Navigate to Company > Import and select the Training Files tab.
- Drag and drop a ZIP archive (up to 1 GB), or click to browse.
- Select Confirm import.
Importing Skill Flags
Use the Skill Flags import to apply skill flags — such as Expert or Mentor — to people, or remove them, across a career’s skills, sections, career, and skill groups in one file.- Navigate to Company > Import and select the Skill Flags tab.
- Select the career to build the template around.
- Select Download Template. The template is a matrix CSV pre-filled with the Skill, Section, Career, and Skill Group flag rows that apply to the career. You can also download a blank template and a reference list of record IDs.
- Add one column per person, with the person’s email address as the column header. In each cell, enter
yes,true, or1to apply the flag;no,false, or0to remove it; or leave it blank for no change. Matching is case-insensitive. - Upload the completed CSV and select Start Import.
Reviewing Import History
The Activity Log tab in the Import section provides a complete audit trail of every import run across all import types.What the Activity Log shows
Each row in the Activity Log includes:- Type — The import type, such as People, Career Assignment, or Training History
- Date & Time — When the import ran
- User — The admin who ran the import
- File Name — The original uploaded filename
- Status — Imported, Partially Failed, Failed, or Processing
- Rows Processed, Rows Succeeded, and Rows Failed — A count summary for that run
- Error Summary — A short description of any errors
View error details
If an import has detailed errors, select View details in the Details column to open the error detail modal. The modal lists the specific records and error descriptions for that import run, so you can identify and fix only the affected data.Download original import files
Select the file name on any Activity Log row to download the original file that was uploaded for that run. If the file is no longer stored, the row shows “File no longer available”. Use the downloaded file as a starting point to correct errors and reimport.Exporting Data
Most data-heavy pages in SkillsDB — people tables, skills matrix, training matrix, learning plans, certifications, flag matrices, the Activity Log — include an export action. Exports reflect the current view, including any active filters, sorts, and column selections, so you can take the exact slice you are looking at into a spreadsheet.Opening the export menu
The export action is in the top-right action area of the page. For most pages it appears as an Export button or as an export option in the Actions menu; for pages with multiple export options, the menu lists the available formats. You can also press ⌘K (Mac) or Ctrl+K (Windows) and search for the export. Supported export formats vary by page. Most pages offer at least an Excel (.xlsx) export. Select pages also offer a PDF export with a branded layout suitable for sharing or printing.
Export file naming
Exported files use a consistent pattern:{Report_Name}_{date}.xlsx — for example, Training_Matrix_2026-04-21.xlsx. This makes it easy to keep a dated record of repeated exports without overwriting older files.
Export behavior
- Filters and sorts — the exported file matches the filtered, sorted view on screen. If you need a complete unfiltered dataset, clear all filters before exporting.
- Columns — exported columns match the columns visible in the table. Use the column chooser to show additional columns before exporting. For some reports (such as All Activity), hidden columns such as Employee ID and Manager Email are included in the export even when hidden on screen — this is called out where it applies.
- PDF layout — when PDF is offered, the PDF preserves the page’s branding and layout, and is designed for sharing or printing rather than further data analysis. For data work, use Excel.
Common Questions
What happens if I reimport an employee who already exists in SkillsDB?
What happens if I reimport an employee who already exists in SkillsDB?
Can the People import create new job titles, departments, or levels automatically?
Can the People import create new job titles, departments, or levels automatically?
Can I import certifications for employees who have not been added to SkillsDB yet?
Can I import certifications for employees who have not been added to SkillsDB yet?
EmployeeEmailAddress to match an existing employee record. Import your employees first using the People import, then run the certifications import.What date format does the certifications import require?
What date format does the certifications import require?
YYYY/MM/DD format. For example, June 15, 2025 should be entered as 2025/06/15. Dates in any other format fail validation and appear in the Invalid dates error category in the results panel.Can I grant or revoke admin access through the People import?
Can I grant or revoke admin access through the People import?
IsAdmin column to Y to grant administrator access, or N to remove it. If you leave IsAdmin blank for an existing employee, their current admin status remains unchanged. Blank values for new employees default to non-admin.Is there a limit on how many rows I can import at once?
Is there a limit on how many rows I can import at once?
Can I check a file before anything is imported?
Can I check a file before anything is imported?
Can I download the file from a past import to use as a starting point?
Can I download the file from a past import to use as a starting point?