Import or convert .log as .csv

[Elifly]

Hello everyone,

I have to analyze some machine data and its exported as .log files, but the values are separated as in an .csv document.
There is a file exported for each day, so there are more than 500.
Is there an easy way to convert them or to import them into one excel sheet ?
I want to have one excel sheet afterwards with all the data from the .log files and it should be expandable as well.
What I would like most would be a makro where i could just import them as like they were .csv files.

Thanks in advance

 

[sandy666]

maybe use Power Query (Get&Transform) with From Folder feature

 

[Elifly]

Thanks that might be a good idea

 

[sandy666]

You are welcome