Weligaa^(Did) ma u baahday inaad ka dhoofiso dhammaan geedka hagaha gal gaar ah? Ma^(Did) u baahday in aad hesho qoraal ama dukumeenti Excel kaas oo taxaya dhammaan faylalka iyo faylalka ku jira galka gaarka ah ee kombayutarkaga oo noqda qaab dhismeed? Baahidaas ayaa nagu dhacday markii aan isku daynay inaan abuurno dukumeenti loo maleynayay inuu ahaado mid kooban dhammaan dukumeentiyada Word iyo xaashiyaha ^(Word)Excel ee aan ku kaydinay gudaha gal. Markaas ayay ahayd markii aan is weydiinnay dhowr su’aalood. Ma si toos ah ugu dhoofin kartaa qaab-dhismeedka galka Excel ? Ma jiraa amar geedka^(tree) DOS oo soo saara faylka? Ma daabaci kartaa geed hagaha gudaha Excelxaashi ama sida qoraal ahaan? Haddii aad rabto inaad ogaato sida loo dhoofiyo geed galeedka, akhri:

FIIRO GAAR AH:^(NOTE:) Waxaan haynaa laba hab oo aad ku dhoofin karto geedka gal-galka. Midka kowaad wuxuu ku salaysan yahay isticmaalka Command Prompt oo soo saara geedka hagaha sida faylka qoraalka ah. Midda labaad waxay ku tiirsan tahay fayl la fulin karo oo aan ku abuurnay PowerShell oo soo saara geedka galka sida faylka Excel iyo sida faylka CSV .

1. U dhoofi qaab dhismeedka galka faylka qoraalka, adoo isticmaalaya amarka " Tree " ee Command Prompt

Waxa ugu horreeya waa inaad furto File Explorer^{(open File Explorer)} oo aad u gudubto galka aad rabto inaad u dhoofiso geedka hagaha. Xaaladeena, taasi waxay noqon doontaa "D: Ciyaaraha."^("D:Games.")

Ku qor cmd ciwaanka File Explorer^{(File Explorer's)} oo tabo Gelida^(Enter) si aad toos ugu furto Command Prompt^{(open the Command Prompt)} galka aad xiisaynayso.

Tusaalaha Command Prompt ayaa furmay, isagoo tilmaamaya galkaaga. Xaaladeena, Command Prompt ayaa la furay iyadoo la adeegsanayo gal "D:Games" . Si aad u dhoofiso qaab-dhismeedka galka, socodsii amarkan: tree /a /f > output.doc .

TALO:^(TIP:) Haddii aadan rabin in geedka tusaha uu ku daro faylal (si kale loo dhigo, ka dhig geedka inuu ku daro faylalka kaliya), ka bood xadka /f amarka (geed / a> output.doc).

Output.doc waa faylka dukumeentiga kaas oo dhammaan geedka hagaha lagu kaydinayo. Waxaad u isticmaali kartaa magac kasta, oo waxaad cayimi kartaa nooc kasta oo fayl ah, ilaa inta uu leeyahay nooca faylka qoraalka ah. Waxaan doorbideynaa isticmaalka Microsoft Word .doc files, laakiin waxaad isticmaali kartaa fayl kasta oo qoraal ah. Tusaale ahaan, waxaad dooran kartaa inaad u soo saarto geedka hagaha faylka .txt fudud ee lagu tafatiro ^(.txt)Notepad . Iyada oo ku xidhan inta faylal iyo faylal ku kaydsan gudaha galkaaga, socodsiinta amarkani waxay qaadan kartaa daqiiqad ama laba.

Hadda waxaad xidhi kartaa degdegga amarka^{(Command Prompt)} , maadaama aadan u baahnayn mar dambe. Ku laabo File Explorer oo u gudub galka aad rabtay inaad u dhoofiso geedka hagaha. Gudaha^(Inside) , waa inaad ka heshaa faylka qoraalka cusub oo leh magaca aad ku qeexday amarka geedka^(tree) . Xaaladeena, faylkan waxaa loo yaqaan Output.doc .

Fur faylka wax soo saarka^(output) oo dhammaan geedka hagaha ayaa ku taxan gudaha. Waxay u egtahay mid wanaagsan, soo maaha?

FIIRO GAAR AH:^(NOTE:) Haddii aad rabto inaad dhoofiso geedka tusaha ee galka ay ku jiraan faylalka nidaamka ama faylalka, waa inaad bilowdo Command Prompt oo leh xuquuqaha maamul ka dibna u gudub galkaaga ^{(navigate to your folder)}Command Prompt laftiisa.

2. U dhoofi qaab-dhismeedka galka faylka Excel ama CSV , adoo isticmaalaya aaladda FolderTree (oo ku salaysan PowerShell )

Hab kale oo fudud oo lagu dhoofin karo qaab-dhismeedka galka gudaha Windows 10 waa in la isticmaalo qalab aan adiga kuu abuurnay, oo loo yaqaan FolderTree . Soo deji adiga oo isticmaalaya xiriirkan^{(using this link)} ama kan dhamaadka qaybtan. Meel ku keydi Windows 10 PC kaaga. Ka dib, u guuri ama koobi u geli galka aad rabto inaad hesho qaabka geedka. Galkaas, double-guji ama laba jeer taabo FolderTree executable.

Markaad bilowdo FolderTree markii ugu horeysay, shaandhada SmartScreen waxay^{(SmartScreen filter)} kaaga digaysaa inay tahay abka aan la aqoonsanayn. Taasi waa sababta oo ah ma jiraan dad badan oo soo dejinaya oo isticmaalaya. Qaado eraygayaga in uu badbaado yahay oo aanu waxyeello u geysanayn PC-gaaga. Ma aha wax ka badan qoraalka PowerShell oo ku dhex jira fayl la fulin karo iyo is-dhexgal isticmaale oo fudud. Si aad u isticmaasho qalabkan,guji ama taabo "xog dheeraad ah"kabacdina^{("More info")} dooro "Orod si kastaba."^{("Run anyway.")}

Marka FolderTree furmo, waa inaad aragto daaqad yar oo la mid ah kan hoose. Si aad u hesho geedka hagaha galka hadda, riix badhanka "Get folder tree to Excel" .

Qalabka ayaa markaa soo saaraya laba fayl: FolderTree.xlsx iyo FolderTree.csv . Labaduba waxay ka kooban yihiin liiska geedka galka iyo faylasha gudaha tusahaaga hadda.

Intaa waxaa dheer, labada fayl waa inay lahaadaan laba tiir: Hagaha^(Directory) iyo Magaca^(Name) . Hagaha^(Directory) ayaa kuu sheegaya galka, Magacana^(Name) wuxuu kuu sheegayaa faylasha ku jira galkaas.

Hadda waad sii wadi kartaa oo aad ku tafatiri kartaa faylka Excel ama CSV geed galkaaga sidaad rabto. ^(CSV)Haddii aad la kulanto wax arrimo ah qalabkayaga, nagu ogeysii qaybta faallooyinka ee hoose.

Download: FolderTree

Maxaad u rabtay inaad ogaato sida loo dhoofiyo geedka hagaha ee galka?

U Dhoofinta dhammaan qaab dhismeedka geedka hagaha faylka qoraalka si dhakhso ah ayaa loogu sameeyaa Windows . Waxa kaliya ee^(All) aad u baahan tahay waa Command Prompt iyo amarka saxda ah. U Dhoofinta geed hagaha Excel sidoo kale waa sahlan tahay haddii aad isticmaasho aaladdayada FolderTree^(FolderTree) . Kahor intaadan xidhin maqaalkan, noo sheeg sababta aad u rabto inaad abuurto geed galka faylka? Waxay ahayd sababtoo ah waxaad rabtay inaad sameyso liiska faylashaada muusiga? Ma waxay ahayd hawl shaqo la xiriirta? Hoos ka faallooda^(Comment) oo aan ka doodno.

How to export the directory tree of a folder in Windows

Did you ever need to export the entire directory tree from a раrticular folder? Did you need to get a tеxt or Εxcel document that lists all the fіles and folders inside a specifiс folder from your computer іnto a hiеrarchical structure? We had this need when we were tryіng tо creаte a document that was supposed to bе a summаry of all the Word documents аnd Excel spreadѕheets we had storеd inside а folder. It was at that tіme that we asked ourselves a couple of questions. Can you automatically export a folder's structurе to Excel? Is there a DOS tree command that outputs to a file? Can you print a directory tree into an Excel sheet or as a text file? If you want to find out how to export a folder tree, read on:

NOTE: We have two methods that you can use to export a folder's tree. The first one is based on using the Command Prompt and generates the directory tree as a text file. The second relies on an executable file that we created with PowerShell and outputs the folder tree as an Excel file and as a CSV file.

1. Export a folder's structure to a text file, using the "Tree" command in Command Prompt

The first thing is to open File Explorer and navigate to the folder for which you want to export the directory tree. In our case, that would be "D:Games."

Type cmd in File Explorer's address bar and press Enter to open the Command Prompt directly at the folder you are interested in.

A Command Prompt instance is opened, pointing to your folder. In our case, the Command Prompt was opened using the "D:Games" folder. To export the folder's structure, run this command: tree /a /f > output.doc.

TIP: If you don't want the directory tree to include files (in other words, make the tree include only folders), skip the /f parameter from the command (tree /a > output.doc).

Output.doc is the document file in which the entire directory tree is going to be saved. You can use any name for it, and you can specify any file type, as long as it has a text file type. We prefer using Microsoft Word .doc files, but you could use any other text file. For instance, you can choose to output the directory tree to a simple .txt file that's editable with Notepad. Depending on how many folders and files are stored inside your folder, running this command can take a moment or two.

Now you can close the Command Prompt, as you don't need it anymore. Go back to File Explorer and navigate to the folder for which you wanted to export the directory tree. Inside, you should find the new text file with the name you specified in the tree command. In our case, this file is called output.doc.

Open the output file and the entire directory tree is listed inside. It looks good, doesn't it?

NOTE: If you want to export the directory tree of a folder that contains system files or folders, you must launch Command Prompt with administrative rights and then navigate to your folder from the Command Prompt itself.

2. Export a folder's structure to an Excel or CSV file, using our FolderTree tool (based on PowerShell)

Another easy way to export the structure of a folder in Windows 10 is to use a tool that we created for you, called FolderTree. Download it using this link or the one at the end of this section. Save it somewhere on your Windows 10 PC. Then, move or copy it to the folder for which you want to get the tree structure. In that folder, double-click or double-tap on the FolderTree executable.

When you launch FolderTree for the first time, the SmartScreen filter warns you that it is an unrecognized app. That's because there are not that many people downloading and using it. Take our word that it's safe and does not harm your PC. It is nothing more than a PowerShell script inside an executable file and a simple user interface. To be able to use this tool, click or tap on "More info" and then choose to "Run anyway."

When FolderTree opens, you should see a small window like the one below. To get the directory tree of the current folder, push the "Get folder tree to Excel" button.

The tool then outputs two files: FolderTree.xlsx and FolderTree.csv. Both contain the tree list of folders and files inside your current directory.

Furthermore, both files should have two columns: Directory and Name. Directory tells you the folder, and Name tells you the files in that folder.

Now you can go ahead and edit the Excel or CSV file with your folder tree as you want. If you encounter any issues with our tool, let us know in the comments section below.

Download: FolderTree

Why did you want to know how to export the directory tree of a folder?

Exporting the entire directory tree structure to a text file is quickly done in Windows. All you need is the Command Prompt and the right command. Exporting a directory tree to Excel is also easy if you use our FolderTree tool. Before closing this article, tell us why you wanted to create a file folder tree? Was it because you wanted to make a list of your music files? Was it for a work-related task? Comment below and let's discuss.

Related posts

• Sida hal mar loo sameeyo faylal badan -

• Sida loo tiriyo faylasha ku jira galka iyadoo la isticmaalayo PowerShell, CMD, ama File Explorer

• Sida loogu kala beddelo CMD iyo PowerShell gudaha Terminalka Windows

• Waa maxay Terminalka Daaqadaha? -

• Modelkeeygu waa Windows 10 PC, Laptop, ama tablet? 8 siyaabood oo lagu ogaado -

• 3 siyaabood oo loogu badalo cinwaanka IP-ga gudaha Windows 10

• 5 Waxyaabo madadaalo & Geeky ah oo aad la samayn karto Macmiilka Telnet

• Sida loo beddelo qaab-dhismeedka galka gudaha Windows 10's File Explorer

• Sida loo beddelo icon folder gudaha Windows 10 3 tillaabo fudud

• Jidadka gaaban ee UEFI BIOS & Windows 10 ee Deegaanka Soo kabashada

• Degdeg deg deg ah: 11 amarrada aasaasiga ah ee ay tahay inaad ogaato (cd, dir, mkdir, iwm.)

• Sida loo isticmaalo Command Prompt si aad u xalliso arimaha diiwaanka boot ee PC gaaga

• Ogow goorta Windows la rakibay. Waa maxay taariikhda la rakibay ee asalka ah?

• Sida loo isticmaalo aragtida File Explorer gudaha Windows 10 sida pro -

• Sida Loo Hagaajiyo Faylasha Daaqadaha ee maqan ama la musuqmaasuqo ee ka yimaadda amarka amarka

• Waa maxay PowerShell gudaha Windows, maxaadse ku samayn kartaa?

• Sida loo maamulo amarrada File Explorer gudaha Windows 10 -

• Sida loo beddelo dhammaan faylasha ku jira galka gudaha Windows 10

• Command Prompt (CMD) - 8 amarro shabakad oo ay tahay inaad ogaato

• Sida loo rakibo oo loogu isticmaalo macmiilka Telnet gudaha Windows