Forum Discussion

whyyyyler's avatar
whyyyyler
Copper Contributor
Jul 13, 2023

Find and copy files to folders using excel.

Hello Everyone. 

 

I am currently organising a historical database and need to allocate a lot of scanned filedbook files to folders named with their site location (~5,000 files to be allocated to ~500 folders). I could individually search for the file name and drag it across but am looking to find an easy way to do so. 

 

Using excel I exported the folder names as a batch file to bulk create the folders with each site name. e.g. Folder: 2028_A1_032. 

 

All of the scanned files are labeled from FB_000001 through to ~FB_09602 and are located together in one folder. 

 

The spreadsheet I have (see attached example) lists the folder name in one column and the associated files in the next column. 

 

Is there anyway at all I can use a program or anything to automatically move those files to those folders. 

 

I am new to coding, I am learning as I go to help with this project so I'd appreciate any help with a clear step by step. I can work on Mac and Windows. 

Resources