Export options

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 bar in the Studio page and select Export now

2. The Ruleset which has been applied to the sample data will now be applied to the entire dataset.

3. Next, the data quality results will be shown. You may choose to select the Refine further option and improve the data quality of your dataset. This will take you back to the Studio page where you can work on the data quality of your dataset.


4. Select Continue to export to proceed with exporting your dataset to one of the following export options.
  1. Zoho Analytics
  2. Files
  3. Cloud storage
  4. Cloud databases

    Redefine the way you work
    with Zoho Workplace

      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

          Get started with Zoho Sign

          in a few quick steps!

          Download Help Guide

                    Secure your business
                    communication with Zoho Mail

                    Mail on the move with
                    Zoho Mail mobile application

                      Stay on top of your schedule
                      at all times

                      Carry your calendar with you
                      Anytime, anywhere

                              Zoho Sign Resources

                                Sign, Paperless!

                                Sign and send business documents on the go!

                                Get Started Now

                                    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

                                                                          • View options

                                                                            DataPrep allows you to control the viewing options of the columns in the dataset by selecting the Hide or Show options from the Viewing Options section. This makes it easier to focus on the columns that matter, hiding the columns won't exclude them ...
                                                                          • 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 as files 1. To export data click the Export now option from the Export menu in the Studio page.  2. Select Files from the ...
                                                                          • 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 Studio page and select Schedule export.               2. Click the New schedule button to create a new ...
                                                                          • 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 ...
                                                                          • 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 now option from the Export menu in the Studio page. 2. Select Zoho Analytics in the side pane. 3. You can choose to ...
                                                                          Wherever you are is as good as
                                                                          your workplace



                                                                            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