Data Cleanup

Gigasheet Support | Using Gigasheet | Help with Editing Data in Gigasheet, including editing columns, rows, and individual cells

Combine Columns
Use the Combine Columns function to combine the text of two columns: To combine columns in Gigasheet, click Tools > Columns > Combine Columns. Next, ...
Wed, 7 Sep, 2022 at 1:23 PM
Split Column
The Split Column function allows you to slice one column into multiple new columns based on a specified delimiter string.  Access the Split Column funct...
Thu, 26 May, 2022 at 11:17 AM
Change Data Type: Convert A Column
The Change Data Type function allows you to convert the data type of any column. This is helpful when you have a column that was incorrectly identified a on...
Thu, 20 Oct, 2022 at 1:37 PM
Cleanup Unix Time
The Convert Unix Time function converts Unix timestamps or Epoch time to UTC format . You can add an offset of your choice to account for time zone variance...
Thu, 8 Sep, 2022 at 4:37 PM
Explode Date
The Explode Date function automatically splits date-time fields in your sheet to new columns. To use Explode Date, navigate to the Functions (Fx) menu and s...
Thu, 26 May, 2022 at 11:24 AM
Deleting Rows
Deleting Rows is possible individually or by using Filters to delete either the Matching or Excluded Rows. Deleting a Row To delete a single row, se...
Wed, 23 Nov, 2022 at 11:04 AM
Set First Row as Header
Set First Row as Header: Setting the first row as header is a very important and useful function that Gigasheet offers. Using this function sets the first ...
Wed, 20 Jul, 2022 at 11:24 AM
Setting Header as First Row
Set Header as First Row: Using this function sets the header values of the file as the first row of data. Doing so will essentially add a first row to ...
Wed, 23 Nov, 2022 at 10:37 AM
Can I Edit or Rearrange rows?
This support article aims to detail how to navigate and best use rows within Gigasheet.  Editing Rows: For starters, it is not possible to edit rows. O...
Wed, 23 Nov, 2022 at 11:23 AM
Can I edit or delete a column?
Editing Columns: While you can not edit the data within columns directly, you can apply functions to create new ones. For example, if we have two columns c...
Fri, 22 Jul, 2022 at 9:57 AM