{"id":771,"date":"2020-05-07T20:51:59","date_gmt":"2020-05-07T12:51:59","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=771"},"modified":"2020-05-07T20:51:59","modified_gmt":"2020-05-07T12:51:59","slug":"importing-from-multiple-csv-files-in-easy-excel-analysis","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/importing-from-multiple-csv-files-in-easy-excel-analysis\/","title":{"rendered":"Importing from multiple CSV files in Easy Excel Analysis"},"content":{"rendered":"<p>To import data from multiple CSV files in <a href=\"http:\/\/www.yohz.com\/ya_eea_overview.htm\">Easy Excel Analysis<\/a>, first set up the import settings for a single file as described <a href=\"http:\/\/www.yohz.com\/blogs\/2020\/05\/07\/getting-started-with-easy-excel-analysis\/\">here<\/a>.<\/p>\n<p><strong>NOTE: The layout and format of the data in all the additional files must be identical to that of the initial file.\u00a0<\/strong><\/p>\n<p>When you reach this page of the import wizard, you can then set up the additional files to import from.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-773\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_csv01.png\" alt=\"\" width=\"670\" height=\"588\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_csv01.png 670w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_csv01-300x263.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_csv01-624x548.png 624w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/p>\n<p>To add files, click on the <strong>Add<\/strong> button below the file list window.<\/p>\n<p>If you need to be able to identify each data source and your worksheets do not contain any columns that identifies the source data, you can add additional columns on this page to help identify the data source.\u00a0 Click on the <strong>Add<\/strong> button below the additional columns list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-767\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a.png\" alt=\"\" width=\"651\" height=\"189\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a.png 651w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a-300x87.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a-624x181.png 624w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/p>\n<p>On this page, enter the column name, type, length, and source of the column.\u00a0 There are several options available to use the filename or worksheet details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-774 alignnone\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_csv02.png\" alt=\"\" width=\"566\" height=\"411\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_csv02.png 566w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_csv02-300x218.png 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/p>\n<p>Using an example file name of <strong>G:\\data\\Sales_Osaka_July2020.xlsx<\/strong>,<\/p>\n<ul>\n<li><strong>filename<\/strong> = <strong>Sales_Osaka_July2020<\/strong><\/li>\n<li><span style=\"font-size: 1rem;\"><strong>filename 1st value<\/strong> = <strong>Sales<\/strong><\/span><\/li>\n<li><span style=\"font-size: 1rem;\"><strong>filename 2nd value<\/strong> = <strong>Osaka<\/strong><\/span><\/li>\n<li><strong>filename 3rd value<\/strong> = <strong>July2020<\/strong><\/li>\n<\/ul>\n<p>Note that the separators can be a dash symbol (e.g. <strong>Sales-Osaka-July2020.xlsx<\/strong>), a comma (e.g. <strong>Sales,Osaka,July2020.xlsx<\/strong>), or a dot (e.g. <strong>Sales.Osaka.July2020.xlsx<\/strong>).\u00a0 You cannot mix separator symbols e.g. <strong>Sales-Osaka.July2020.xlsx<\/strong>.<\/p>\n<p>For further details, please refer to this topic in the <a href=\"https:\/\/www.yohz.com\/help\/easyexcelanalysis\/index.htm?importing_from_multiple_files_.htm\">help file<\/a>.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/importing-from-multiple-csv-files-in-easy-excel-analysis\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/importing-from-multiple-csv-files-in-easy-excel-analysis\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>To import data from multiple CSV files in Easy Excel Analysis, first set up the import settings for a single file as described here. NOTE: The layout and format of the data in all the additional files must be identical to that of the initial file.\u00a0 When you reach this page of the import wizard, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82],"tags":[83,107],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/771"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=771"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/771\/revisions"}],"predecessor-version":[{"id":775,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/771\/revisions\/775"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}