Spreadsheet in the Front,
Big Data in the Rear
All the great parts of a spreadsheet, but supercharged to handle whatever data you throw at it.
Aggregations
Gigasheet Aggregations make it easy to quickly calculate summary statistics for a given column without requiring you to learn any special formula syntax.
Filters
Gigasheet Filters allow you to build complex queries. Users can created nested queries using AND/OR, filter by time or even wildcard and regex matching.
Formulas
All your favorites, just as you would expect, but at scale. With Gigasheet's formulas you apply the operation to every row within the sheet based on the column chosen.
Group
Gigasheet Group provide similar functionality to traditional pivot tables, but are easier to navigate. Group organizes rows by a specified categorical column, and collapses rows that meet the specified criteria.
If...
Easily test a condition and perform a specific action based on the result. With Gigasheet's If function you can check whether a condition is true or false and then return a value or perform an action based on that result.
Sheet Assistant
Gigasheet's Sheet Assistant intelligently performs analysis on your data based on your requests. Simply ask your questions, and Sheet Assistant will filter, group, and aggregate your data, presenting you with meaningful insights. Data analysis now is as easy as having a conversation.
Cross File VLookup
Join data across sheets. You can't have a spreadsheet without VLOOKUP!
Data Connectors
Add 3rd party data from built in or external APIs without writing code
Enrichments
Add 3rd party data from built in or external APIs without writing code
Live URL BI & Spreadsheets
Easily feed data to outside tools with Gigasheet's Live URL for BI & Spreadsheets. Data automatically refreshes for continuous updates, reflecting a live view. All it takes is just one-click to enable the live URL functionality. Learn more by reading our support documentation.
Gigasheet API
The Gigasheet API allows you and your team to connect with external data sources, such as web-based services, databases, and other applications. Learn more about the Gigasheet API.
Comments
Comments in Gigasheet serve as a valuable feature that allows users to add explanatory notes or annotations to cells, formulas, or entire worksheets.
Publish to Web
Gigasheet's Publish to Web feature empowers users to embed a sheet so it can be viewed on a external platform. Any changes made to the original file are immediately reflected in the embedded view, without the need to update the link or embed code.
Shared Files
Allow your team or public access to your data! Gigasheet empowers users to share the sheets with who they want and how they want, no restrictions.
Shared Workspace
Team accounts support a shared workspace allowing an organization to more easily collaborate. Only available with a Business Plan.
Sheet History
Sheet history is an overview of the changes made to a sheet over time. Accessible via the File menu sheet history provides insight into what team member made which changes, and when. Only available with a Business Plan.
Convert a Column
Gigasheet allows users to easily convert the data type of any column. This comes in handy when a single column may have been incorrectly identified as one data type on import, but you want to transform the data to work with it in a different way.
Combine Columns
Gigasheet allows users to easily combine or merge many columns into a singular column. For example, you may have dates split out in day, month, year and would like to combine it into one singular column.
Find & Replace
Quickly eliminate pesky data problems with Gigasheet's Find and Replace. A handy tool that helps you find specific words, numbers, or even symbols in your worksheet. It's like having a detective power to search for something and change it throughout your whole document with just a few clicks!
Remove Duplicates
Someone always brings a dupe to the party
Split Columns
Split on delimiters, or add your own!
The ease of a spreadsheet.
The power a data warehouse.
