list only filename from a folder using command prompt

I just need to list the file names in a directory as seen on Windows Explorer and get this command to be used in the command prompt:

dir /b /a-d /o *.*

to move it into spreadsheet: mark and copy from command prompt, and paste…
to filter the extension just modify the wildcard.
hope it help, thanks to my friend Bowo for the idea.