Skip to main content
Sign in

Creating an Excel Spreadsheet for Bulk Importation

Alexis Butts
  • Updated

 

Overview

  • Excel Spreadsheet are simple an easy to make
  • Using them, you can import users, tests, questions, courses, register users, and more.
  • ProLearn can provide you with several different templates
  • The system will automatically create activities for assessments and questions for each question imported

 

If you would like to know about Importing an Excel Spreadsheet or The Media and Files Section, please click the links!

What is covered

  • Options for spreadsheet importation
  • How to import Questions
  • What can you import
  • Import Users

 

Make the Spreadsheet yourself

You can make these Spreadsheets yourself with ease. You will see some examples in the video of formatting options

We can create the Spreadsheet for you!

We can also do the formatting and enter your information for to make this a breeze. All you have to do is drag and drop the spreadsheet we create into the Bulk Import Section. Please contact us for more details!

 

 

Text Walkthrough

 

Import Questions

Excel_Spreadsheet.PNG

  1. To import questions the only areas you need filled are the areas highlighted in blue
    1. Question
    2. Correct Choices
  2. Along with the blue areas we recommend filling in the areas in green
    1. Activity Name (gives the question a name-see in video)
    2. Answer choices (A,B,C,D)
  3. When formatting the section names, separate words with one period or NO SPACES
    1. i.e. "Activity.type" or "CorrectFeedback"
  4. Then for each question fill in the necessary information
  5. You can add an array of sections, namely all the sections in the question edit page
  6. Format you Excel Spreadsheet to your liking and any any extra section you want!

 

What can you import with Questions?

  1. You can import questions with a course and a survey
  2. Questions with a course
  3. Assessment with question in a course
  4. Matrix questions and so much more. 
  5. Reach out to us for templates and more information!

 

Import Users

User_Import.PNG

  1. To import users the only areas that are necessary are the First/ Last Name and their emails.
  2. You can register them to products or classes by putting the Product Id under the "CustomerProductIds" section.
  3. You can also add their password, Member Id and preferred language.
  4. When formatting the sections above, separate words with one period or no spaces.
    1. i.e. "FirstName" or "Last.Name"

 

Now you know how to Upload an Excel Spreadsheet!

 

Have fun uploading!