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

Discus and support How can I export a detail file listing from Windows Explorer to Excel? in Microsoft Office and 365 to solve the problem; Hello everyone. I'm new here, and I want to thank you in advance for your help*Smile Is there a way for me to copy/export from Windows Explorer to... Discussion in 'Microsoft Office and 365' started by myemerald, Dec 28, 2018.

  1. myemerald Win User

    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*Smile

    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!

    :)
     
    myemerald, Dec 28, 2018
    #1
  2. ddelo Win User

    Export All Administrative Events to Excel


    To analyze events, from the Windows Event Viewer, there is a simple way to export all Administrative Events to Excel, with PowerShell.

    Exporting all Administrative Events to Excel is a simple two Step process, as described here:

    Step 1 - Create the Administrative Events View .xml file
    1. Open Eventviewer (%windir%\system32\eventvwr.msc)
    2. Navigate to: Event Viewer (Local) > Custom Views > Administrative Events
    3. In the “Actions” pane select “Filter Current Custom View”.
    4. Select the the XML tab.
    5. Press Ctrl+A to select all the XML code of the Custom View.
    6. Open a notepad, paste the selected code and save the file to your Desktop as AdmEvtView.xml


    Step 2 - Create the csv file with the events
    1. Download the ExportEvtCSV.zip file, which contains the script ExportEvtCSV.ps1 and unzip it, on your Desktop.
      It's not a fancy script, just basic PowerShell commands to create a csv file on the Desktop.
    2. In Windows Search, type “ISE” (without the quotes) to open “Windows PowerShell ISE” and Run as administrator
    3. To allow running the script, change the ExecutionPolicy, for this session. To do that, in the Console pane type:
      Code:
      Code:
      Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass -force
    4. In the Windows PowerShell ISE, open and run the script: ExportEvtCSV.ps1
      The script will create a csv file with a name YYYYMMDD.HHMM.csv on the Desktop
    5. When done, open the newly created .csv file, format the columns as needed and optionally save it as .xlsx, if you wish.
    That’s it! You now have all the Administrative Events in Excel for filtering and further analysis. How can I export a detail file listing from Windows Explorer to Excel? :)

    Now to the more technical hard stuff... *Confused

    There is a reason for running the script from within PowerShell ISE!

    It would be great if everything was also working perfectly, when running the script from an elevated PowerShell too.

    We can run it from an elevated PowerShell, which means that you just follow the Step 1, as above but for the Step 2 instead of the ISE you run the script from an elevated PowerShell.

    The problem is that it will work only for anybody who has en-US format for the dates. Everyone else, who has another format (i.e. en-GB, fr-FR, el-GR etc.), the dates are not translated properly by Excel (although the script uses the –UseCulture switch) and remain as text in the en-US format.

    I'm not sure if this a bug of the "export-csv" cmdlet, but although it runs the way it supposed to from within the ISE, from PowerShell there is a problem with the dates format.
    As I haven’t found a way to overcome this obstacle, any suggestion from the PowerShell gurus of the forum (like my good friend Shawn @Brink, for instance), is welcome.
     
    ddelo, Dec 28, 2018
    #2
  3. Transfer file list with additional info to excel

    It seems to me that the missing items start after ab 24 rows, or after the rows that are visible in the Explorer window. After reading the readme file it is actually how SysExport is supposed to work, only exports the visible lines but not the whole list.
    So I have to make the export separately for each part of 24 rows in the list.

    I suggest Microsoft includes an export list possibility in Explorer at earliest convienence.

    Regards

    Beros
     
    BengtRostedt, Dec 28, 2018
    #3
  4. How can I export a detail file listing from Windows Explorer to Excel?

    Transfer file list with additional info to excel

    I have some picture files in a directory. With Explorer I can list the files and by adding columns like picture size and horizontal resolution this additional data data is displayed.

    How can I transfer the complete list, with the additional columns, to i.e. excel, or .csv?

    Explorer should be amended to contain a meny item "export list" with various options!!

    Best regards,

    Beros
     
    BengtRostedt, Dec 28, 2018
    #4
Thema:

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

Loading...
  1. How can I export a detail file listing from Windows Explorer to Excel? - Similar Threads - export detail file

  2. How can I alphabetically sort the favorites list in the Windows 10 file explorer?

    in Windows 10 Network and Sharing
    How can I alphabetically sort the favorites list in the Windows 10 file explorer?: Hi all, How can I alphabetically sort the favorites list in the Windows 10 file explorer? Thanks! Joan https://answers.microsoft.com/en-us/windows/forum/all/how-can-i-alphabetically-sort-the-favorites-list/80fcdcab-0fa1-475e-8ae4-38cad9cca476"
  3. how can I export file details (e.g., photo dimensions) from file explorer?

    in Windows 10 Network and Sharing
    how can I export file details (e.g., photo dimensions) from file explorer?: In Windows 10 File Explorer details view, I can add any of hundreds of extended file information fields by using the GUI to add the appropriate columns. For instance, I can see the 'dimensions', 'height', 'width' of photos. How can I export that information as text so I can...
  4. Printing of file details from explorer

    in Windows 10 Network and Sharing
    Printing of file details from explorer: I would like to be able to print the medium or large icons with their corresponding details to preview and organize. Is there a way to do so, and if so what is the process? V/R Bill P...
  5. File Explorer List and Details buttons

    in Windows 10 Customization
    File Explorer List and Details buttons: I appreciate being able to customize the buttons on the file explorer toolbar. However, I am constantly switching back and forth between the List and Details view. Is their any way to isolate theses two buttons and place them individually on the toolbar, just like the List...
  6. How to export Calendar records from Windows Mail to Excel

    in Microsoft Office and 365
    How to export Calendar records from Windows Mail to Excel: When Using Calendar Win 10 as part of the Windows mail collective - is there any way to export the Calendar as text or CSV or XL* file . If not where is data held and can I get to repository directly and interrogate it ? Thanks Peter. 94177
  7. How can I force an export to a certain version of Excel?

    in Microsoft Office and 365
    How can I force an export to a certain version of Excel?: I have both Excel 2000 and Excel 2013 on my Windows 10 machine for reasons that don't need enumeration here. I am working with a program now that will export/import to Excel, but it looks like it might work only with Excel 2013. However, when I do the export from the program...
  8. File Explorer displays MP3 details, NOT File Details. How to switch ?

    in Windows 10 Support
    File Explorer displays MP3 details, NOT File Details. How to switch ?: Hello, In Windows 10 using the File Explorer, When I copy/create a new .MP3 file onto my computer it is displaying the .MP3 info. and not general file info. in the File Explorer. Example: It displays "Name, #, Title, Artist, Album" etc. It should be displaying......
  9. How can I "unhide" onedrive from file explorer

    in Windows 10 Support
    How can I "unhide" onedrive from file explorer: I followed Microsoft's suggestion on how to disable one drive and as part of that where it has you hide it I right clicked on the onedrive icon that shows on the left side of file explorer (the navigation pane), chose properties and hid the folder near attributes (the option...
  10. Want to change File Explorer default View from "Details" to "List"

    in Windows 10 Support
    Want to change File Explorer default View from "Details" to "List": Hi all, I have been searching the web for an answer to this question since first getting Windows 10 last year. I would like my File Explorer to open using the "List" view rather than the current default of "Details". I have seen many responses that reference how to change...