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. Click the  icon on the left in the forms listing page to access the Control Panel.

    Navigate to Control Panel
  2. Click Data Export under Data Administration.

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

    Download 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.
Notes

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.

Notes

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. 


      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        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







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        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

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

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

                                                               
                                                                

                                                              Videos

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

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                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 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, Click the icon on the left in the forms listing page to access the Control Panel. Click Export Record Audit Data under Data Administration. Click ...
                                                                                                                        • 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. Click 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