Upload questions in bulk
Article 4 of 5 in a series on creating your own tests.
This is the fourth article in a series of five, to help you create your own tests using the TestGorilla platform. The full series is available on the right. Account owners, admins, and recruiters on any plan can create and save their own tests. To add a custom test to an assessment and invite candidates to take it, you need a Plus plan.
Tip: When creating your own test, we recommend outlining it before putting it into the TestGorilla platform. This will help ensure that everything is organized and laid out exactly as you want.
Approx. reading time 7 minutes
In this article
- See it in action
- Create a test
- Adding your test to an assessment
- Editing your test
- Common questions
- Next steps
See it in action
Click through this interactive demo to see the three steps, from a blank test to a published one. The rest of this article explains each step in detail.
Create a test
You build your test in three steps: Test details, Questions and Settings. The steps are shown at the top of the page, so you can move back and forth between them at any time.
|
|
Go to Library and open the Skills tests tab. |
|
|
Click Create new. |
Your work is saved as you go. The page header shows Draft saved while the test is a draft, so you can leave and come back later. Your draft is in the Library: open the Skills tests tab and choose My company in the Show tests from filter.
Not on a Plus plan? You can still build, save and publish your test. A banner in each step reminds you that using it in an assessment needs an upgrade, with an Upgrade button. Once you upgrade, the banner disappears and your test is ready to use.
Step 1: Test details
Fill in the basics of your test. Fields marked * are required.
|
|
Test name* (up to 60 characters). This is how you and your coworkers find the test, and candidates see it before the test starts. Example: Accounting (Hiring Co.) |
|
|
Language*. The language your test is written in. Your test only shows up in assessments set to the same language. If your language isn't in the list, pick the language of the rest of your assessment. |
|
|
Test type*. Choose one. You can't change the test type once the test is created, so choose carefully.
|
|
|
Test focus* (standard tests only). Choose up to two categories that describe what the test measures, such as Role-specific skills. Coding tests are always set to Programming skills. |
|
|
Instructions for candidates (optional). Candidates see this before the test starts. Use it to explain anything specific to your test, such as the materials they may need. |
|
|
Additional details (optional). For you and your team only, candidates don't see these:
|
Click Continue to go to the next step.
Step 2: Questions
Your questions are split into two groups:
- Practice questions: unscored questions candidates use to get familiar with the format before the test starts. They should look like your real questions without repeating any of them. You can add up to 4 practice questions (1 for coding tests). Practice questions are optional.
- Test questions: the questions candidates are scored on.
Click Create new in either group to write a question. You can also add many questions at once with Upload questions (see below).
To find questions in a large test, use Search questions... and the Skill area and Type filters. Each question row lets you:
- Edit question: reopen the question in the editor.
- Archive question: take it out of the test without deleting it. Archived questions are listed under Archived questions, where you can restore them.
- Remove question: delete it from the test.
Tip: Organize your test questions into skill areas: the key skills the role needs. We recommend 3 or 4 skill areas. Skill areas don't need the same number of questions. See Developing an effective screening test for how to define them.
Writing a question
When you click Create new, the question editor opens on the right side of the page.
|
|
Question: write your question, using the toolbar to format it. Include everything a candidate needs to answer it. |
|
|
Answer type: choose one. You can use a different type for each question.
|
|
|
Skill area (test questions only): select a skill area, or type a name to create a new one. |
|
|
Answers: add between 2 and 10 answer options for multiple choice questions. Shuffle answers is on by default; turn it off if your options have a logical order. |
|
|
Click Create. |
For help choosing and writing each type, see Choosing a question type.
Coding tests: candidates complete only one question in a coding test, even if you add several. The editor has its own steps for initial code, test cases and verification code. See Creating a custom coding test.
Upload questions in bulk
Instead of writing questions one at a time, you can add up to 200 test questions at once from an Excel file. It's the quickest way to bring in a question bank you already use in another tool, or a test you've drafted in a spreadsheet. One file can mix all four question types.
|
|
In Step 2: Questions, click Upload questions. |
|
|
Click Download template. You get an Excel file with the column names in row 1 and no questions yet. |
|
|
Fill in one question per row, starting in row 2. The tables below explain each column and how to score each question type. |
|
|
Save the file as .xlsx (up to 10 MB). Back in Upload questions, drag the file into the upload area or click it to choose the file. |
|
|
Check the summary, for example 20 questions ready to upload across 4 skill areas., then click Upload 20 questions. Your questions appear under Test questions. |
The template's columns
| Column | What to write |
|---|---|
| Question | The question as candidates will see it, up to 5,000 characters. Required. |
| Skill area | The skill the question measures. Required. Write the name the same way on every question that belongs to it. If your test already has a skill area with that name, the question joins it (capital letters don't matter). If not, a new skill area is created. A test can have up to 50 skill areas. |
| Type | Multiple choice, Multiple response, True or false or Short text. If you leave it empty, the question is uploaded as Multiple choice. |
| Option A to Option J | The answer options, up to 10 per question and up to 1,000 characters each. Fill them from left to right (Option A, then Option B, and so on) and leave the ones you don't need empty. |
| Score A to Score J | The score for the option just to its left: Score A is for Option A, Score B for Option B. Use whole numbers from 0 to 5. The rules for each type are below. |
How to fill in each question type
| Write in Type | What candidates do | How to fill in the options and scores |
|---|---|---|
| Multiple choice | Pick one answer. | 2 to 10 options. Score the correct answer 5 and the wrong answers 0. For partial credit, give answers that are partly right a score from 1 to 4. At least one option must score 5. |
| Multiple response | Pick every answer that applies. | 2 to 10 options. Score every correct answer 5 and every wrong answer 0. Partial credit isn't available. At least one option must score 5. |
| True or false | Decide whether a statement is true or false. | Exactly two options, True and False. Score the right one 5 and the other one 0. |
| Short text | Type their own answer. | 1 to 10 accepted answers, one per Option column. Leave the Score columns empty: every answer you list counts as correct. Candidates' answers aren't case-sensitive, but add every other variation you accept (for example Lakers and LA Lakers). |
Note: The question editor calls the first two types Multiple choice (Single select) and Multiple choice (Multi select). In the Type column, write Multiple choice and Multiple response instead.
Example: a file that mixes every type
Here's what a filled-in file looks like. The grey numbers on the left are Excel's row numbers. The full template continues up to Option J and Score J; just leave the columns you don't need empty.
| 1 | Question | Skill area | Type | Option A | Score A | Option B | Score B | Option C | Score C | Option D | Score D |
| 2 | Which player was selected first overall in the 2003 NBA Draft? | NBA history | Multiple choice | Carmelo Anthony | 0 | LeBron James | 5 | Darko Miličić | 0 | Dwyane Wade | 0 |
| 3 | How many personal fouls does it take for a player to foul out of an NBA game? | Rules and gameplay | Multiple choice | 6 | 5 | 4 | 0 | 7 | 0 | 5 | 2 |
| 4 | Which of these players were on the 1992 US Olympic 'Dream Team'? Select all that apply. | NBA history | Multiple response | Magic Johnson | 5 | Isiah Thomas | 0 | Larry Bird | 5 | Shaquille O'Neal | 0 |
| 5 | Michael Jordan won all six of his NBA championships with the Chicago Bulls. | NBA history | True or false | True | 5 | False | 0 | ||||
| 6 | A regulation NBA game is made up of four 10-minute quarters. | Rules and gameplay | True or false | True | 0 | False | 5 | ||||
| 7 | Which team did Kobe Bryant play his entire 20-season NBA career for? | NBA history | Short text | Los Angeles Lakers | Lakers | LA Lakers |
- Row 2 is a standard multiple choice question: one right answer scored 5, the rest 0.
- Row 3 gives partial credit: the right answer (6) scores 5, and a close answer (5) scores 2.
- Row 4 has two correct answers, so both score 5. Candidates need to pick both.
- Rows 5 and 6 are true or false. In row 6 the statement is false, so False scores 5.
- Row 7 is short text: three accepted answers and no scores.
Tips
- Always start from the template. Don't rename, move or add columns, and keep your questions on the first sheet: only the first sheet is read, and a column the upload doesn't recognize stops the file.
- Type is forgiving about how you write it. Capital letters, spaces and punctuation are ignored, so true/false or MULTIPLE-CHOICE also work. Anything else is flagged.
- Add formatting, images and code afterwards. The file holds plain text. Once the questions are in, click Edit question on any question to format it or add media.
- Drafting questions with AI? Ask your AI assistant to fill in the template's columns directly, using the rules in the tables above. Review every question, answer and score before you upload.
- Answers are shuffled. Uploaded multiple choice and multiple response questions have Shuffle answers on, as in the editor. Turn it off on questions whose options have a logical order, such as All of the above.
- Practice questions aren't part of the upload. Add them with Create new in the Practice questions group.
If your file has problems
We check the whole file before adding anything. If any row has a problem, no questions from the file are added, including the rows that were fine. Instead, you see a list of what to fix, grouped by problem, with the row numbers from your file (for example Rows 4, 9). Fix those rows, click Choose a different file and upload the corrected file. The most common problems are:
- a Type the upload doesn't recognize, such as Multiple choice (Multi select)
- an empty Skill area
- an answer option without a score, or a score outside 0 to 5
- a question with no option scored 5
- a multiple response option scored anything other than 0 or 5
- a true or false question without exactly one option scored 5 and one scored 0
Uploaded questions are added to the ones already in your test and never replace them. Edit or remove them like any other question. Bulk upload isn't available for coding tests.
Uploaded questions can be edited or removed like any other question. Bulk upload isn't available for coding tests.
Final checks
Before you publish, check your test against this list:
- Do your questions cover the skill areas appropriately and fully? Is every question in the right skill area?
- Are the questions varied enough? Asking the same thing twice has very limited use.
- Is every question and answer option clear? You don't want to confuse your candidates.
- Is all the information relevant to the answer? Proofread and fact-check your questions.
- Are pictures, audio and video clear and relevant? Are graphs and diagrams labeled correctly?
- Did you check grammar and spelling in every question, in whatever language you wrote it?
Step 3: Settings and publishing
Settings save automatically as you change them.
|
|
Questions: tick Show all questions to candidates, or set the Number of questions each candidate gets. If you show only some questions, we balance them across skill areas. If one skill area has fewer questions, we show more from the others. Writing more questions than you show lets each assessment use a different set, which makes your test harder to leak. |
|
|
Duration: set the Test duration in minutes. Allow at least 15 seconds per question. For guidance, see Choosing a length for your custom test. |
|
|
Order: with Shuffle questions for each assessment on, each assessment gets its own question order, and all candidates in that assessment see the same order. To show questions in a fixed order, turn shuffling off. A fixed order needs Show all questions to candidates. |
|
|
When you're ready, click Finalize. Your test is published, and you can add it to assessments. |
Adding your test to an assessment
Create a new assessment or edit an existing one. Our Guide to creating an assessment walks you through it.
When you add tests, choose My company in the Show tests from filter to see your own tests. Add your test the same way you would a test from the TestGorilla library.
Note: Your test only appears when its language matches the language of the assessment. Adding a custom test to an assessment needs a Plus plan; on other plans, you'll be asked to upgrade.
Editing your test
Open your test from the Library (Skills tests tab, Show tests from: My company). What you can change depends on whether the test is published:
- Drafts: change anything, then click Finalize to publish.
- Published tests: you can fix wording, such as a typo in a question or an answer. Questions, answers and scoring are locked, so results stay comparable for candidates who already took the test. Your fixes save straight away, and the header shows Saved.
To make bigger changes to a published test, such as adding questions or changing answers, open the test's menu in the Library and choose Enable edits. This creates a new draft version of the test. Assessments that already use the test keep the version they have. Make your changes, then click Finalize to publish the new version.
Common questions
Can I create a custom test on any plan?
Yes. Everyone can create, save and publish their own tests. To add a custom test to an assessment and invite candidates to take it, you need a Plus plan, like other premium features.
Why can't I click Finalize?
Check that:
- You've set the number of questions (or ticked Show all questions to candidates) and the test duration.
- The duration allows at least 15 seconds per question.
- For coding tests: every question's verification code has run without errors. Questions that still need it show Setup incomplete.
If everything is set and you still can't publish, contact our support team.
Do all skill areas need the same number of questions?
No. If you show only some of your questions, we balance them across skill areas and fill any gap with questions from the other areas.
Can I change the test type after I've started?
No. The test type is locked once the test is created. To use a different type, create a new test.
Do I have to add practice questions?
No, they're optional. They help candidates get used to the format, so we recommend adding at least one.
Can I import questions from another tool?
Yes. Copy them into our Excel template, one question per row, and upload the file in Step 2: Questions. See Upload questions in bulk.
Why weren't any questions added from my file?
We add questions only when every row in the file is valid, so one problem row stops the whole upload. The upload lists the rows to fix. Fix them and upload the file again.
Will uploading a file replace the questions already in my test?
No. Each upload adds to the questions you already have. To replace questions, remove the old ones first.
Next steps
This is the fourth article in a series of five, to help you create your own tests using the TestGorilla platform. The full series includes:
- Developing an effective screening test
- Choosing a question type
- Writing situational judgment questions
- How to create and use your own test
- Creating a custom coding test
If you're going to make a coding test, read article five next: Creating a custom coding test