Import Questions from Excel

socratease allows you to import questions directly from an excel file you can create a quiz on socratease and then import the excel file the questions in the excel file get appended to the quiz you can achieve this by clicking on the import button (highlighted in blue) on your quiz form steps visit this google sheets template and download the file as an excel (file > download as) once the file is downloaded, make the changes in the excel file directly do not remove any columns from the file the different columns are explained in the section below your excel file must contain only one sheet save your excel file after ensuring that it has no empty rows before you upload it onto socratease open the quiz to which you want to add questions and click on the 'import from excel' icon enable autocalculate negative points if you want negative points to be added automatically, based on the points you assign for each question this is explained below column meanings the meanings of the different columns in the excel file are mentioned below any column with a corresponds to a column that cannot be empty question type can be one of mcq (single correct answer) or mca (multiple correct answers) question the text of the question you want to ask opt1 opt5 the text of the different choices if you have only three choices, fill in opt1, opt2, opt3 and leave the rest blank correctansind for an mcq , this is an integer corresponding to the choice number that is correct for example, if option number 2 is the correct answer, correctansind = 2 for an mca , if option numbers 2 and 3 are correct, correctansind = 2,3 that is, separate the numbers with a comma and no space markdown if you want your questions and options to be shown as markdown , enter 1 in this column else, you can leave it blank points number of points for the correct answer you can leave this blank if you aren't assigning points time (in seconds) if your quiz has questions coming one by one, instead of all at once, you can specify the time limit in seconds for each question image the url of an image you want to show along with the question the image has to be a direct url (ending in a jpg, png, etc) do not share a google drive link or the link to a page that contains an image you can always make changes to your quiz after you have imported questions so, if you want to add a non mcq and non mca question, or you want to re assign the points to a question, you can do it after the questions have been imported autocalculate negative points if you are uploading a large number of questions and want to have negative points enabled, you may choose to autocalculate negative points with this option, every mcq will automatically get assigned negative points, based on the points assigned to the question the formula used for calculating the negative points is number of negative points = (number of points assigned)/(number of options) for example, an mcq with 2 points and 4 options will have 2/4 = 0 5 negative points note that for mcas we do not autocalculate negative points video tutorial