How To

Filter Data

Gigasheet helps individuals and teams quickly analyze massive, varying data sets without lengthy setup and complicated configuration. Filters allow you to build complex, SQL like queries without any special syntax.

Filters can be stacked to cover multiple inclusions and exclusions. Choose AND and OR functions to create nested queries. When you filter your data set, only the matching rows will be displayed, and exportable. By default, filters are case sensitive.

The filter menu can be accessed via the Filter icon underneath the file name, or by clicking on a column name and choosing "Filter" from the menu.

Accessing filters by clicking on a column name will pre-populate that column into the filter list.

Similar posts

How TO

Enrich Data

Gigasheet enrichments allow users to add additional context to their uploaded data sets. Enrichments are currently focused on Cyber Security, but others are in development.
How TO

Create a Pivot Table With Big Data

Creating a pivot table is easy in Gigasheet. Simply click the Pivot Mode toggle and then start slicing and dicing your data by dragging the fields into the Row, Column, and Sum of Values boxes.
How TO

Do Math in Gigasheet

Spreadsheets are for calculations. Here's how to perform math operations across columns or in a column or group.

130,000+ people use Gigasheet.

Self-service analytics for huge files, databases, warehouses and more.
No Code
No Training
No Install
See it in action

Webinar: No-Code Exploratory Data Analysis in Snowflake
‍Tuesday, October 29th @ 1PM EST

REGISTER HERE
G2 Star rating logoCapterra 5 Star rating badgeSource Forge Logo - Light VersionSOC 2 Type 2 logo
© 2024 Gigasheet, INC. PATENTED

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.

I understand