{"id":3415,"date":"2016-10-06T16:36:14","date_gmt":"2016-10-06T07:36:14","guid":{"rendered":"https:\/\/quizgenerator.net\/?page_id=3415"},"modified":"2024-07-25T09:23:17","modified_gmt":"2024-07-25T00:23:17","slug":"csv%e3%81%a7%e5%95%8f%e9%a1%8c%e3%82%92%e4%bd%9c%e3%82%8b","status":"publish","type":"page","link":"https:\/\/quizgenerator.net\/en\/%e3%82%af%e3%82%a4%e3%82%ba%e3%82%b8%e3%82%a7%e3%83%8d%e3%83%ac%e3%83%bc%e3%82%bf%e3%81%a7%e3%82%af%e3%82%a4%e3%82%ba%e3%82%92%e4%bd%9c%e3%82%8b\/csv%e3%81%a7%e5%95%8f%e9%a1%8c%e3%82%92%e4%bd%9c%e3%82%8b\/","title":{"rendered":"Create a quiz in Excel"},"content":{"rendered":"<p style=\"text-align: center; font-size: 18px;\">\n<strong>Microsoft Excel and Google Spreadsheet are available.<br \/>\nThis page explains how to create a quiz using Excel.<\/strong><\/p>\n<h3 class=\"style3a\"><strong>1. Create a problem<\/strong><\/h3>\n<p>Problems can be created from a spreadsheet.<br \/>\nThe template can be downloaded from<\/p>\n<p><a class=\"q_button\" href=\"https:\/\/quizgenerator.net\/en\/download\/27402\/\">Japanese: format<\/a>\u3000<a class=\"q_button\" href=\"https:\/\/quizgenerator.net\/en\/download\/22939\/\">English: format<\/a><\/p>\n<h3 class=\"style3a\"><strong>2. the procedures and rules for creating questions<\/strong><\/h3>\n<p>Add<strong>#format:table<\/strong>Enter the<br \/>\n*If this description is not included, the system will not operate properly.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_01.jpg\" alt=\"\" width=\"1024\" height=\"482\" class=\"aligncenter size-large wp-image-26546\" srcset=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_01.jpg 1049w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_01-300x174.jpg 300w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_01-1024x593.jpg 1024w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_01-768x444.jpg 768w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_01-18x10.jpg 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><br \/>\n<br \/>\nNext, enter the question text in column A, the symbols to determine the question type in column B, the correct answer in column C, and the wrong answer in column D and beyond.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_02.jpg\" alt=\"\" width=\"1024\" height=\"542\" class=\"aligncenter size-large wp-image-26549\" srcset=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_02.jpg 1057w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_02-300x173.jpg 300w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_02-1024x589.jpg 1024w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_02-768x442.jpg 768w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_02-18x10.jpg 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><br \/>\n<br \/>\nIf you start a new line, it will be recognized as the next quiz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_03.jpg\" alt=\"\" width=\"1024\" height=\"548\" class=\"aligncenter size-large wp-image-26550\" srcset=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_03.jpg 1057w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_03-300x172.jpg 300w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_03-1024x588.jpg 1024w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_03-768x441.jpg 768w, https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_03-18x10.jpg 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><br \/>\n<\/p>\n<p>When all questions are completed, save the file.<\/p>\n<h3 class=\"style3a\"><strong>3. generate quizzes using the conversion tool<\/strong><\/h3>\n<p>Select the created question data and click the \"Convert\" button to generate the quiz player.<br \/>\nFor more information on the process of conversion, see \"<a href=\"https:\/\/quizgenerator.net\/en\/%e3%82%af%e3%82%a4%e3%82%ba%e3%82%b8%e3%82%a7%e3%83%8d%e3%83%ac%e3%83%bc%e3%82%bf%e5%a4%89%e6%8f%9b%e3%83%84%e3%83%bc%e3%83%ab\/\">Conversion Tool<\/a>Please refer to the page \"3.<br \/>\nYou can check the contents of the quiz you have created by clicking on the menu button below.<br \/>\nPreview \u2192 Displays the conversion result.<br \/>\nDownload \u2192 Download the conversion results.<br \/>\nLimited publication \u2192 publish only to those who know the URL.<br \/>\n*Copy and paste the tag (IFrame) for embedding the quiz for limited public use, and you can put the quiz you created on your blog or website.<\/p>\n<h5 class=\"style5a\">FAQ<\/h5>\n<p>When entering English characters, the first letter is capitalized.<br \/>\nMove the mouse cursor over the cell that will be capitalized and right-click&gt;Format Cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25619\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_04.jpg\" alt=\"\" width=\"900\" height=\"500\" \/><br \/>\n<br \/>\nNext, select a string from the classification (C) and click the OK button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25620\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/how-to-use\/quiz\/EN\/en_qg_createquizbyexcel_05.jpg\" alt=\"\" width=\"900\" height=\"500\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"You can create quizzes using spreadsheets such as Microsoft Excel or Google Spreadsheets. On this page, you will find Excel...","protected":false},"author":1,"featured_media":12275,"parent":37,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"content-type":"","_lmt_disableupdate":"yes","_lmt_disable":"","vkexunit_cta_each_option":"","footnotes":""},"class_list":["post-3415","page","type-page","status-publish","has-post-thumbnail","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/3415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/comments?post=3415"}],"version-history":[{"count":62,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/3415\/revisions"}],"predecessor-version":[{"id":28410,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/3415\/revisions\/28410"}],"up":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/37"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/media\/12275"}],"wp:attachment":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/media?parent=3415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}