How to load multiple files into separate worksheets?

[UsePowerBI]

Hello

How can I open c:\a.txt to worksheet A and c:\b.txt to worksheet B?

Obviously the above is to be done for many files so I need a neat way to do it and maintain a file list.

Thanks!

[UsePowerBI]

@amitchandak  not append, just load them to separate specified worksheets in Excel or PBI.

[amitchandak · Accepted solution]

@UsePowerBI , worksheet ?

Do you want to import and append the same type of files from folder?

https://insightsoftware.com/blog/power-bi-load-data-from-folder/