Change data type

Change data type

Zoho DataPrep automatically identifies the data type of each column in your dataset during the time of import.

Sometimes due to multiple errors in the dataset, DataPrep may not correctly identify the data type, in which case you can manually override to change the data type of the column using the Change data type option.

To change the data type of a column

1. Right-click the column name and select the Change data type option from the context menu. 
2. The dropdown in the Operations panel shows a list of datatypes with match accuracy.

Match accuracy is the percentage of data volume in the selected column that conforms to a data type.

3. DataPrep supports the following data types:
  1. Text
  2. Number
  3. Decimal
  4. Timestamp
  5. Positive number
  6. Date
  7. Date time
  8. Currency
  9. Length
  10. Temperature
  11. Boolean
  12. Email
  13. URL
  14. List
  15. Map
  16. Percentage 
4. Choose a datatype from the listed types and click Apply.

If you select the date or date-time types

You can select the required tiles and construct the date or the date time format. 

1. Click to select the different date and time components to build your custom format.

2. You can choose 24-Hour format by selecting the hour-format icon which would appear at the right end when you hover your mouse over the text box.

3. You can click on the grip portion of the tile (grip icon that appears on hovering your mouse over) and move around the tiles to rearrange them.
4. A live preview of your date column is shown as you build your format.

The date or the date time format constructed is invalid if one or more of the following conditions are not met:
  1. You have to choose at least one tile from the Day, Month, and Year tiles.
  2. You can use the characters, 'Z' and 'T' only once in a date-time format.
  3. The tiles that follow the character, 'T' must be related to time such as Hours, Mins, Sec.
  4. A date-time format must contain an Hours tile.
  5. In a date-time format, you can use either the character, 'Z ' or any one of the tiles.
  6. You can choose only one format from the Day, Month, Year, Hours, Mins, and Sec tiles.
DataPrep allows only the following delimiters while constructing a date or a date-time format.

List of delimiters 
/ : - , . \s T Z

Note: \s denotes a single whitespace. Please provide an actual space when you provide the input. 

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now

              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                Zoho SalesIQ Resources

                    Zoho TeamInbox Resources

                              Zoho DataPrep Resources

                                Zoho DataPrep Demo

                                Get a personalized demo or POC

                                REGISTER NOW

                                  Design. Discuss. Deliver.

                                  Create visually engaging stories with Zoho Show.

                                  Get Started Now

                                                        • Related Articles

                                                        • Creating custom data type

                                                          Custom data types are used to validate organization-specific data, such as employee ID, invoice ID, shipment tracking ID, or asset ID. By creating a custom data type, you can set a standard for your organization-specific columns in your data. This ...
                                                        • Custom data type

                                                          The Custom data type page lists all the custom data types created by the user across all the datasets in DataPrep. You can view the data type name, the data type, visibility, and how many datasets it is used in. You can also choose to edit, delete or ...
                                                        • Export data to cloud databases

                                                          You can export data to the following cloud databases. Amazon RDS - MySQL Amazon RDS - MS SQL Server Amazon RDS - Oracle Amazon RDS - PostgreSQL Amazon RDS - Maria DB Amazon RDS - Amazon Aurora MySQL Amazon RDS - Amazon Aurora PostgreSQL Amazon ...
                                                        • Import data using saved data connections

                                                          DataPrep saves your data connections to avoid hassles in keying them often. To access your saved data connections:  1. Click Saved data connections from the Choose a data source box while creating a new dataset.  2. Manage your saved data connections ...
                                                        • Import data from URLs

                                                          You can enter the URL to a CSV, TSV, JSON, HTML, XLS, XLSX or XML file. DataPrep also supports URL imports that require authentication.  To import files from URLs 1. Click URL from the Choose a data source box while creating a new dataset.  2. Enter ...



                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                        CRM Tips

                                                        Make the most of Zoho CRM with these useful tips.

                                                          Zoho Show Resources