Articles on: Job Board Management

How to Import Jobs From a CSV File?

Quick answer: To import jobs, go to Jobs > Actions > Import from CSV, upload your CSV file, match each column to a job field, and click Start import. Every job needs a title, an employer and an ID (the External ID, for example the id the job has in your own system). JBoard uses that ID to recognise each job the next time you import, so importing again updates your jobs instead of adding duplicates.



Watch how to import your jobs from a CSV file:



How Job Import Works


A CSV import turns a spreadsheet of jobs, or an export from another system, into jobs on your job board.


  • Every row becomes one job. The first row holds the column names.
  • Columns are matched to your job fields. Columns with the same name as a field are matched for you. You pick the rest yourself.
  • Every job needs an ID. Jobs are matched by JBoard ID, then External ID, so a later import updates the same jobs.
  • Employers are matched by company name. A company that isn't on your job board yet is created for you. Job types, categories and tags that don't exist yet are created too.
  • The import runs in the background. You can leave the page once it has started.


Before You Start: Prepare Your CSV File


Your file needs:


  1. A header row with the column names in the first row.
  2. One job per row in every row after that.
  3. A job title, an employer, a location and a description for every job.
  4. An ID for every job. Use the id the job has in the system you're moving from. If your jobs don't have one, add a column and give each job a unique value (for example JOB-001, JOB-002), and keep it for future imports.


Tip: If you want your employers to have logos and descriptions, import your employers first (see How to Import Employers From a CSV File?). Employers created by the job import only get a name.


What to Put in Each Field


Field

What to put in the CSV

Example

External ID (required)

A unique id for each job

AB-101

Job Title (required)

The job title

Staff Accountant

Employer (required)

The company name (or the JBoard employer ID / your own employer ID, see Step 3)

Airbnb

Location (required)

A city and region; JBoard looks the location up

San Francisco, CA

Job Description (required)

Plain text or HTML

<p>We're hiring…</p>

Job Type

A job type name; new ones are created

Full-time

Category

A category name; new ones are created

Finance

Tags

Several tags, separated by commas; new ones are created

Entry-level, Flexible hours

This is a remote job

Yes or No

No

Min compensation / Max compensation

Numbers only

62000

Compensation time frame

annually, monthly, weekly, daily or hourly

annually

Compensation currency

A currency enabled on your job board

USD

Apply by

Where candidates apply: by_link, by_email or by_form

by_email

Apply to

The link or email address; needed for by_link and by_email.

jobs@example.com

Confirmation Status

confirmed, need_confirmation or rejected (new jobs are Confirmed by default)

confirmed

Posted at

The posting date (empty = today)

2026-11-10

Job expires in days

Days from the posted date (empty = 30 days)

30

Featured / Featured expires in days

Yes or No, plus the number of days (needed together)

Yes / 14

Pinned to top / Pinned to top expires in days

Yes or No, plus the number of days (needed together)

Yes / 7


Custom job fields work the same way: add a column for each one.


Step 1: Open the CSV Import


Go to Dashboard > Jobs, open the Actions menu and click Import from CSV.



Step 2: Upload Your File


The upload page lists what your file needs, including a column with each job's ID.




Drag and drop your CSV file onto the upload area, or click select a file. JBoard shows how many jobs it found.



Step 3: Match Your Columns to Job Fields


Each job field is listed with the column it takes its value from and a few sample values from your file. Columns with the same name as a field are already matched.



For External ID, pick the column that holds each job's ID. Here, it's Job ID.



For Employer, pick the column with the company name. Here, it's Company.



Employers are matched by company name, and capitalisation doesn't matter:


  • If an employer with the same name is already on your job board, the jobs are added to that employer, and no new employer is created.
  • If it isn't, a new employer is created with that name.


If your file holds employer IDs instead of names, change Match by company name to Match by JBoard employer ID or Match by your own employer ID.



Job Type, Category and Tags are matched by name too. Any job type, category or tag your job board doesn't have yet is created for you. Since a job can have several tags, put them in one cell separated by commas (for example, Entry-level, Flexible hours).



Apply by is where candidates go to apply for the job:


  • by_link: candidates are sent to a link, for example the job on your company's careers page. Put the link in Apply to.
  • by_email: applications are sent to an email address. Put the address in Apply to.
  • by_form: candidates apply with the application form on your job board, without leaving it. Apply to isn't needed.



Apply to holds the link or email address for each job.


Important: If you're moving from another job board or system, don't put your current job links in Apply to. Those links will probably stop working once you've finished moving, and candidates would land on a broken page. Use the employer's own careers page, an email address, or by_form instead.



You can take Apply by from a column in your file, or give every job the same value: open the field, choose Set a value yourself, and pick Apply by link, Apply by email or Apply directly by form. That value is used for every new job in the file; jobs that already exist keep their own.



Other fields need specific values too. The hint under each field shows what to use.


New jobs are Confirmed by default, so they go live right away. To change that, pick another value under Set a value yourself, or match a column.



When everything looks right, click Continue.


Step 4: Review and Start the Import


The review page sums up what's about to happen. Nothing is imported until you click Start import.


Under Jobs that already exist, choose what happens to jobs whose ID is already on your job board:


  • Update them from this file: only the columns you matched are overwritten.
  • Skip them, add new jobs only: existing jobs stay exactly as they are.



The review page also shows the Separated by character for tags (a comma by default). Click Start import.



Step 5: Check the Results


When the import is done, it appears under Completed imports with the number of jobs Added, Updated, Skipped and Failed, plus any Warnings. Click View details for a summary.



Your jobs are now listed under Jobs, each with its employer.



And they're live on your job board.



If some rows failed, see our guide How to Fix Failed Imports?


Frequently Asked Questions


What if my jobs don't have IDs?


Add a column and give each job a unique value, such as JOB-001. Keep the same IDs in later files, so those imports update your jobs instead of adding new ones.


Will importing the same file again create duplicates?


No. Jobs are matched by their ID. Choose Update them from this file to refresh them, or Skip them to leave them as they are.


Why did a row fail with "The selected Compensation time frame is invalid"?


Use one of: annually, monthly, weekly, daily or hourly.



A featured job also needs Featured expires in days: the number of days it stays featured, counted from its posted date. The same goes for Pinned to top.


Can I import jobs for employers that aren't on my job board yet?


Yes. They're created by name during the import. To give them logos and descriptions, import your employers first, or edit them afterwards.


Will a new employer be created if the company is already on my job board?


No. If an employer with the same name is already on your job board, the jobs are added to that employer.

Updated on: 17/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!