9,622 questions
Hello,
open an elevated CMD prompt.
Change directory to the folder with the MP3 files
run: Dir *.MP3 /B >files.txt
open files.txt and copy into Excel.
How to export file's names to an excel file?
Amin2234
211
Reputation points
Hi,
I have 1000 mp3 files and want to export the file's name to an excel file.
Each name should be placed in a one cel.
Microsoft 365 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Excel For business Windows
3,887 questions
Windows for business Windows Client for IT Pros User experience Other
Accepted answer
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 27%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Darrell Gorter 2,731 Reputation points2022-01-18T21:47:46.553+00:00 -
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2022-01-19T01:31:27.247+00:00 Hi @Amin2234 ,
Just checking in to see if the information of Dgorter was helpful. Please let us know if you would like further assistance. If you think ther reply is helpful, I suggest you accept it as answer. Other partners who read the forums with the same issue can get more information from the correct result.
Thank you. -
Amin2234 211 Reputation points
2022-01-20T13:53:08.283+00:00 I must copy each name into a separate cell, in your scenario if I copy them it copy all names in one cell.
Each name should be in one cell.
-
Darrell Gorter 2,731 Reputation points
2022-01-20T19:48:47.847+00:00 Hello,
When I did this all the file names were in their own cell. They were not in separate colums like your screen shot shows, I had one list of file names in the first column of Excel.
when you capture the list in the text file does it show as a list or is all on one line?Thanks,
Darrell -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 5%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gary Agoura 206 Reputation points2022-01-20T21:10:55.987+00:00 I just tried to copy all the file names from one directory into Excel and it worked like a champ. I created a file called files.txt. I ran the DOS command: dir . /D > files.txt. Then I opened the files.txt using Notepad. Did a CTRL-A, CTRL-C to copy everything to clipboard.
Brought up excel, placed cursor in the first cell, then CTRL-V. Each file had it's own cell. I am using Office 365.
Just noticed that the above command didn't show the STARs before and after the dot. (Should be dir STAR.STAR /D > FILES.TXT ) The /D option copies only the file name.
-
Darrell Gorter 2,731 Reputation points
2022-01-21T15:44:02.693+00:00 Hello,
He referenced MP3 file thus the *.MP3 rather than 8.8. Not sure if there were any other files in the folder.
The /B should be the option to only display the filename. The /D shows a list in multiple columns, how many files were in your folder? -
Amin2234 211 Reputation points
2022-01-22T19:24:55.78+00:00 I worked but how can I sort the results by number?
Example:
file1.mp3
file2.mp3
file3.mp3The current result is:
file1.mp3
file10.mp3
file100.mp3 -
Amin2234 211 Reputation points
2022-01-22T19:27:06.067+00:00 there some additional star in my message, ignore them (I wanted to use as bold)
file*1.mp3 => file1.mp3
file2.mp3 => file2.mp3
file3*.mp3 => file3.mp3 -
Darrell Gorter 2,731 Reputation points
2022-01-22T21:21:16.547+00:00 Hello,
That would fairly complex, I am not sure how to do that,
Do all the filenames have the same number of Alphabetical characters before the number.
You would have to do this in Excel, separate out the text from the numbers something like this.Here are a couple of steps that you can try to play around with to get this working.
Split Characters and Number from a nameThen sort by the number fields
Then you have to put the files back together again
Use Excel Formula Concatenate -
Gary Agoura 206 Reputation points
2022-01-22T21:25:22.553+00:00 I was just copying files to see if each line would go into a separate cell, which it did. I should have used the /B option but wasn't thinking about that when I did my test. Thanks for the update.
Sign in to comment -