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. 


    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







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • 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. ...
                                                                                                  • 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 ...
                                                                                                  • Exporting Form Entries

                                                                                                    You can choose to export form entries as a CSV or PDF file. 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 shown. Select Export as ...
                                                                                                  • 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. ...
                                                                                                  • Sending PDF copies of form submissions

                                                                                                    Providing PDF copies to respondents When your respondents submit form entries, they might want to keep a record of the data they have filled out such as purchase orders, complaints they have raised, or applications for their reference. To provide ...
                                                                                                    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