Import candidates from a spreadsheet

If your candidates live in a spreadsheet today, this is the fastest way to get started: up to 10,000 rows in one go.

Before you start: save your sheet as CSV

In Excel choose File → Save As → CSV. In Google Sheets choose File → Download → Comma-separated values (.csv). Make sure the first row has column names like First Name, Last Name, Email and Phone Number.

1. 1
   Go to Candidates and click “CSV Upload”

   It's in the row of buttons at the top right.

   

2. 2
   Download the template (recommended)

   Download Template gives you a sheet with every column Olibr understands. Paste your data into it, then save it as CSV.

   

3. 3
   Drop your file in

   Drag the CSV onto the upload box, or click to browse.

4. 4
   Check the column matching

   Olibr matches your columns to its fields automatically. Fix anything it got wrong, or choose — Skip — for columns you don't need. You must map at least First Name and Email. Click Next.

   

5. 5
   Verify and choose what to do with duplicates

   Olibr shows how many rows it found and any errors. If a candidate with the same email already exists, choose Skip duplicates or Overwrite existing. Then click Upload N Candidates.

   

6. 6
   See the results

   You'll see how many were added, skipped and failed. Your candidates are now in your database, ready to search and add to jobs.

   

Columns Olibr understands

• Basics: First Name, Last Name, Email, Phone Number, Gender
• Work: Position / Job Title, Current Organization, Total Experience (years), Skills (comma-separated), Employment Status, Notice Period (days)
• Location: City, State, Country
• Money: Current Salary, Expected Salary, Currency
• Extra: LinkedIn URL, Summary / About, Notes, plus up to five work experiences, education entries and certifications