How do I copy a list of file names into Excel?
If this is the same question popping in your mind, then you are at the right place.
Also Read: How to Enable Text to Speech On Windows 10.
From the last 2-3 years, I have started backing up my computer files to some external hard drives. To prevent data loss.
And till now I have filled 4-5 hard drives of data.
But it’s really difficult to remember which files are present in which hard drive.
So I started exporting all files names to excel files & keep a record of it.
But it was hell time-consuming. And then I got to know about this trick method of copying filenames from folder in windows explorer.
Let see How it works…
Table of Contents
Copy File Names Into Excel From Folder
This method of creating a list of the contents of a folder as text has helped me a lot in saving my time. Whether they are too long, short or one word it works with all.
Moreover, you can also create a directory of files present in a folder.
So let’s get started.
1. Open Windows Explorer
Open Windows Explorer and navigate to your favorite folder for which you want to create a list of filenames as text.
2. Copy File Names as Text from folder
Now select only those files for which you want to copy file names into excel from the folder.
Now, Press Shift key + Right Click on it. And then select Copy as path Option.
And you have successfully copied files as text and also its location with the file extension.
3. Export Filenames to Excel
Now it turns to export filenames to excel file in windows 10. So, Open your Excel sheet and Press Ctrl+V to paste it properly.
And you can also copy filenames to Notepad as text using this technique.
How do I copy file names into Excel Windows 10?
To copy file names into excel in Windows 10, go to the desired folder, select all files, hold the Shift key & right-click and then click on the Copy as Path option.
How do I copy a list of filenames into Excel?
If you want to copy a list of filenames into excel, just select all the files, hold shift + right-click & then choose Copy as Path option.
How can I copy a list of file names as text?
To copy the list of file names as text, Select the full list > Hold Shift-key + Right-click > Copy as Path and then paste it into a notepad file as text.
How do I copy the names of all files in a folder Windows 10?
Copying the names of all files in a folder using Windows 10 is pretty easy, just press Ctrl+A to select the files, right-click on them while holding the Shift key, and then select the “Copy as Path” from the options.
That’s it for now…
So that’s how you can easily get a list of all files in a folder and subfolders into excel. And you can also follow the same method for Windows 7/8.
Check out the next post on how to copy filenames to excel using cmd.
Feel free to share your thoughts and also tell us if you know any better way to Export or Copy File Names Into Excel From Folder in Windows 10.
If you liked this post, Don’t forget to share this post.