Import a CSV

This guide will walk you through the process of importing a CSV file into the Kardow system. The CSV file should contain job listings with various properties. Below, we will explain each property, the required fields, and provide step-by-step instructions for mapping the columns in the UI.

Written By Simon

Last updated About 2 months ago

Download our pre-built template here :

https://jeorvdjgxlatuthhpoqi.supabase.co/storage/v1/object/public/storage/template_kardow_csv_import.csv

CSV File Structure

Your CSV file should have the following columns:

| Column Name | Description | Required |

|------------------|-------------------------------------------------------------------------------------------------|----------|

| title | The title of the job position. | Yes |

| description | A detailed description of the job responsibilities and requirements. | No |

| company_name | The name of the company offering the job. | Yes |

| location | The location of the job (e.g., Remote, New York). | Yes |

| job_type | The type of job (e.g., full-time, part-time, contract). | No |

| salary_period | The period for the salary (e.g., hourly, daily, weekly, monthly, yearly). | No |

| salary_min | The minimum salary for the job. | No |

| salary_max | The maximum salary for the job. | No |

| salary_currency| The currency for the salary (e.g., USD, EUR). | No |

| is_remote | Indicates if the job is remote (true/false). | No |

| created_at | The date and time when the job was created (optional, defaults to the current time). | No |

| expires_at | The expiration date for the job listing (optional, defaults to a set number of days from now). | No |

Example CSV Content

title,description,company_name,location,job_type,salary_period,salary_min,salary_max,salary_currency,is_remote,created_at,expires_at

"Senior Software Engineer","We are looking for a senior software engineer with 5+ years of experience in React and Node.js. Key Responsibilities: - Build scalable web applications - Mentor junior developers - Collaborate with product team Requirements: - 5+ years experience with React - Strong knowledge of Node.js - Experience with AWS","Acme Corp","Remote","full-time","yearly",80000,120000,"USD",true,"2025-01-01 21:50:45.396+00","2024-12-31"

Step-by-Step Guide to Importing CSV

Step 1: Prepare Your CSV File

1. Create your CSV file using a text editor or spreadsheet software.

2. Ensure that the required columns (title, company_name, and location) are included.

3. Save the file with a .csv extension.

Step 2: Access the Import Feature in Kardow

1. Log in to your Kardow account.

2. Navigate to the Jobs section in the dashboard.

3. Look for the Import Jobs option, usually found in the settings or tools menu.

Step 3: Upload Your CSV File

1. Click on the Upload CSV button.

  • Select your prepared CSV file from your computer.

Step 4: Map the Columns

1. After uploading, you will be prompted to map the columns in your CSV to the fields in Kardow.

2. For each column in your CSV, select the corresponding field in Kardow from the dropdown menu.

  • Example Mapping:

  • title → Job Title

  • description → Job Description

  • company_name → Company Name

  • location → Job Location

  • job_type → Job Type

  • salary_period → Salary Period

  • salary_min → Minimum Salary

  • salary_max → Maximum Salary

  • salary_currency → Salary Currency

  • is_remote → Remote Job

  • created_at → Created At

  • expires_at → Expires At

Step 5: Set Default Expiry Days

  • If you want to set a default expiry period for the jobs being imported, look for the option to specify the number of days before the jobs expire.

  • Enter the desired number of days (e.g., 30 days).

Step 6: Review and Confirm

  • Review the mapping and settings to ensure everything is correct.

  • Click on the Import button to start the import process.

Step 7: Check Import Status

  • After the import is complete, you will receive a notification about the success or failure of the import.

2. Check the Jobs section to see the newly imported job listings.

Conclusion

You have successfully imported job listings into Kardow using a CSV file. Ensure that the required fields are filled out correctly, and feel free to reach out to support if you encounter any issues during the import process.

This guide should help you streamline the job import process and ensure that all necessary data is captured accurately.