How to Copy 1737 Folder’s Name Into Excel Easily

How to Copy 1737 Folder’s Name Into Excel Easily

I have about 1700 folder’s name that I need to show in Excel. When I have less than 10 folders name I don’t mine copy it one by one into the Excel spreadsheet.

This is something else I cannot copy one by one 1737 folder names into the spreadsheet.

So this is what I did and it saves me a lot of time ๐Ÿ™‚
1. Run CMD command, click the search button, type CMD

How to Copy 1737 Folder's Name Into Excel Easily 1
2. Go the parent of folder you want to list, CD folder name
How to Copy 1737 Folder's Name Into Excel Easily 2
3. Type dir > foldernames.txt and press enter. Seems nothing happen but it actually created a file called foldernems.txt contain my 1737 folders name
How to Copy 1737 Folder's Name Into Excel Easily 3
4. You just need to open it from Excel and saves a lot of time doing it manually.
How to Copy 1737 Folder's Name Into Excel Easily 4
READ  TP-Link AC1200 Gigabit WiFi Router (Archer A6) - 5GHz Gigabit Dual Band MU-MIMO Wireless Internet Router, Supports Beamforming, Guest WiFi and AP mode, Long Range Coverage by 4 Antennas

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!