As a part of your Diversity, Equality and Inclusion audit, Fair HQ will anonymously survey your employees to understand their feelings on key areas within the business.
To begin, we'll need you to upload a list of your employees to the Fair HQ platform in CSV format. You can click here to jump straight to our video guide.
1. Download the Template 💻
Microsoft Excel
If you use Microsoft Excel, simply download the CSV template from the "Employee Survey" tab in Fair HQ.
Google Sheets
If you use Google Sheets, simply click here to open and make a copy, then download as CSV.
2. Populate your Data ✍️
Open the template in your software of choice
Copy and paste your data from your HR system into the relevant rows/columns
Please make sure to remove any example data
3. Download as CSV & Upload to Fair HQ 📊
Download your file as a CSV file
Navigate to the Employee Survey tab within Fair HQ
Click the "Ready to Upload" button, and choose the CSV file you recently downloaded
Understanding the CSV File 🔍
Required Fields
Field Name | Description | Notes |
firstName | First name of employee |
|
lastName | Last name of employee |
|
Email address of employee where we should send the survey to |
| |
level | Level of employee within the business | Choose from these options only: Employee, Manager or Leadership |
Optional Fields (leave these cells blank if you do not wish to disclose)
Field Name | Description | Notes | Insights Available |
role | Job title of employee | Free text or leave blank |
|
department | Department of employee | Free text or leave blank | Explore the inclusion and equality experience of different departments within your business where 5 or more participants complete the survey. Consider grouping smaller departments into larger ones if needed. |
employmentType | Employment type of employee | Choose from these options only: |
|
setup | Describe how the employee primarily works | Choose from these options only: |
|
workingHours | Record how many hours the employee typically works per week | Full numbers only, eg 40 or leave blank |
|
salaryYear | State the year of the salary you are recording | Full numbers only, no extra punctuation eg 2020 or leave blank |
|
salaryAmount | State the salary for the employee | Full numbers only, no extra punctuation eg 30000 or leave blank |
|
salaryBonus | Record any bonuses this employee received within the year | Full numbers only, no extra punctuation eg 1500 or leave blank |
|
currency | State the currency of the salary above | Only use 3 letter currency codes (ISO 4217) or leave blank |
|
city | State the city the employee is based in | Free text or leave blank |
|
country | State the country the employee is based in | Use only 3 letter country codes (ISO 3166 Alpha 3) or leave blank | Explore the inclusion and equality experience of employees based in different countries where 5 or more participants complete the survey. |
* Note that while insights are not available for all data collected, we aim to add more insights over time. If you already have this information in the platform, those insights will automatically unlock. Or you can opt to retroactively update the information at the time.
Video Walkthrough with Matthew