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.
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 ":".