How To Search Text In Multiple Excel Files Quickly

Contents

4.8
(23)

Working with big Excel spreadsheets never have been easy, especially when you need to search for a piece of text in a file that have thousands, even ten of thousands rows. Searching through a single file can cost you hours, if not days if you work on a slow computer. To make the matter worse, sometimes you need to search in multiple files and search for multiple strings.

Let me give you an example.

I have a imaginary store that sells auto parts. My store has over 400,000 items and they are in two separated files. Opening it on an old computer is problematic. 

search text in multiple excel files

Now, for example, I want to search for parts that contain the text “SPLS” for some reasons. If I go with the traditional way, I would press control + F (or Command + F on a Mac) to start searching. To be very honest with you, looking for results from thousands or million in my case is not an easy task.

To make the problem worse, what if I want to search for multiple text, not just one? What if you need to search for multiple text in MULTIPLE files? Excel only provides us one search box and you can search for one string of text at a time.

Are we out of luck? Is there any better way to search for:

  • Multiple text
  • In multiple Excel files

Search Text In Multiple Excel Files Using Software

Luckily, there is a better way to do this boring task, which is using a pieces of software made exactly to do this task.

Let’s have a look at the software and how it works.

As you can see, this is the software that solves the searching problem in big excel files. You see its true value when you have many files to search and many text to find. Also, the larger the files, the more time the software can save you.

This is the way this software work step by step:

  1. You select the file or files you need to search by clicking on add excel files button at the top left of the panel. You can select multiple excel files using this button.
  2. Then, enter the text you want to search in these files, you need to enter one search per line. There is no limit.
  3. Click on start searching

It takes some time for the software to go through the files and find the text you want to find. As you can guess, the bigger the files, the longer it takes to find all matches. However, in comparison to a human, the software is much quicker, by hundreds times.

You may wonder, is this for Windows only? Good news is Excel Ultimate Search works perfectly on Windows, Mac, and Linux (Ubuntu, Fedora, Centos…)

excel-ultimate-search-works-on-windows-linux-macos

Download Excel Ultimate Search

Download the app now to get instant access!

How To Search Text In Multiple Excel Files Quickly 1
How To Search Text In Multiple Excel Files Quickly 2

Click on a star to rate it!

Average rating 4.8 / 5. Vote count: 23

No votes so far! Be the first to rate this post.


25 thoughts on “How To Search Text In Multiple Excel Files Quickly

  1. I have a “few” files that are rather simple in terms of content, but was wondering how I would then go about searching for only the number 401 and not get results with eg. 5410 or 98401, but ONLY the actual value of 401.

  2. Helllo binarycarpenter, very nice tool. Thumbs up! Do you thin it is possible to search multiple spreadsheets for a result? For example: 188,50 (result of calculation =A1+D1)

  3. How does one obtain such a tool as your Excel Search utility? I’ve been poke around your site and do not see how.

    Thanks,
    Jon

  4. I tried to add a file with extension xlsm and it looks thats not possible?
    I use a lot of macros in my xls files …

    1. Currently it supports .xlsx, .xls only. I’m going to add support for other excel files in the next version.

  5. Hello, Pay pal is not working in Pakistan , kindly let us know some other way of payment which you can acceptable, like western union, etc. And is there any discount if we buy more than one .

    Good day

    Regards,

  6. I download the zip. I download JRE but the software is still not opening. It just opens in Winzip and there’s no files that’s executalbe? What’s wrong?

  7. Does the Pro Version remember the files or folder selected for the previous search (separate execution), or must they be selected again? Are the the Results Column Widths remembered from the previous search session, or do the adjustments to Column Widths need to be made again? Saving this information from search session to search session will likely save time for most users.

Leave a Reply

Your email address will not be published. Required fields are marked *