This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
![](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)
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.
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.
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.
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)
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.
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?
I worked but how can I sort the results by number?
Example:
file1.mp3
file2.mp3
file3.mp3
The current result is:
file1.mp3
file10.mp3
file100.mp3
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
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 name
Then sort by the number fields
Then you have to put the files back together again
Use Excel Formula Concatenate
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.
