Quickin allows you to transfer your candidate database from other platforms to your account. However, to import those informations, the data must be in a CSV file, with the required columns and in the appropriate format, as described below:
Basic Data
Column Name | Description | Formatting |
name | Name | 100 characters |
headline | Job Title | 100 characters |
Valid e-mail address | ||
phones | If the candidate has more than one phone number, separate them with ";" | - |
summary | Summary of qualifications | 3.200 characters |
disability | Type of disability. Options in English: vision, hearing, intellectual, and physical | - |
disability_comment | Comment on the disability | - |
gender | Fill with options in English: male, female, other, prefer_not_to_say. | - |
country | Country code (e.g., BR, AR, US) | - |
region | State | 100 characters |
city | City | 100 characters |
neighborhood | Neighbourhood | 100 characters |
address | Address | 100 characters |
zipcode | Postal code | 100 characters |
salary | Salary expectation | Numbers only |
source | Source | URL only, up to 100 characters |
tags | If the candidate has more than one tag, separate them with ";" | - |
birth_date | Date of birth in American format (yyyy-mm-dd). Example: 1998-05-19 | Numbers only |
Professional Experience
Column Name | Description | Formatting |
experiences.0.company | Company name | 100 characters |
experiences.0.position | Position | 100 characters |
experiences.0.attributes | Responsabilities | 3.200 characters |
experiences.0.start_date | Start date (American format: yyyy-mm-dd) | Numbers only |
experiences.0.end_date | End date (American format: yyyy-mm-dd) | Numbers only |
experiences.0.current_job | Fill with 0 (not working) or 1 (currently working) | - |
Academic Background
Column Name | Description | Formatting |
educations.0.education_degree | Degree (in English): master_degree, bachelor_degree, high_school, certification, vocational, associate_degree, postdoctorate, graduate_degree, doctorate | - |
educations.0.course | Course name | 100 characters |
educations.0.institution | Instituition Name | 100 characters |
educations.0.start_date | Start date (American format: yyyy-mm-dd) | Numbers only |
educations.0.end_date | End date (American format: yyyy-mm-dd) | Numbers only |
educations.0.incomplete | Status: 0 (completed) or 1 (incomplete/in progress) | - |
Languages
Column Name | Description | Formatting |
languages.0.language | Language code in English: de, pt, ja, fr, en, es, it, zh | - |
languages.0.level | Language level: 1 (Basic), 2 (Intermediate), 3 (Advanced), 4 (Fluent) | - |
Social Media
Column Name | Description | Formatting |
pages.0 | URL of the candidate's social media profile (Instagram, Facebook, etc.) | 100 characters |
Additional Fields
Column Name | Description | Formatting |
custom_fields.nome_do_campo1 | - | Short text: 60 characters or Long text: 2,000 characters |
custom_fields.nome_do_campo2 | - | Short text: 60 characters or Long text: 2,000 characters |
custom_fields.nome_do_campo3 | - | Short text: 60 characters or Long text: 2,000 characters |
Additional Notes:
In the fields regarding education, professional experience, language and social media, note that there is a number corresponding to the count of the information.
For example, if a candidate has two degrees and two social media profiles, such as a technical course in Information Technology and a bachelor's degree in Computer Science, the information in the spreadsheet should be filled out as follows:
educations.0.course: Information Technology
educations.0.institution: vocational
educations.0.start_date: 2016-02-03
educations.0.end_date: 2017-06-01
educations.0.incomplete: 0
educations.1course: Computer Science
educations.1.institution: bachelor_degree
educations.1.start_date: 2023-02-08
educations.1.end_date: 2027-12-1
educations.1.incomplete: 1
Additionally, if your database contains fields not present in the Quickin form, you can register them as additional fields, as shown in the table above. For example, if the database contains CPF and the job title the candidate applied for, this information can be added as custom fields, as follows:
custom_fields.cpf : 111.111.111-11
custom_fields.nome_da_vaga: Systems Analyst
Once you have finished processing the candidate data, please contact our support team via the chat to send the file and complete the import. 😊
In order to facilitate, here’s a sample file. 😉