How to export file's names to an excel file?

Question

How to export file's names to an excel file?

Amin2234 211

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.

Accepted answer

0 additional answers

Your answer

Answer 1

Darrell Gorter 2,731

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.

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2022-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

@Darrell Gorter

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
Gary Agoura 206 Reputation points

2022-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

@Darrell Gorter

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
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 name

Then 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.

Share via

How to export file's names to an excel file?

0 additional answers

Your answer