I have many CSV files with different names in a folder(named Excel_Files) and I would like the bot to merge all these files in an Excel sheet named “Output”.
All the CSV files have the same number of columns and have the same column names.
In the If loop…it will look for output.csv exists…first time file wont be available so it goes write csv and creates the file with headers…second time it goes to append csv and appending rest of files …
Hope this helps…
Note: Change the path in the For Each loop, as per your requirement…
Hi @Yudhisteer_Chintaram1 - Did you get a chance to try ? if it worked, please mark my post as solution , that will close the thread and others will benefit from it(finding solved posts).