Thursday, February 9, 2017

How to create easily an Excel list of the files contained in a folder

Sometimes create a list of files contained in a folder could be annoying. If the number of files is small, not a big deal, but when the amount of file gets bigger, this task could be boring!!
Because of this, I will show you how to get a list of files quickly! This help me a lot when I was trying to make a list of the control graphics contained in a folder. Follow the next steps:

To read this article in Spanish, please visit: www.guiaautomatizacionindustrial.blogspot.com
Open the Command Prompt of Windows:


Type the location of the folder where you want to get the file list.

Type the following command specifying the location and the name of the file you want to create. This file is going to have the list of the files in the folder. (c:\CrearLista\lista.txt). We can use the location and the name that you want, but remember tu add the extensión “.txt” at the end.


Ready! You get a text document with the list of the files contained in the folder. Then, you can open the text file in Excel.