{"id":33159,"date":"2023-11-17T19:07:14","date_gmt":"2023-11-17T18:07:14","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33159"},"modified":"2024-03-22T16:17:08","modified_gmt":"2024-03-22T15:17:08","slug":"combine-csv-files","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combine-csv-files\/","title":{"rendered":"How to combine CSV files &#8211; 2 Quick &#038; Easy Methods"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/C8455177-5C88-46AD-A1D9-F35C0FC360DD.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-38522\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/C8455177-5C88-46AD-A1D9-F35C0FC360DD-1024x576.png\" alt=\"Combine CSV Files\" width=\"1024\" height=\"576\" title=\"\"><\/a><\/p>\n<p><strong>CSV\u00a0is the most popular format<\/strong> for storing and exchanging data among users. You might often encounter a situation where you have <strong>multiple CSV files from diverse sources and you want to combine CSV files<\/strong> in Excel. The process of merging CSV files into a single file can significantly <strong>improve analysis and facilitate easier data access<\/strong>.<\/p>\n<p>In this guide, we&#8217;ll explore<strong> step-by-step instructions<\/strong> on how to merge multiple CSV files into one file.<\/p>\n<p>Let us look at two methods in detail.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Combine CSV files \u2013 <a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Sales-Data.zip\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Sales-Data.zip<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combine-csv-files\/#Method_1_%E2%80%93_Using_Windows_Command_Prompt\" title=\"Method 1 \u2013 Using Windows Command Prompt\">Method 1 \u2013 Using Windows Command Prompt<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combine-csv-files\/#Method_2_%E2%80%93_Using_Power_Query\" title=\"Method 2 \u2013 Using Power Query\">Method 2 \u2013 Using Power Query<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combine-csv-files\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Using_Windows_Command_Prompt\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">Method 1 \u2013 Using Windows Command Prompt<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Below are step-by-step instructions on how to combine multiple CSV files using the Windows Command Prompt &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span><\/strong>Place all the CSV files in one folder.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37632\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-15.png\" alt=\"Combine CSV files\" width=\"1136\" height=\"307\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>Select the folder containing the CSV files and press Ctrl +Shift + C to Copy Path.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37626\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-9.png\" alt=\"Combine CSV files\" width=\"1186\" height=\"869\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>In the Windows search box, type the command prompt and select the application.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37627\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-10.png\" alt=\"Combine CSV files\" width=\"951\" height=\"969\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>In the Command Prompt window, type cd followed by a space and then paste the folder path by pressing Ctrl + V.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-111.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38536\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-111.png\" alt=\"Combine CSV files\" width=\"1488\" height=\"554\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>Use the <strong>copy<\/strong> command to combine all CSV files into one. The wildcard <strong>*<\/strong> is used to include all files with the CSV extension.<\/p>\n<p><b>copy *.csv <strong>combined-csv-files.csv<\/strong><\/b><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-121.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38537\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-121.png\" alt=\"Combine CSV files\" width=\"1484\" height=\"613\" title=\"\"><\/a><\/p>\n<p>The name of the combined csv file will be <strong>combined-csv-files.csv<\/strong>. The combined file will look like this &#8211;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37630\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-13.png\" alt=\"Combine CSV files\" width=\"1092\" height=\"338\" title=\"\"><\/a><\/p>\n<p>You can format it as per your requirements.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37631\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-14.png\" alt=\"Combine CSV files\" width=\"612\" height=\"1019\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_Using_Power_Query\"><\/span><strong><span id=\"2\" style=\"color: #ff0000;\">Method 2 \u2013 Using Power Query<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Instead of using the Windows command prompt to combine CSV files, you can use the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/power-query-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>Power Query<\/strong><\/a> feature in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/mastering-excel-skills\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel<\/strong><\/a> to easily combine them with just a few clicks. Follow the steps below to know how &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span><\/strong>Click on the <strong>Data<\/strong> tab and then navigate to the <strong>Get Data<\/strong> option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37619\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-2.png\" alt=\"Combine CSV files\" width=\"1538\" height=\"225\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>In the Get Data menu, select From File &gt; From Text\/CSV.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37618\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-1.png\" alt=\"Combine CSV files\" width=\"712\" height=\"651\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>Select the file named Desktop Sales and select <strong>Open<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37621\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-4.png\" alt=\"Combine CSV files\" width=\"936\" height=\"583\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong><strong>Check the sample<\/strong> in the dialog box and click <strong>Load<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37622\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-5.png\" alt=\"Combine CSV files\" width=\"1082\" height=\"803\" title=\"\"><\/a><\/p>\n<p>The data for desktop sales will be loaded in the worksheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37623\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-6.png\" alt=\"Combine CSV files\" width=\"776\" height=\"1017\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>Repeat the same steps (Steps 1 to 4) to import the sales data for laptops, tablets, and smartphones as well.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37625\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/11\/Combine-CSV-files-8.png\" alt=\"Combine CSV files\" width=\"973\" height=\"1020\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/consolidate-multiple-excel-sheets-using-power-query\/\" target=\"_blank\" rel=\"noopener\"><strong>Click here<\/strong><\/a> to learn how to combine multiple Excel worksheets using Power Query!<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong><span style=\"color: #ff0000;\">Conclusion<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This guide explores two methods for achieving this \u2013 Method 1 involves using the Windows Command Prompt, while Method 2 utilizes the <a class=\"wpil_keyword_link\" title=\"Power Query\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Power Query<\/a> feature in Excel, allowing users to seamlessly combine CSV files with just a few clicks.<\/p>\n<p>The choice between these methods depends on individual preferences and specific data management needs.<\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/power-query\/combine-files-csv\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn all about combined CSV files.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CSV\u00a0is the most popular format for storing and exchanging data among users. You might often encounter a situation where you have multiple CSV files from diverse sources and you want to combine CSV files in Excel. The process of merging CSV files into a single file can significantly improve analysis and facilitate easier data access. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[121,648],"tags":[1457,1456,1458],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33159"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=33159"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33159\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33165"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}