How can I export a list of files located in a file folder to excel or to a text document? Preferably excel.
Thank you,
Tom
Export List of Files in an Explorer Folder
This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.
Report abuse
Details (required):
Thank you.
Reported content has been submitted
Answer
DA
You must have the directory you wish to list on your hard drive(not a network share although a mapped drive may work?
Files should be displayed in the details format within the directory.
1) type cmd into the start menu to bring up a dos prompt
2) use the command (for instance) "cd C:\Users\BobJones\Desktop\New folder" to navigate to the folder in question
3) use the command "DIR > doggy.csv" to create a file named doggy.csv in the same directory that you can open directly with excel. Nothing much looks lik it is happening but you wuill find the small file as expected.
Good Luck!
Files should be displayed in the details format within the directory.
1) type cmd into the start menu to bring up a dos prompt
2) use the command (for instance) "cd C:\Users\BobJones\Desktop\New folder" to navigate to the folder in question
3) use the command "DIR > doggy.csv" to create a file named doggy.csv in the same directory that you can open directly with excel. Nothing much looks lik it is happening but you wuill find the small file as expected.
Good Luck!
Report abuse
Details (required):
Thank you.
Reported content has been submitted
224 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Answer
Hello Tom,
You can simply paste the list into Excel, as follows:
1. Open Windows Explorer and select the source folder in the left pane.
2. Press Ctrl + A to select all items in the right pane.
3. Press and hold the Shift key, then right click on the selection.
4. From the context menu, choose "Copy as Path".
5. Paste the list into Excel.
Doug M. in NJ
Report abuse
Details (required):
Thank you.
Reported content has been submitted
1538 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated May 8, 2024 Views 483,090 Applies to: