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...
Wed, 24 May, 2023 at 2:04 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: You can edit data in columns in two ways:  Editing the Value Applying a Function Editing the Value You can edit cells by double clic...
Tue, 4 Apr, 2023 at 9:34 AM