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 ...
What do you want by "modify Table.TransformColumnTypes function so that it can be dynamic for every file"?
https://techcommunity.microsoft.com/t5/excel/split-to-values/m-p/4073531/highlight/false#M222583
Do you intent to parse .csv like above?
https://techcommunity.microsoft.com/t5/excel/split-to-values/m-p/4073531/highlight/false#M222583
Do you intent to parse .csv like above?
- Yes, my goal is to parse all the csv files. But the importang thing is language specific characters. All the unicode characters need to be converted into the language letter.
