Expected Excel Format
Your Excel file should include these columns:
- Function - Job function/category (Column 1)
- Department - Department name (Column 2)
- Job Code (Full Column) or Job Code - Job code identifier (Column 3)
- Title - Job position title (Column 4, REQUIRED)
- Summary - Job description summary (Column 5)
- Responsibilities Topic (Bold Subject in Job Description) - Bold subject header for responsibilities
- Responsibilities (Bulleted Items) - Bulleted items related to the topic
- Responsibilities Topic X - Alternative format for multiple topics (e.g. "Responsibilities Topic 1")
- Responsibilities X - Alternative format for multiple bullet lists (e.g. "Responsibilities 1")
- Qualifications - Qualifications for the position
- Qualifications (Without Topics) - Alternative format for qualifications
- Expectations - Job expectations
IMPORTANT:
- Make sure your Excel has a header row with exact column names (Function, Department, Job Code or Job Code (Full Column), Title, Summary, etc.)
- Only the first row requires a Title value; subsequent rows without a title will be consolidated under the previous title
- Function, Department, and Job Code work like Title - they only need to appear on the first row for each job
- All sheets in the workbook will be processed and combined
- Each sheet must have a header row with a "Title" column
- You can use either "Responsibilities Topic (Bold Subject in Job Description)" or numbered "Responsibilities Topic X" columns
- Multiple rows of content for the same job will be combined into a single job description
- Job data from different sheets with the same title will be merged
- If a job with the same title already exists, it will be completely replaced by the new import data