+ Reply to Thread
Results 1 to 2 of 2

Search Results to an Excel Spreadsheet?

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Illinois
    MS-Off Ver
    Microsoft 360
    Posts
    58

    Search Results to an Excel Spreadsheet?

    Is it possible to download search results in Windows 7 to an Excel spreadsheet? I searched for file names that started with a specific alpha character in a specific folder using Windows 7. The results came back with several hundred file names. I'd like to create a spreadsheet with columns for the file name and the sub folder name that contains the file. Is that possible? Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Search Results to an Excel Spreadsheet?

    Hi, yes it is possible. One way is to do the search with the dir-command, and save the result to a text file. Then open the text file in Excel and seaparate columns by the symbol "\".

    1. press the "start button" in win 7, type "cmd" in the search field and press enter. (not the quotation marks).
    2. type the search string and press enter.
    example of a search string that will search for all files beginning With "a" in c:\docoments (and, because of the "/s", also in its sub folders) and save the result to list.txt:
    dir c:\documents a*.* /b /s >list.txt

    3. open list.txt in Excel (seaparate columns by the symbol "\").

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Display search results inluding results that match patrially
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 08:52 AM
  2. Replies: 11
    Last Post: 01-15-2013, 01:49 PM
  3. Search for results in a separate spreadsheet
    By sungsam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2008, 04:35 AM
  4. [SOLVED] Search Spreadsheet - Results in either listbox or new spreadsheet
    By Brandon Johnson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2006, 10:25 AM
  5. Import Folder Search Results in a spreadsheet?
    By Mark B in forum Excel General
    Replies: 1
    Last Post: 04-09-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1