Syed Hasan
5 Most Loved Features of Gigasheet
Gigasheet’s been growing by leaps and bounds and we’re lovin’ it! After all, it’s you – spreadsheet lovers – who’ve helped us reach so far. This one’s for all new joiners and Gigasheet pros who want a quick refresher on some of the most loved features of Gigasheet.

We’ve all used Excel one way or another. It’s good until you try opening up a large spreadsheet and it just fails. Gigasheet solves all these problems along with making several other use-cases a lot easier to work with. How do we do it? Here’s an overview of some of the best features of Gigasheet.
Top 5 Features of Gigasheet
1. Graphs
Who doesn’t love a nicely made graph with titles, helpful annotations, and color coding? We sure do! Gigasheet has several options to graph data; using which you can quickly visualize your data without writing a single line of code! Here’s the list:
Column
Bar
Pie/Doughnut
Line
Scatter Plot
Area
Histogram
Combinations – mix and match a few graphs together
Say goodbye to matplotlib, plotly, and all other visualization tools!
Here, I’ve got a dataset of Netflix movie titles and a lot of other attributes. But hey, I don’t have the time to see if there’s a difference in the IMDB and TMDB scores. Say no more – two aggregations, one quick selection, and et voila! A beautiful graph!
Take a look:

2. Date Operations
There are a couple hundred date formats and it’s the absolute worst when a dataset uses a completely random format. If you’re not from a programming background, you might not even consider this – 1655206425 – a date, yet it is! It’s a UNIX timestamp.
Luckily, Gigasheet solves this issue with ease. Take a look at this dataset. We’ve got UTC times, a standard date, and a UNIX timestamp.

As soon as I upload it to Gigasheet, here’s how it looks:

The UNIX timestamp isn’t a nuisance anymore. It’s converted into an easily readable datetime automatically!
No auto-conversions? Don’t fret! Open up the hamburger menu at the top right of your column, select Apply Function, and then select either of:
Explode Date – to break the date into multiple columns
Cleanup UNIX time – to convert UNIX timestamps into readable dates
Split Column – to break the simple date into three columns by using ‘-’ as a separator
Here’s how the results of the Explode Date function look on column C:
