Clean and format data
Last updated
Last updated
This function will simply remove all extra rows that have the same value in each cell. Only one duplicate row will be preserved.
This function will change the text casing of all values of the selected range.
Data range: Select the data range. A range represents a single cell or a group of adjacent cells in your spreadsheet. For example, A1:D10 is shown below.
Case type: Select the desired case type from the list. Currently we support the following types:
Upper case (THIS IS UPPERCASE
Lower case (this is lower case)
Proper case (This Is Proper Case)
Sentence case (This is sentence case)
Upper camel case, or pascal case (ThisIsUpperCamelCase)
Lower camel case (thisIsLowerCamelCase)
Train case (This-Is-Train-Case)
Snake case (this_is_snake_case)
Kebab case (this-is-kebab-case)
This function will round all numbers to the nearest integers.
Data range: Select the data range. A range represents a single cell or a group of adjacent cells in your spreadsheet. For example, A1:D10 is shown below.
This function allows you to clean data in the selected range. For example, you can remove all punctuations from text values.
Data range: Select the data range. A range represents a single cell or a group of adjacent cells in your spreadsheet. For example, A1:D10 is shown below.
Option: How do you want your data to be clean? We support the following types:
Remove lead spaces. This will remove leading spaces from all cells in the selected range.
Remove trailing spaces. This will remove trailing spaces from all cells in the selected range.
Remove all non-numbers. This will remove all values that are not numbers from all cells in the selected range. For example: “He is 30 years old.” will become “30”.
Remove all numbers: This will remove all values that are numbers from all cells in the selected range. For example: “He is 30 years old.” will become “He is 30 years old.”.
Remove all punctuations. This will remove all punctuations from all cells in the selected range. For example: “He is 30 years old, isn’t he?” will become “He is 30 years old isnt he”.
This function will transform a pivot table into raw data. Read more here.
Data range: Select the data range. A range represents a single cell or a group of adjacent cells in your spreadsheet. For example, A1:D10 is shown below.
This function will convert epoch time/UNIX timestamps into the UTC time. This is useful when you have retrieved a column of timestamps from an API endpoint that uses the UNIX timestamp.
Data range: Select the data range. A range represents a single cell or a group of adjacent cells in your spreadsheet. Only one column each execution is allowed.
