{"id":139,"date":"2022-12-04T06:17:05","date_gmt":"2022-12-04T06:17:05","guid":{"rendered":"https:\/\/quiz.seeksolution.in\/help\/?p=139"},"modified":"2022-12-07T09:42:21","modified_gmt":"2022-12-07T09:42:21","slug":"importing-quiz-questions-with-an-excel-spreadsheet","status":"publish","type":"post","link":"https:\/\/quiz.seeksolution.in\/help\/?p=139","title":{"rendered":"Importing quiz questions with an excel spreadsheet"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"139\" class=\"elementor elementor-139\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1b8ac9fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b8ac9fc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-20c963a5\" data-id=\"20c963a5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-95c0469 elementor-widget elementor-widget-heading\" data-id=\"95c0469\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.11.5 - 14-03-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\"><h1 style=\"margin: 20px 0px 10px; font-size: 36px; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; line-height: 1.1; color: rgb(51, 51, 51); white-space: normal;\">Importing quiz questions with an excel spreadsheet<\/h1><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4115f8e1 elementor-widget elementor-widget-text-editor\" data-id=\"4115f8e1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.11.5 - 14-03-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#818a91;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#818a91;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<!-- wp:paragraph -->\n<p>Do you have loads of questions and looking for a fast way to create a quiz? Importing questions is a quick and easy way to create a quiz with a large number of questions.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>By uploading questions with&nbsp;<a href=\"https:\/\/www.flexiquiz.com\/\">FlexiQuiz<\/a>, you can:<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul><!-- wp:list-item -->\n<li>Add multiple questions to an existing quiz.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Add the items to your&nbsp;<a href=\"https:\/\/www.flexiquiz.com\/Help\/faq\/what-is-a-question-bank\">question bank<\/a>.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>All you need to do is download the FlexiQuiz template, add your questions, scoring, answer, and formatting options.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>This guide walks you through each step for completing the template and uploading your questions.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading -->\n<h2>How a quiz using excel<\/h2>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>Administrators and Trainers can import questions with the relevant permissions.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list {\"ordered\":true} -->\n<ol><!-- wp:list-item -->\n<li>To start, log in to your FlexiQuiz account<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>From your main dashboard, select the quiz that you would like to import your question to or create a new test.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Go to the&nbsp;<strong>Create<\/strong>&nbsp;screen on your test<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Press&nbsp;<strong>Add item<\/strong>&nbsp;and choose&nbsp;<strong>Import questions<\/strong>&nbsp;from the drop-down menu<img decoding=\"async\" src=\"https:\/\/www.flexiquiz.com\/Uploads\/Guides\/7056ec5f-b3b5-4528-a10e-71b21e2b93f1_18f096e1-8615-4b02-bccb-04eac5af9793\" alt=\"FlexiQuiz create page\"><\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Press&nbsp;<strong>download template<\/strong>&nbsp;to access a copy of the FlexiQuiz spreadsheet<img decoding=\"async\" src=\"https:\/\/www.flexiquiz.com\/Uploads\/Guides\/7056ec5f-b3b5-4528-a10e-71b21e2b93f1_38cfecaa-a9cd-4934-8be0-dc8574306403\" alt=\"FlexiQioz page to download question spreadsheet\"><\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Please read all of the instructions before completing the template.<img decoding=\"async\" src=\"https:\/\/www.flexiquiz.com\/Uploads\/Guides\/7056ec5f-b3b5-4528-a10e-71b21e2b93f1_16af74b9-bdd9-4a65-8104-a0e6e54d7e1c\" alt=\"Import quiz questions spreadsheet\"><strong>Top tips!<\/strong><ul><li>Do not move or delete any of the columns, or the file will not upload correctly.<\/li><li>You can leave some of the columns blank, such as the options.<\/li><li>It&#8217;s not possible to upload images, files, audio, or video using the template. However, you can add media to your quiz after the questions have been uploaded.<\/li><li>If you want to add questions to a category in your bank, you will need to create the category before uploading the file.<\/li><\/ul><br>Fields:<strong>Question text:<\/strong>&nbsp;Enter the text for your question, statement, or challenge.<strong>Question type:<\/strong>&nbsp;Choose the question type &#8211; see options below. If this column is left blank, questions will be uploaded as a Single Choice (drop-down).<strong>Points type:<\/strong>&nbsp;Choose how you would like to award points from the drop-down menu.<strong>Question points:<\/strong>&nbsp;Award points when the test-taker gets the whole question correct. If you leave this space blank, the system will automatically award one point.<strong>Option points:<\/strong>&nbsp;Award or deduct points based on the answer options that the test-taker selects.<strong><a href=\"https:\/\/www.flexiquiz.com\/Help\/create\/setting-mandatory-quiz-questions\">Required<\/a>:<\/strong>&nbsp;Select yes from the drop-down menu if the test-taker needs to respond before the quiz is submitted.<strong>Question feedback:<\/strong>&nbsp;Provide feedback after the test-taker responds to the question. You can choose to score and share feedback during the quiz or at the end.<strong>Question categories:<\/strong>&nbsp;To add a question to the question bank, you must provide a category already in the bank.<strong>Randomize options:<\/strong>&nbsp;Shuffle the order of the answer options every time the quiz is taken. Choose yes or no from the drop-down menu.<strong>Option 1 Text:<\/strong>&nbsp;Enter the text for the first answer option or matching text.<strong>Option 1 Correct:<\/strong>&nbsp;If you have chosen to award question points &#8211; select yes or no if you would like the FlexiQuiz system to award points for this answer.<strong>Option 1 Points:<\/strong>&nbsp;If you have chosen option points &#8211; set how many points you would like to award for this option. The points can be a positive or negative number.<br>Question types:<strong><a href=\"https:\/\/www.flexiquiz.com\/Help\/create\/multiple-choice-test-maker\">Single choice (radio buttons)<\/a>:<\/strong>&nbsp;Test-takers can choose on correct response from a list of possible responses.<strong>Single choice (drop-down):<\/strong>&nbsp;Test takers can select one answer options from a drop-down menu of answer options.<strong>Multiple choice:<\/strong>&nbsp;Test takers can select one or more answer options from the list of possible answer options.<strong>Matching text:<\/strong>&nbsp;Users type their response; this can be matched to a predefined list of correct answer options.<strong>Free text:<\/strong>&nbsp;Users manually enter text in response to your question, statement, or challenge. You will need to mark and grade free text questions manually.Due to the nature of the responses, it&#8217;s impossible to upload fill-in-the-blanks or picture choice questions.<img decoding=\"async\" src=\"https:\/\/www.flexiquiz.com\/Uploads\/Guides\/7056ec5f-b3b5-4528-a10e-71b21e2b93f1_d9f8f17f-4dcd-49a9-b859-9749b28c11e3\" alt=\"quiz question spreadsheet with completed fields\"><\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Save a copy of the excel file in excel 2012 or later.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Return to the flexiquiz.com<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Press&nbsp;<strong>Select file<\/strong>&nbsp;and choose the correct FlexiQuiz template<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Please allow a few moments for the file to upload.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Your questions will be added to your selected quiz on your existing page or a page set on the spreadsheet.<img decoding=\"async\" src=\"https:\/\/www.flexiquiz.com\/Uploads\/Guides\/7056ec5f-b3b5-4528-a10e-71b21e2b93f1_22c65539-95d0-4c32-b956-889a6ebd6173\" alt=\"Create screen with spreadsheet question\"><\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>If you&#8217;ve provided a category, the questions will also be added to your question bank.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>You can format and size the questions on the&nbsp;<strong>Theme<\/strong>&nbsp;screen. Enterprise members can also use google fonts.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Finish configuring your quiz and share.<\/li>\n<!-- \/wp:list-item --><\/ol>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p><strong>Relevant help guides:<\/strong><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/www.flexiquiz.com\/Help\/create\/managing-question-categories\">How to manage question categories<\/a><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/www.flexiquiz.com\/SC\/N\/ways-to-share-answers-and-feedback\">Question feedback<\/a><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/www.flexiquiz.com\/Help\/create\/scoring-your-quiz\">Scoring your quiz<\/a><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/www.flexiquiz.com\/Help\/configure\/configuration-tools\">Configuration tools<\/a><\/p>\n<!-- \/wp:paragraph -->\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fdeba29 elementor-widget elementor-widget-button\" data-id=\"fdeba29\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/quiz.seeksolution.in\/help\/\" class=\"elementor-button-link elementor-button elementor-size-sm\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Back<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Importing quiz questions with an excel spreadsheet Do you have loads of questions and looking for a fast way to create a quiz? Importing questions is a quick and easy way to create a quiz with a large number of questions. By uploading questions with&nbsp;FlexiQuiz, you can: All you need to do is download the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false},"categories":[1],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=\/wp\/v2\/posts\/139"}],"collection":[{"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=139"}],"version-history":[{"count":4,"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=\/wp\/v2\/posts\/139\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=\/wp\/v2\/posts\/139\/revisions\/614"}],"wp:attachment":[{"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quiz.seeksolution.in\/help\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}