---
title: How to bulk import jobs from a CSV
description: Bulk import jobs into your architecture from a CSV in SkillsTrust, with column mapping, row review and error handling.
---

[Skip to content](https://knowledge.skillstrust.org/jobs-bulk-import-v1#main-content)

[![](https://knowledge.skillstrust.org/hs-fs/hubfs/SkillsTrust%20Logo%20RGB.png?width=200&height=32&name=SkillsTrust%20Logo%20RGB.png)](https://skillstrust.org/)

Open main navigation

Close main navigation

- [Sign in to SkillsTrust](https://platform.ja.skillstrust.org/)

[Sign in to SkillsTrust](https://platform.ja.skillstrust.org/)

 How can we help?

- There are no suggestions because the search field is empty.

1. [SkillsTrust Knowledge Base](https://knowledge.skillstrust.org/?hsLang=en)
2. [Platform how-to's](https://knowledge.skillstrust.org/platform-how-tos?hsLang=en)

October 13, 2026

# How to bulk import jobs from a CSV

## If you have a lot of jobs to add, or want to update jobs you already have, you can import them from a CSV file rather than creating each one by hand.

Available to any role that can, *except where noted*:

**Add or edit jobs**

### **Solution overview**

Open your architecture, click **Create job**, then **Upload a file** under **Import from CSV**. Download the template, fill it with your jobs, upload it, check how your columns are matched, confirm the rows, and import.

#### Step 1: Upload your file

1. In the **Create job** window, click **Upload a file** under **Import from CSV**. The **Import jobs from CSV** wizard opens.  
   ![import from csv](https://knowledge.skillstrust.org/hs-fs/hubfs/import%20from%20csv.png?width=250&height=181&name=import%20from%20csv.png)
2. Click **Get template** to download a CSV file. Fill it in with your information, adding additional columns as necessary. You get the chance to rename them or turn them into new custom attributes at the review step.
3. Drag and drop your CSV onto **Drop your CSV here**, or click **Choose file**. The file should be CSV, UTF-8.  
   ![choose file](https://knowledge.skillstrust.org/hs-fs/hubfs/choose%20file.png?width=670&height=389&name=choose%20file.png)

**How to fill in the template  
1\. One header row on the first line.** Header names are matched exactly, so keep them on the first row.  
**2. Name attribute columns to match**, for example title, family, department, location, employment\_type.  
**3. Point factor columns use the PointFactor\_ prefix**, for example *PointFactor\_Skills\_Knowledge or PointFactor\_Responsibility\_People*. A bare column such as *Skills\_Knowledge* is picked up too, but flagged for you to confirm.  
**4. Job title decides create or update.** A title that already exists in the architecture is treated as an update.  
**5. Aim for up to 100 rows per file.** This is a recommendation, not a hard limit. Split larger exports into a few files.

#### Step 2: Review columns

The platform reads the whole file and shows how each column was matched, with totals for rows, columns, matched, and need a decision.  
![review columns](https://knowledge.skillstrust.org/hs-fs/hubfs/review%20columns.png?width=670&height=352&name=review%20columns.png)

1. Columns that matched automatically need no action. For every column that needs a decision, use the **Rename to** dropdown to do one of three things:
   
     1. **Map it to an existing attribute.**
     2. **Leave it out.** The column is not imported. This does not cause an error.
     3. **Create a new custom attribute from it.** See [How to create a custom attribute](https://knowledge.skillstrust.org/create-attribute?hsLang=en).  
        ![left out columns](https://knowledge.skillstrust.org/hs-fs/hubfs/left%20out%20columns.png?width=670&height=210&name=left%20out%20columns.png)  
        ![create new custom attribute](https://knowledge.skillstrust.org/hs-fs/hubfs/create%20new%20custom%20attribute.png?width=294&height=312&name=create%20new%20custom%20attribute.png)![resolved columns](https://knowledge.skillstrust.org/hs-fs/hubfs/resolved%20columns.png?width=281&height=350&name=resolved%20columns.png)
2. Point factor columns are detected for you and shown as, for example, Skills \> Knowledge. Correct each one if needed.
3. Anything you leave unresolved is simply left out of the import. When you are happy, click **Continue** at the bottom of the page.  
   ![continue to step 3](https://knowledge.skillstrust.org/hs-fs/hubfs/continue%20to%20step%203.png?width=194&height=62&name=continue%20to%20step%203.png)

#### Step 3: Confirm rows

1. You now see how many rows will be created, updated, or skipped. Use the checkboxes to choose which rows to import, then click **Import \[n\] jobs**.  
   ![confirm rows](https://knowledge.skillstrust.org/hs-fs/hubfs/confirm%20rows.png?width=670&height=388&name=confirm%20rows.png)  
   ![import jobs](https://knowledge.skillstrust.org/hs-fs/hubfs/import%20jobs.png?width=226&height=74&name=import%20jobs.png)
2. The final screen confirms how many jobs were imported, with totals for received, created, updated, and failed.  
   ![Screenshot 2026-10-13 16.33.14](https://knowledge.skillstrust.org/hs-fs/hubfs/Screenshot%202026-10-13%2016.33.14.png?width=670&height=229&name=Screenshot%202026-10-13%2016.33.14.png)
3. If any rows failed, each is listed with a reason. Click **Download failed rows as CSV** to download just the failed rows, fix them, and import them again.

#### **Still need help?**

If this article did not answer your question, email our support team at support@skillstrust.org and we will be happy to help.

Our support hours are Monday to Friday, 9am to 5:30pm GMT, excluding public holidays in the Republic of Ireland.

- [Platform how-to's](https://knowledge.skillstrust.org/platform-how-tos?hsLang=en)
- [Glossary of terms](https://knowledge.skillstrust.org/glossary-of-terms?hsLang=en)
- [Methodology](https://knowledge.skillstrust.org/methodology?hsLang=en)
- [Legacy platform how-to's](https://knowledge.skillstrust.org/legacy-platform-how-tos?hsLang=en)

[![](https://knowledge.skillstrust.org/hs-fs/hubfs/SkillsTrust%20Logo%20RGB.png?width=200&height=32&name=SkillsTrust%20Logo%20RGB.png)](https://skillstrust.org/)

Pay transparency software designed for small HR teams.

[mailto:support@skillstrust.org](mailto:support@skillstrust.org) <https://www.linkedin.com/newsletters/work-worth-7242141560287420416/> <https://skillstrust.org/>

Copyright © 2026