A python script to create a ton of subdirectories from an excel spreadsheet.

Use case
Output markers as text from pro tools, and then create folders for the files based on the marker name in an XLSXfile or just create a huge directory structure from an XLSX file for whatever deliverable you need.

To use, move the python script into a folder where you'd like to generate the subdirectories

In the terminal or console, run (py or python)

py massCreateDir.py A

where A is the column in the excel spreadsheet. For example, Pro tools spits out info with the column as E, but to make it modular, I've allowed it passed as an argument.

You'll also need to run this to use the software properly. Run on python 3.

pip install openpyxl

Always back up raw materials before use.