Skip to main content

Update your people data

How to update your people data ahead of your next survey

Lauren Rolfe avatar
Written by Lauren Rolfe
Updated this week

Since your previous survey, it is inevitable you will have some leavers who you no longer need to survey, new staff you who have joined and some employees who may have moved teams or managers etc.

First, download your current data into a spreadsheet

  1. Go back to People and click Export > Download Export.

  2. This will download your data into a spreadsheet for editing.

Now we'll make the rest of the updates in your spreadsheet and re-upload

  1. If you haven't already, you can add in 'Org employee ID (optional) to your dataset. Map the IDs against employees in your HRIS into this spreadsheet to make updating data easier long-term. Don't remove the 'WeThrive record ID' column. You will need these to map your own organisation IDs onto the right records the first time you add your own org IDs.

  2. Update any email addresses that have changed.

  3. Update your active users

    1. Mark anyone who has left as Active - 'No'.

    2. When you upload the new sheet, this will deactivate these people. You may already have some inactive people in your spreadsheet from previous updates.

  4. Check the Role column and switch anyone's role that needs it (e.g. make them a 'Manager Bubble' or an 'Employee Bubble' to give them a login to WeThrive).

    1. When you upload this sheet, anyone who has been updated will receive an activation login.

      .

  5. Fill in your Reports To column (if applicable) - copy and paste the email address of the Manager(s) you want to be able to access that employees results. The manager must be listed as a 'Manager Bubble' in your dataset to be assigned to employees in this column.

  6. Update any of the Filter columns (Team, Location, Department, Unit, Manager) for existing employees. Add up to 12 ways of segmenting your data.

  7. Add new starters details to the bottom of your spreadsheet. You can also add an 'Org employee ID' and add these IDs in WeThrive to match the employee IDs given to employees in your HRIS. This may make updating easier long term.

  8. Once your updates are made, save the file as a CSV file.

  9. Return to your People table in WeThrive and click Import. Select your file and Begin import.

  1. If there are any errors, the system will tell you and the sheet won't upload.

  2. Bear in mind that as soon as you upload the spreadsheet, anyone who has been switched from an 'employee' to an 'employee bubble' or. 'manager bubble' will receive their activation email.

Did this answer your question?