How to Create Folders Based on Cell Values in Excel Office 365?
Tags: createfoldersbasedon, kutoolsexceltutorial, kutools
Published: 2020-10-20 12:13:43

---
title: How to Create Folders Based on Cell Values in Excel Office 365?
published: true
date: 2020-10-19 12:14:08 UTC
tags: CreateFoldersBasedon,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-create-folders-based-on-cell-values-in-excel-office-365/
---

In this tutorial, we will discuss how to **Create Folders Based on Cell Values in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Steps to Create Folders Based on Cell Values:

If you want to create a folder based on cell value, then follow the below steps.

- First, you need to **select a range** for which you want to create folders.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-13.png)<figcaption id="caption-attachment-15980">Example data</figcaption>

- On the **Kutools Plus** Tab, **select** the **Import & Export** option, **choose** the **Create Folders from Cell Contents** option from the drop-down list.

![Select Import & Export option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Import-Export-option.png)<figcaption id="caption-attachment-15981">Select Import &amp; Export option</figcaption>

- It will open the **Create Folders from Cell Contents Dialog Box.**
- In that dialog box, you need to **click** the **button** given in the **Directory** section to specify a certain directory to put the folders.
- Then, **click** the **OK** button.

![Create Folders from Cell Contents Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Create-Folders-from-Cell-Contents-Dialog-box.png)<figcaption id="caption-attachment-15982">Create Folders from Cell Contents Dialog box</figcaption>

- Now, it will open the **Kutools for Excel dialog box** to tell you how many folders created successfully.

![Prompt Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Prompt-Box-6.png)<figcaption id="caption-attachment-15983">Prompt Box</figcaption>

- After that, you need to go to that specified directory to see the created folders.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-25.png)<figcaption id="caption-attachment-15985">Result</figcaption>

In this method, you can create folders based on the selection in the Excel.

## Closure:

In the above tutorial, you can clearly learn the steps to **Create Folders Based on Cell Values in Excel Office 365** using **Kutools. ** Drop your **feedback** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Create a Stacked Chart with Showing Percentages in Excel?](https://geekexcel.com/how-to-create-a-stacked-chart-with-showing-percentages-in-excel/)
- [Protect Multiple Worksheets at a Time in Excel Office 365!](https://geekexcel.com/protect-multiple-worksheets-at-a-time-in-excel-office-365/)