top of page
horizontal lines
Gigasheet Primary logo
  • 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.

5 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:

Graphs in Gigasheet

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.

UTC times, a standard date, and a UNIX timestamp

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

Perfectly Formatted Dates

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:

Explode Date Function Output