Introduction

The Explode Date function automatically splits date-time fields in your sheet to new columns.

For example, exploding a UTC date-time stamp will result in these new columns:

• Year
• Month
• Day
• Day of Week
• Hour
• Minute
• Seconds
• Time Zone

How to get there

Login to Gigasheet > Select a Sheet > Insert > Explode Date