Change Data Type: Convert A Column

Modified on Fri, 26 Apr at 8:33 AM

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 one data type on import, but you want to transform the data to work with it in a different way. For example, a column of numeric data may have had one text character entered somewhere and consequently Gigasheet identified the entire column as text data. You can easily convert the entire column to numeric data using the Change Data function. 

The Change Data Type function can be located in the column menu (shown below) or via the Fx functions menu. Continue reading for special notes on how this capability works, and how to undo this action.

When you execute the Change Data Type function Gigasheet creates a new column with the specified data type, and hides your original column. 

Need to undo your conversion? Simply delete the new column and un-hide the original. You can manage column visibility in the right panel. Simply check or un-check any column to toggle it's visibility in your sheet.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article