Data Export | Zoho Forms - User Guide

Data Export

If you are looking to export all your data collected using your forms from the cloud to your computer, you can use the Data Export option in Zoho Forms. 

The following data will be exported with the Data Export option:
  1. All fields' data
  2. Record Link ID
  3. Added Time
  4. IP Address
  5. Submitter's Location
  6. Submitter's Latitude
  7. Submitter's Longitude

To export your form data,

  1. In the top-right corner, click the  icon to access the Control Panel.

    Control Pane
  2. Click Data Export under Data Administration.

    Select Data Export
  3. Click New Export in the top-right and choose the required form from the dropdown.
  4. You can choose to download the exported data as a password-protected file by selecting Set password protection.
  5. If you have a Matrix Choice field (in Dropdown, Text Box, Number, Currency type) on your form, you can choose to export it's data in any of the following 2 formats depending on how you want to analyze the data:
    1. Combine answers in a cell: In this format, all the choices selected within the Matrix Choice field are combined into a single cell in the exported data. This can be useful when you want a quick overview of the respondent's choices without the need for detailed analysis.
      In a single cel
    2. Provide individual cells for each answer : In this format, each selected choice within the matrix choice field is exported into a separate cell. This format provides a more detailed view of the respondent's choices and allows for more granular analysis.
      In separate cells
  6. Click Export. You will receive an email notification when your form data is available for download. 
  7. To download the exported file, hover on the form name on the Exported Forms list and click the download  icon. 

    Exported Form Data
  8. In the pop-up, click the file that you wish to download. 
  9. To download all the exported record files as a Zip file, click  <form-name>.zip  in the top-right corner. Read more on how to read the downloaded files. 

    Download Exported Data
  10. To delete the exported form data, click theicon.

Note:

  • The exported file will be available for download for 7 days from date of export after which it will be auto - deleted.
  • The download link for the exported file will no longer be valid once the file is deleted.
  • Only Super Admin can export the data.
  • Data Export is available only for paid plans. The number of exports would differ depending on the plan.

Number of exports allowed: Plan-wise

Plan Maximum exports allowed at a time Maximum exports allowed in a month
Basic  3 10
Standard 5 20
Professional 10 50
Premium 15 75
Zoho One 20 100

How to read the downloaded files

The following data will be exported as separate files:

  • Form records
  • Form attachments
  • Subform records
  • Subform's attachments

Form and Subform records are exported as .csv  files, whereas attachments are exported as Zip files. 

Each record in the .csv file of the fetched form data will have a unique Record Link ID which must be used to map the form's data with the corresponding form attachments, Subform data, and Subform attachments.

For example, to find the corresponding Subform entries to a Form entry, go to the .csv file of the form, copy the Record Link Id of the record, and search for the Record Link ID in the Subform's .csv file.

Note

  • An exported .csv file of a form and its Subform(s) consists of a maximum of 100,000 records. Each time an exported .csv file exceeds this limit, a new .csv file will be created till all the records are exported. 
  • An exported zip file of attachments consists of a maximum of 1 GB data. Each time an exported zip file exceeds this limit, a new zip file will be created until all attachments are exported. 


    Access your files securely from anywhere

      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


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    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 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 Record Audit Data

                                                                                                                You can export record audit data of your forms and download them as password-protected files. To do so, In the top-right corner, click the icon to access the Control Panel. Click Export Record Audit Data under Data Administration. Click New Export. ...
                                                                                                              • Exporting Form Entries

                                                                                                                List View You can choose to export form entries as a CSV or PDF file in List view. Export as CSV Exporting form entries in bulk To export all the form entries in bulk as a CSV file, In the All Entries section of your form, click the Export icon as ...
                                                                                                              • Export Form Audit data

                                                                                                                If you are the Super Admin of your Zoho Forms organization, you can choose to export the audit data for the forms and download the exported audit data of the selected forms as a zip file. To do this, Log in to Zoho Forms as the Super Admin. In the ...
                                                                                                              • Form Analytics

                                                                                                                Basic Analytics Once the form is shared and responses start coming in, Zoho Forms provides simple built-in analytics for each form. Use the analytics reports to get information on your form's online activity and analyze your form's performance. ...
                                                                                                              • Viewing Form Entries

                                                                                                                Once you have successfully created and shared a form, the form responses will be listed under All Entries. Here, you can view all entries as a summary, and group them based on certain criteria. You can also change the view, edit the entries, assign ...
                                                                                                                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