{"id":4019,"date":"2016-11-07T14:30:44","date_gmt":"2016-11-07T05:30:44","guid":{"rendered":"https:\/\/quizgenerator.net\/?page_id=4019"},"modified":"2019-07-30T11:26:07","modified_gmt":"2019-07-30T02:26:07","slug":"csv%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%81%a7%e3%81%ae1-tp1te5%95%8f%e9%a1%8c%e4%bd%9c%e6%88%90%e3%81%8c%e3%81%861tp1-te3%81%be%e3%81%8f%e3%81%84%e3%81%8d%e3%81%be%e3%81%9b%e31-tp1t82%93%e3%80%82","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%bffaq%e3%81%8a%e5%95%8f%e3%81%84%e5%90%88%e3%82%8f%e3%81%9b\/csv%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%81%a7%e3%81%ae%e5%95%8f%e9%a1%8c%e4%bd%9c%e6%88%90%e3%81%8c%e3%81%86%e3%81%be%e3%81%8f%e3%81%84%e3%81%8d%e3%81%be%e3%81%9b%e3%82%93%e3%80%82\/","title":{"rendered":"It does not work to create a quiz in a CSV file."},"content":{"rendered":"<h3>Q. I downloaded the CSV format, but it fails when I edit and upload it. Is the setting here (Excel 2013) incorrect?<\/h3>\n<p>A. When you save and open your data, the<strong>In some cases, all data from column B to column F has been entered into column A.<\/strong><br \/>\n<a href=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2016\/11\/2016-11-07_1422.png\" data-rel=\"lightbox-image-0\" data-magnific_type=\"image\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2016\/11\/2016-11-07_1422.png\" alt=\"2016-11-07_1422\" width=\"1366\" height=\"551\" class=\"alignnone size-full wp-image-4021\" \/><\/a><br \/>\nHere are the steps to follow after you open it when this happens.<\/p>\n<p>(i)<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%e4%bd%bf%e3%81%84%e6%96%b9\/csv%e3%81%a7%e5%95%8f%e9%a1%8c%e3%82%92%e4%bd%9c%e3%82%8b\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create a problem in Excel\" page<\/a>Execute \"1. Download the Excel format\" in the<br \/>\nOpen the downloaded CSV file (Excel 2013)<br \/>\n<strong>At this point, it is assumed that all the data has been entered in column A. In that case, please take the following actions.<\/strong><br \/>\nSelect all of column A<br \/>\nSelect \"Data\" in the menu.<br \/>\n(5) Select \"Separation Position\" in \"Data\".<br \/>\n(6) Select \"Data separated by a comma, tab, or other delimiter\" and click \"Next.<br \/>\n(7) Check \"Tab\" and \"Comma\" in the check box of the separator, and click \"Next\".<br \/>\nSelect \"G\/Standard\" in the data format of column (8) and click \"Next\".<br \/>\n(9) Press \"Done\".<br \/>\n(10) \"You already have data, do you want to replace it? Click \"OK\" in \"10.<\/p>\n<p>If you try this, you can see the format of table format. (Maximum column: F, up to 19 rows)<\/p>\n<h3>Display example<\/h3>\n<p><a href=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2016\/11\/2016-11-07_1404.png\" data-rel=\"lightbox-image-1\" data-magnific_type=\"image\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2016\/11\/2016-11-07_1404.png\" alt=\"2016-11-07_1404\" width=\"825\" height=\"454\" class=\"alignnone size-full wp-image-4022\" \/><\/a><\/p>","protected":false},"excerpt":{"rendered":"Q. I downloaded the CSV format, but when I edit it and upload it, it fails. Is there an incorrect setting here (Excel 2013)? ...","protected":false},"author":1,"featured_media":0,"parent":164,"menu_order":100,"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-4019","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/4019","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=4019"}],"version-history":[{"count":6,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/4019\/revisions"}],"predecessor-version":[{"id":12744,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/4019\/revisions\/12744"}],"up":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/pages\/164"}],"wp:attachment":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/media?parent=4019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}