Uploading external scores

Using external scores in my Applied platform

When using other assessments outside of Applied to assess your candidates, you can import those scores into Applied’s platform to help you keep your information and data all in one place, helping you making faster, more informed decisions. Essentially, you will use the “Upload scores” page to create a new data column inside your Applied candidate management table specific to your new assessment type.

How to prepare my scores for upload

If you have one score per candidate for your assessment, create a spreadsheet with 2 columns, with the left side for candidate emails and the right column with the scores (numerical values only). We use emails as the unique candidate IDs in case there are duplicates of names. You may use your preferred spreadsheet platform to create this document (Microsoft Excel, Apple Numbers, Google Sheets, etc.).

If you have more than one score, average your scores together or however you would usually calculate this into one score, and use this in your spreadsheet instead to ensure your document consists of a maximum of 2 columns. If you have multiple assessments or rounds i.e Group activity 1, group activity 2, you may create 2 different assessments which will essentially create a new column in your candidate management table so that you can see both activities side by side. You may create as many columns as you need. 

What happens if I need to update my scores for candidates on a previous assessment?

If your candidates’ scores have changed or been updated by your team, you may simply use the same original spreadsheet. After changing the candidate scores, export as a new .CSV file. This is the new .CSV file you will be uploading. Once you click on the tab “Upload Scores” on the top navigation bar in Manage, you should be able to select from the dropdown the same assessment you previously uploaded. Select your newly exported .CSV file (with the updated scores), and Applied will automatically update those new scores in your Candidate Management table.

What happens if there is an error uploading some of my candidates (i.e. Not found in the system)?

If you receive an error message after upload reporting that we have not found a certain number of candidates, that usually means that there might be some typos in the candidate emails you’ve entered on your original spreadsheet that do not correspond to a current candidate for your role. This means that we uploaded scores for all the candidates we found, and left a blank for those we couldn’t find. To solve this,

1. Check over the spreadsheet you uploaded and make sure the candidates’ emails are spelled correctly, no added spaces before or after the email
2. Next, from the Manage section, click on “Upload Scores” in the top tab. If you already have it open, you may skip this step
3. Select the assessment from the dropdown (you have previously uploaded for this assessment before, so it should be already in your drop-down menu).
4. Confirm the selection by clicking “Continue”.
5. Select the .CSV file you just edited with the corrected emails and click “Upload”
6. Verify that the columns you had in your original file will be imported under the correct labels
7. Check over and make any last-minute changes to scores by clicking into the data cells in the table
8. If all looks good, go ahead and submit the final scores for import. If you have only changed the emails of the candidates previously not found, scores will be added for these candidates and the existing scores for the other candidates will remain the same if all the rest was unchanged in your spreadsheet.
9. You should see a success message
10. To upload more scores, click “Upload more scores” and to view your scores in Candidate Management, click “View my scores”

What if I want to upload more than one score per candidate at once?

If you’d rather upload all scores at once in a single spreadsheet, you may contact [e-mail] and we’ll get your account set up to allow multiple-column uploads. 

Once you have this setup, you will go to the “Upload scores” tab in the top navigation bar and select the assessment type in the drop-down menu.