Forum Discussion
Loop Through Every CSV Files in Folder and Import Using Power Query
Hello, I've got tons of CSV files I need to process. I want to load them inside one Workbook seperate worksheets and tables using Power Query. I could do with separate files as well. The reason I ...
I'm not sure why do you need VBA for that, From Folder connector could work.
Change Type step is optional, if you skip it most probably that doesn't affect the result. If we speak about Excel.
If every file have different structure, when we need some logic defined how to handle it for the concrete file and how to combine into resulting file (if required).
Hello, SergeiBaklan
All the files have a different stucture. I either need to load them inside a separate sheet and table, or a new workbook. I'm not sure how to approach this and tried to accomplish it with VBA as reading the folder through Power Query combines all the files inside one sheet and table which doesn't fullfil the purpose because every file has a different structure.
