How can I export a detail file listing from Windows Explorer to Excel?


  1. Posts : 2
    Windows 10
       #1

    How can I export a detail file listing from Windows Explorer to Excel?


    Hello everyone. I'm new here, and I want to thank you in advance for your help

    Is there a way for me to copy/export from Windows Explorer to Excel >> A listing of file names, created date & time?
    I am trying to organize a lot of image and video files, and haven't been able to transfer the files from my GoPro to my laptop without the created date changing. I would like help with that, but in the meantime I want to be able to copy all file names/created dates/created time to an Excel spreadsheet so I can sort them in there.

    I tried suggestions in similar posts, but when I get the data to Excel, the date shows up as "General" with AM or PM in a separate column. This makes it impossible for me to sort in chronological order.
    The method I used was going to CMD and typing: dir > dirlist.txt
    I tried dir > dirlist.csv but it brought incorrect date/time info, and split file size into columns...made it difficult to use.

    I also tried selecting all files in the Windows Explorer folder, right click to find copy as path. Copy as path wasn't an option. I suspect it wouldn't give me the date/time info though.

    My goal is to be able to chronologically sort all images and videos from a specific event, and be able to see the date and time the images were captured.

    Thank you again!
      My Computer


  2. Posts : 16,950
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #2

    There is a suggestion about exporting the file data you want in How can I print search results from File Explorer about using an app called everything.

    When I want to copy without changing created date I use the built-in tool RoboCopy. If you search the forum for it there are lots of threads about it. There is also some useful info at RoboCopy - SS64

    Denis
      My Computer


  3. Posts : 2
    Windows 10
    Thread Starter
       #3

    Thank you, Denis. I tried RoboCopy. The problem was that my camera doesn't have a drive letter, so I couldn't transfer that way. I contacted Microsoft and they said only the hard drives have letters.
    I'll look into "Everything". Thanks!
      My Computer


  4. Posts : 9,790
    Mac OS Catalina
       #4

    Here you go. You are looking at Exif metadata, which you cannot export with the default tools of Windows. https://digitalarch.org/blog/2017/4/...2923n0c7zdrryg What EXIF Photo Data Is, How to Find It How to Understand It
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 00:31.
Find Us




Windows 10 Forums