Query on exc Automation

Hi Folks, I am working on a process where I need to copy a data from notepad and append into an excel sheet. The problem, I am facing it is that, I have multiple notepad files in a folder and append all that data into a single sheet only, by having a one blank row gap between the next notepad data. Any idea,How to achieve this. Thanks in advance.

I can’t paste xaml due to security concern. Any input on the same would be highly appreciated.