Batch merge csv

Please copy the following into the notepad, change the suffix to .bat

for /f %%a in (‘dir /b *.CSV’) do for /f “tokens=*” %%b in (%%a) do echo %%b,%%a >> all.csv
Picture1Place it in your folder, together with all other .csv file.
Double click .bat file, it will generate the all.csv file with all if the csv merged with the source listed.
Picture1

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.