• 0

How to search all excel files for a keyword ?


Question

6 answers to this question

Recommended Posts

  • 0
  On 27/05/2013 at 11:24, jakem1 said:

Windows Explorer. If you're using Vista or higher you will need to index the locations you want to search.

windows 7.Enterprise.

How do I tell windows explorer to filter only excel files and search a specific keyword ?

Can you please tell me the steps ?

  On 27/05/2013 at 11:46, nik louch said:

I would use win grep - specify filetype, location and words

I am getting multiple matches for this tool in google. Can you please tell me which one to download ?

  • 0

which version of excel files?

version 97-2003 (.xls) can be searched directly as the content is not compressed, you can use program like SearchMyFiles from Nirsoft

version 2007-... you need program that can search within .zip files, as .xlsx really are .zip file.

EDIT: yeah wingrep can do this as its support searching within .zip files.

  • 0
  On 27/05/2013 at 11:48, Deep_Level_Shark said:

windows 7.Enterprise.

How do I tell windows explorer to filter only excel files and search a specific keyword ?

Can you please tell me the steps ?

Run through these steps first to ensure that Explorer searches file contents:

http://www.wikihow.com/Make-Windows-7-Search-File-Contents

Then in the search box type kind:spreadsheet followed by the text you want to search for. For instance, kind:spreadsheet income will find all spreadsheets containing the word income.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Amazon Deal: Sony 65 inch 4K Bravia 5 2025 Mini LED TV with Dolby Vision/Atmos is $200 off by Sayan Sen Recently, we covered soundbar home theatre deals from Samsung and JBL for under $1000. Those are still selling for their best prices and you can check them out in their respective articles linked above. Obviously, for a home theatre, you also need a display, and depending on the kind of setup and room you have, you could choose a fairly premium projector like Valerion's StreamMaster Plus2 4K that is currently $300 off on Amazon US, or you could look for a TV. If you are looking for something for under $1500 then Sony has a great deal at the moment. The company's Bravia 5 mini LED 65-inch TV is on sale for $1298 thanks to a $200 discount (purchase link under the specs list below). Mini LEDs, unlike LEDs, promise much better precision in terms of backlighting which should lead to better contrasts with deeper blacks and brighter whites without being overblown either way. The full specs of the Bravia 5 are given below: Display Resolution: 3840 x 2160 (4K UHD) Panel Type: LCD with Mini LED backlight Backlight Dimming: XR Backlight Master Drive with local dimming for enhanced contrast Panel Refresh Rate: 120 Hz HDR Compatibility: Supports HDR10, HLG, and Dolby Vision Color & Image Processing: XR Triluminos Pro™ with Live Color™ technology, XR Clear Image, and XR Motion Clarity™ Connectivity & Ports: HDMI Inputs: 4 side-mounted (supports HDMI 2.1 features including 4K at 120Hz, eARC, VRR, ALLM, and SBTM) HDCP: Version 2.3 on all HDMI ports USB Ports: 2 side ports (supports FAT16, FAT32, exFAT, and NTFS formats) Other Ports: RS-232C Input: 1 (side) Digital Audio Output: 1 (side) RF (Terrestrial/Cable) Input: 1 (side) LAN Input: 1 (side) Wireless & Smart Features: Wi‑Fi: Dual‑band (2.4 GHz/5 GHz) with support for Wi‑Fi Certified 802.11 and Wi‑Fi 6 Bluetooth: Version 5.3 (compatible with A2DP, HID, HOGP, SPP, and AVRCP) Built‑in Chromecast: Yes Operating Platform: Google TV Smart Connectivity: Features BRAVIA Sync (with HDMI‑CEC), Apple HomeKit, and Apple AirPlay Get it at the link below: Sony BRAVIA 5 65 Inch TV, Mini LED, 4K120hz Television with Dolby Vision/Atmos, Exclusive Features for PlayStation®5, K-65XR50, 2025 Model: $1298.00 (Shipped and Sold by Amazon US) This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • At the end of the day, there isn't a lot of incentive for Android tablets. I have one, but only because I am a developer and didn't want a phone and the price was right.
    • Tablet numbers have been declining for years. The iPad is the exception to the rule, because it has some niche audiences, otherwise consumers are releasing they are generally not what they need
  • Recent Achievements

    • Explorer
      Case_f went up a rank
      Explorer
    • Conversation Starter
      Jamie Smith earned a badge
      Conversation Starter
    • First Post
      NeoToad777 earned a badge
      First Post
    • Week One Done
      JoeV earned a badge
      Week One Done
    • One Month Later
      VAT Services in UAE earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      523
    2. 2
      ATLien_0
      231
    3. 3
      +FloatingFatMan
      150
    4. 4
      +Edouard
      142
    5. 5
      Michael Scrip
      109
  • Tell a friend

    Love Neowin? Tell a friend!