I need to create 1500 folders with different names, how to automate it?

[apatia77]

As above, I have over 1500 unique names in an excel spreadsheet and I need to make folder for each of it. Manually it’s going to take me all day, any way of automating this?

Thanks for all your help.

 

[z0mbi3]

I'd use a macro recorder. Insert a blank row above the first entry in excel and click it, open the folder you want to create the directories in. Start the recorder maximise/restore excel, press down arrow, ctrl-c, maximise/restore the folder, click file new, ctrl-v, press return, stop the macro. Just make sure you set the macro up to run itself when it reaches the end of each run.

I usally use nMacro recorder for this sort of stuff, think this is it http://www.softpedia.com/get/Security/Keylogger-Monitoring/nMacro-Recorder.shtml

edit: I know that might sound complicated, but in reality you spend 5 minutes setting it up and it'll happily work through the whole lot for you. You can put your feet up and just keep an eye on it for when it reaches the end of the list. I've done similar sort of stuff for bulk data entries before now.

 

[apatia77]

oh thanks, but I found this which worked.

@Echo off

for /f %%i in (names.txt) do mkdir %%i

 

[bledd]

this is how I'd do it..

put the names in Column B, then in Column A, type mkdir


now copy both into notepad


now do a find & replace, copy and paste a 'tab' into the find bar, and a space into the replace bar

replace all

save as renamer.bat

run in the dir

 

[Kriist]

this is how I'd do it..

put the names in Column B, then in Column A, type mkdir


now copy both into notepad


now do a find & replace, copy and paste a 'tab' into the find bar, and a space into the replace bar

replace all

save as renamer.bat

run in the dir

edit: bah nm misread your quote

 

[xxalxx]

I would get a minion to do it

 

[apatia77]

I would get a minion to do it

haaahaaaha


How about creating all these folders and then some folders withing these folders?
EDIT: I figured this myself just needed to add folder1\another_folder

 

[bledd]

mkdir c:\folder1\another_folder

that would create folder1 (if it doesn't exist) and another_folder