The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Exporting file list to Excel or TXT Files

    Discussion in 'Windows OS and Software' started by hendra, Nov 15, 2009.

  1. hendra

    hendra Notebook Virtuoso

    Reputations:
    157
    Messages:
    2,020
    Likes Received:
    6
    Trophy Points:
    56
    Which program that I can use to export file list in Windows Explorer to a Microsoft Excel File or to a simple TXT File?
    For example: let's say that I have the following files in c:\vacation directory:
    NY Vacation.zip
    LA Vacation.zip
    VA Vacation.zip

    I want to automatically copy and paste the file names to a txt file or to an Excel file.
    How do I do that?
     
    hendra, Nov 15, 2009
    #1
  2. goofball

    goofball Notebook Deity

    Reputations:
    358
    Messages:
    1,710
    Likes Received:
    0
    Trophy Points:
    55
    Dir C:\vacation\*.zip > C:\nameoffile.txt

    To append, use >>
    edit the last part to represent the name of the file you want it to be, and the location.
     
    goofball, Nov 15, 2009
    #2
  3. BrandonSi

    BrandonSi Notebook Savant

    Reputations:
    571
    Messages:
    1,444
    Likes Received:
    0
    Trophy Points:
    55
    You would probably want to use the /b option with the dir command to avoid getting the file and date information, other than that goofball is corrrect.
     
    BrandonSi, Nov 15, 2009
    #3
  4. hendra

    hendra Notebook Virtuoso

    Reputations:
    157
    Messages:
    2,020
    Likes Received:
    6
    Trophy Points:
    56
    Thanks so much guys :) . I didn't know that it's going to be that simple :eek:
     
    hendra, Nov 15, 2009
    #4
  5. surfasb

    surfasb Titles Shmm-itles

    Reputations:
    2,637
    Messages:
    6,370
    Likes Received:
    0
    Trophy Points:
    205
    Good ol DOS commands.
     
    surfasb, Nov 15, 2009
    #5