Skip to main content

Quickly create folders based on cell values in Excel

Author: Xiaoyang Last Modified: 2019-11-13

Kutools for Excel

Boosts Excel With 300+
Powerful Features

Supposing there is a list of your company employee names in an Excel file and you want to quickly create a file folder for each employee by using this list of data in Excel, with the help of Create Folders from Cell Contents utility of Kutools for Excel, you can easily create multiple file folders by using the contents of cell values.

Click Kutools Plus >> Import & Export >> Create Folders from Cell Contents. See screenshot:

shot create folder by cell contents 1


1. Select the range which contains the cell values you want to use for creating folders.

2. Click -1 button to specify a certain directory that you want to put the folders in. Then click Ok. See screenshots:

shot-create-folders-based-on-cell2 arrow-big shot-create-folders-based-on-cell3

3. And go to the folder, you will see the folders have been created. See screenshot:


Demo: Quickly create folders based on cell values in Excel

Kutools for Excel: with more than 300 handy Excel utilities, free to try with no limitation in 30 days. Download and free trial Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Just been using the create folder option but as with your example it creates the folders in alphabetical order in windows 10 and not as listed in excel. Is this a windows issue or something I can edit in the cells?
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations