How do I import multiple text articles into a single sheet?

Hello.

I am completely new to excel and I am working on a project that needs to use a csv file.

What I am looking to do is the following :-

What I am looking to do is to batch import some article text files that contain multiple paragraphs. All the articles will be in a single folder. I want to batch import the contents of those files into individual cells for each file maintaining the paragraph format for each article in the cell. I would like this to be done as a column. So for examle if I had 50 text articles in one folder then I would like to import the contents of each text file and then have the contents incerted into its own cell with all the paragraphs included in the single cell. So that would mean 50 cells under the 'A' column would contain the 50 text articles.

Is this possible please and if yes how can this be accomplished?

Thanks in advance for your help