Welcome to the new Box Support website. Check out all the details here on what’s changed.

Box Status

Is it possible to use a Microsoft Excel spreadsheet to create thousands of folders with sub folders without having to create each one individually.

Follow
New post
Katelyn Botts

Is it possible to use a Microsoft Excel spreadsheet to create thousands of folders with sub folders without having to create each one individually. 

 
0

Comments

2 comments

Date Votes
  • Rui Barbosa

    Hi Katelyn,

    Yes you can.

    You have several options, for example the Box CLI accepts CSV formatted files, and you can build a script to create and navigate folders. In this Medium article we explore a similar use case, but it is an example of CLI usage with CSV files.

    To create a Box folder programmatically you'll need the parent folder id and the new folder name. This means you need to keep track of the parent folders id in order to create the sub folders. 

    Other options include the usage of one of the SDK's to create an app, and the inner working is similar.

    Let us know if this helps.

     

     

    0
    Comment actions Permalink
  • Rui Barbosa

    Hi Katelyn,

    Let me add some context around my answer.

    The Box CLI (command line interface) is a tool you install on your computar that will allow you to issue commands directly to Box, opening the door for some automation, like your use case in creating many folders.

    I don't know how comfortable you are with scripting, but here is a quick start guide (including some videos) if you would like to investigate.

    Let us know how we can help.

    Best regards

    0
    Comment actions Permalink

Please sign in to leave a comment.