Why would you want all the files in a directory in a spread sheet? There are a number of reasons here’s a few.
- You need to import files into a management program
- You need to extract data from the file names.
- To create a spread sheet that contains the original file name and the file name you want to rename the file to (I’ll cover this in another posting).
To get started we will need a list of all the files in the directory you want to work on. This is very easy to do at the command line or it can been done with a batch file in the window. I’ll cover on how to do this from the directory window.
Step 1) Navigate to the directory you want to make the file list from.
Step 2) Right click on an white space inside that window and scroll down to New and then left click on Text Document
Step 3) name you new text document. (example File_List.txt)
Step 4) Click on the new file. (it should open in Note Pad)
Step 5) Type in the following line. Dir /b >List.csv
Step 6) Click on the File tab and Save.
Step 7) Click on the File tab and click on Save As and save the file as File_List.bat
Step 8) Close note pad.
Step 9) Double click the new file File_List.bat
Step 10) Find the new file created called List.csv.
Step 11) Left click on the file, scroll to Open With and click o your spread sheet program.
This will cause it to open an import window. You will see a lot of options. But to get the file names in we just need to make sure of a couple things.
Step 12) Set up import. Select delimter to Tab and then click on the colum that says standard then click on the drop down box above and change to text.
Step 13) Click Import.
Step 14) Save in your spread sheets file format.
Now you have a spread sheet of all your files names in that directory. You can now use the tools of the spread sheet to extract data from the file name to create other fields or to fill in what the new file names are going to be if your doing bulk renaming. To keep things simple do not use _ instead of spaces. It makes creating the batch file much easier.