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 as files

1. To export data click the Export now option from the Export menu in the Studio page. 

2. Select Files from the options in the side pane.



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



4. Click Next and do the following as required.
  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. 
5. Once you input the required values, click Export.



    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
      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





                      Still can't find what you're looking for?

                      Write to us: support@zohoforms.com


                            




                            

                          Zoho Marketing Automation

                            Zoho Sheet Resources

                             




                                Zoho Forms Resources


                                  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

                                                                                      • Export data to Google BigQuery [Private Beta]

                                                                                        Zoho DataPrep supports exporting data to Google BigQuery. BigQuery is a fully managed enterprise data warehouse that helps you manage organization data. To export data to Google BigQuery 1. Click the Export now option from the Export menu in 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 ...
                                                                                      • Import data from a local filesystem

                                                                                        In DataPrep, you can import various file types, including CSV, TSV, JSON, HTML, XLS, XLSX and XML.   Note: DataPrep also supports files without any extension or files in plain text format. However, binary files cannot be parsed during import; users ...
                                                                                      • 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 ...
                                                                                      • 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 ...
                                                                                      Wherever you are is as good as
                                                                                      your workplace

                                                                                        Resources

                                                                                        Videos

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



                                                                                        eBooks

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



                                                                                        Webinars

                                                                                        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