Export data as files

Export data as files

You can export your data in various file formats which includes CSV, TSV, JSON, XLS, XLSX and XML formats. 

To export data click the Export now option from the top bar in the Operations page. 

Select Files from the options in the side pane.

If your data contains columns with personal data, you can choose which columns need to be exported from the PII columns section.

  1. You can choose to save the exported data as a local file in any of the supported file formats: CSV, TSV, JSON, XLS, XLSX and XML formats.  
  1. Use the Compress file option to save your export as a .zip file.
  1. You can encode the file using character encoding methods like UTF-8.
  1. You can also encrypt the file and protect it with a password. 
Once you input the required values, click Export.

    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

                                                          • Export options

                                                            DataPrep offers a wide range of export options. Your data can be exported to BI tools, cloud storage services, cloud databases. They can also be downloaded as files in different formats. To export your dataset 1. Click on the Export icon in the top ...
                                                          • 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 ...
                                                          • Scheduling data export

                                                            You can schedule data export using different export configurations in DataPrep. To schedule data export: Click Export from the top bar in the Operations page and select Schedule export.        2. Click the New schedule button to create a new schedule ...
                                                          • Export data to Zoho Analytics

                                                            You can export the refined data to data analytics tools such as Zoho Analytics. To export data to Zoho Analytics 1. Click the Export button from the top bar in the Studio page. 2. Select Zoho Analytics from the export menu in the side pane. 3. You ...
                                                          • Prepared data

                                                            Whenever a dataset export is done, a copy of the exported data is stored in DataPrep as prepared data for audit purposes. You can export prepared data as files.  To access prepared data in DataPrep  1. Click the numbered link against the Prepared ...



                                                          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