Let’s assume you have a product list in a Notepad or .txt file and need to import it into a column in an Excel spreadsheet. There are two ways to do that.

Learn how to merge multiple CSV files into one Excel sheet. You can combine or join more than one CSV file into one Excel Worksheet.

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.

I want to list the file name, type and size. <BR> So far I have been copying the filename by clicking on the file, pressing F2, then copying the text and then pasting it into excel.