View Categories

How to Upload Multiple Testing Sessions Using Excel Template

Article verified for Release 15.1 on September 19, 2025

YouTestMe allows administrators to efficiently import multiple testing sessions for one or more tests using the Excel template. In addition to creating and configuring sessions, the template also enables the bulk upload of users and proctors. This guide explains how to use the Excel template to upload sessions and manage their assignments.

Upload testing sessions

  1. Testing sessions – From the side menu, click Testing Center > Testing sessions.

  2. Import testing sessions – Click Import testing sessions to open the import window.

  3. Excel template – Download the Excel template to create multiple sessions, a single session with multiple tests, or just one test.

  4. Instructions – Click here to download detailed instructions for filling out the template.

  5. Upload file – Click the upload area or drag & drop your Excel file .

  6. Upload – Press Upload to import the selected file.

  7. Cancel – Click Cancel to stop the process.

  8. Play video – Click Play video to watch a step-by-step tutorial

Filling in the Excel template

When using the Excel template, you’ll need to complete the required fields

  1. External Session ID (Optional):
    A unique text identifier for the session. Useful if you want to reference this session later in reports or integrations.

  2. Session Name (Required):
    A clear and descriptive name for the testing session.

  3. Test ID(s) (Required):
    One or more test IDs assigned to this session. If multiple tests are included, separate them with commas.

  4. Location ID (Optional):
    A numeric value representing the physical or virtual location of the session.

  5. Time Zone (Required):
    Use the appropriate time zone code as listed in the Legend sheet.

  6. Available From (Required):
    The session’s start date and time in the format: dd/mm/yyyy hh:mm.

  7. Available To (Required):
    The session’s end date and time in the format: dd/mm/yyyy hh:mm.

  8. External Session Name (Optional):
    If applicable, provide the session name already used in an external system.

  9. Session Password (Optional):
    A password for locking/unlocking the session.
     Note: If this field is filled, the Locked field must be set to Yes.

  10. Group ID (Optional):
    Assigns the session to a specific group using a numeric ID.
    Note: Candidates not part of the group will not be imported.

  11. Candidate Self-Enrollment (Optional):
    Accepts Yes or No.

    1. Yes = Candidates can enroll themselves in the session.

    2. No = test manager must manually assign them.
      Invalid values will trigger a system error.

  12. Locked (Optional):
    Accepts Yes or No (default).

    1. Yes = session is locked (requires password if set).

    2. No = unlocked.

  13. Booking Deadline (Optional):
    Last date and time candidates can book the session. Format: dd/mm/yyyy hh:mm.
    After this, no new bookings are allowed.

  14. Cancellation Deadline (Optional):
    Last date and time candidates can cancel their booking. Format: dd/mm/yyyy hh:mm.
    After this, cancellations are not allowed.

  15. Seat Limit (Optional):
    Maximum number of candidates who can book the session. Enter a numeric value.

  16. Authorization (Optional):
    Accepts Yes or No (default).

    1. Yes = candidates need authorization before starting the test.

  17. Proctoring ID (Optional):
    ID from the proctoring configuration under Integrations → Proctoring Settings.

  18. Built-in Browser Lockdown (Optional):
    Accepts Yes or No (default).

    1. Yes = test runs in full-screen mode with restricted browser actions.

  19. Active (Optional):
    Accepts Yes or No (default).

    1. Yes = marks the session as active.

    2. No = session remains inactive.

    Detailed guidelines can be found in the Instructions or Legend sheet within the template.

     

    To upload candidates to a session, follow these steps:

    1. Open the Users sheet in the Excel file.
    2. Enter the exact usernames in the Username column.
    3. Provide the corresponding session External Session ID

    To upload proctors to sessions, follow these steps:

    1. Open the Proctors sheet in the Excel file.
    2. Enter the exact usernames in the Username column.
    3. Provide the corresponding session External Session ID in the next column.

     

    Previewing testing sessions in the application

     

     

    For more related instructional materials, please visit:

    Powered by BetterDocs