How To

Search File Contents

Gigasheet helps individuals and teams quickly analyze massive, varying data sets without lengthy setup and complicated configuration. Searching data is as easy as searching the internet. Type in the search terms and go! Or, use the more advanced Regular Expression (regex) search.

The Find in File feature allows you to search for matching text across all rows and columns in your sheet. As you type, Gigasheet begins searching your file. The animated dots indicate the search is still working, and once complete you'll see a count of the number of matches found. Use the up and down arrow icons to jump to each match sequentially.

Sample Search in Gigasheet

Within the Find in File box, you can use regular expressions (regex) to perform wildcard matching, search for complex patterns, and a whole lot more. Gigasheet supports RE2 for regular expressions. To toggle on regex search, click the sliders icon within the Find in File box.

If you're new to regex, see helpful links in the Resources section. Regex makes the search box very powerful! In this example, Gigasheet is looking for a "10" followed by a "0" or a ":".

Regex search in Gigasheet

Similar posts

No items found.

Thousands of individuals & teams use Gigasheet.

Join Them.
No Code
No Database
No Credit Card
Sign Up Today, Free Forever

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.