How to create folder names based on Excel values or Txt files?

Question

Hi there,I often need to create large numbers of folders based on names I have saved in an Excel spreadsheet. I know in windows there is a way to create a macro within excel that automatically generates folder names based on cell values.I was therefore wondering how to do the same on a Mac operating system. The main thing is to find a way to automate the process. I understand this may involve copying the values to a text file.Below is an example of the names I need to create folders for (copied from the excel spreadsheet):Wash Bowl Small 600Deck Mounted Wash Bowl 500Wash Basin - 866 - 2 ShelvesWash Bowl Large 800Built-In Wash Basin With 1-TapholeDeck Mounted Wash Bowl 625Would really appreciate a simple step by step approach to an explanation. As my understanding of using Automator, Apple Script, Terminal, etc, is extremely basic.Thanks and Best Wishes,Graham

Niel · Answer

Copy the values and use the following AppleScript:tell application "Finder"set the_text to read (choose file)repeat with this_paragraph in paragraphs of the_textmake new folder at window 1 with properties {name:this_paragraph}end repeatend tell(122125)

GrahamEvans · Answer

Hi Niel,Thanks again for another superb response. I have another question. Is it possible to automatically generate sub-folders along with the folder.For example:Folder                                                SubfolderWash Bowl Small 600          &gt;            2D CAD                                                           3D CAD                                                           ***                                                            Images                                                           Brochures                                                           Specifications                                                           Technical                                                           Case Studies                                                           OperationsDeck Mounted Wash Bowl 500    &gt;   2D CAD                                                          3D CAD                                                          ***                                                           Images                                                          Brochures                                                          Specifications                                                          Technical                                                          Case Studies                                                          OperationsAbove shows the 9 generic sub-folders I need to create within each folder that is generated.Best Wishes,Graham

Niel · Answer

Here:tell application "Finder"set the_text to read (choose file)set second_tier to {"2D CAD", "3D CAD", "***", "Images", "Brochures", "Specifications", "Technical", "Case Studies", "Operations"}repeat with this_paragraph in paragraphs of the_textset new_folder to (make new folder at window 1 with properties {name:this_paragraph})repeat with second_folder in items of second_tiermake new folder at new_folder with properties {name:second_folder}end repeatend repeatend tell(122131)