Import Learners directly into course via a Excel Sheet

Learnyst offers a convenient way to import learners in bulk using a simple Excel template, saving time and effort, regardless of the number of learners.

  1. Access the Import Learner feature on Learnyst admin
  2. Download the default Import Template
  3. Modify the Import template
  4. Upload Template and Import Learners
  5. Import History and verify Learners

Access the Import Learners Feature

  • Log in to your Learnyst account and navigate to Users > Learners.

    import1
  • Click More > Import Learners

    import2

Download the Import Template

  • Click on Import Learners to Products. Additionally, you can import learners into different segments.

    import3
  • Click on the excel sheet to download the predefined headers titled ImportTemplate.xlsx.

    import7
  • If you want to import additional custom fields (e.g., city, math percentage score), select the Import with Custom Fields option and click Generate Template with Custom Fields.

Modify the Import Template

  • Open the downloaded Excel template. (Here we have used Google Spreadsheets)
  • Make sure the remove the cells in which the instructions are defined.

    import8
  • Fill in the learner's name, email address, and password in the respective columns.
  • Scroll to the right and enter the exact course name in the appropriate column.
  • The Learner name, Email address, password and Course Name are the mandatory fields.

    import5
  • You can provide additional optional details like validity, amount paid, start date, and access type or leave those blank.

It's crucial to enter the course name exactly as it appears in your Learnyst account. Any discrepancy may lead to import errors.


Upload and Import the Template

  • Return to the Import Learners tab in Learnyst.
  • Click the Upload button and select the filled-out Excel template.

    import9
  • Once the upload is successful, click the Import button to initiate the import process.

    import10

Monitor the Import History and verify new learners

  • Navigate to the Import History tab to monitor the learner import history.

    import12
  • You can see the new learners added after the Import Upload.

    import6