Export CRM Data

Export CRM Data

Depending on your needs, you may wish to export all or part of the data stored in your CRM. Some common reasons include segmenting customers, sharing data with collaborators, meeting compliance-related requirements, creating reports, and archiving your data.

What are the options available?

There are three export-related options in Zoho CRM:
  1. Export module data.
  2. Make a complete backup.
  3. Export reports.

Which option do I choose?

  1. If you need to export data from individual modules, you can go to the module, and under Actions, select Export, or you can use the export option in the Data Administration tool.
  2. If you want to export all the data in your CRM (all module data, including attachments, configuration details, etc.), making a complete backup is the way to go.
  3. If you require a specific set of data that's sorted, grouped, and encompasses multiple modules, the best option is to create a report and export it.
Let's look at the first option: exporting the data stored in your CRM's modules.

Export module data

You can export data from modules in both CSV and XLSX formats. The download link for an export will be available for a period of seven days, and the file will be downloaded as a zip.

In XLSX format, you can export a maximum of 50,000 records. 

In CSV format, you can export a maximum 200,000 records from a single module in one go. You can also choose the character set for your CSV file as your encoding system, which retains international characters.
Notes
Limits for number of exports per day will vary based your CRM's edition:
  1. Free - 10
  2. Standard - 100
  3. Professional - 250
  4. Enterprise - 500
  5. Ultimate - 1000
Idea
If you need to download more than 200,000 records from an individual module, you can:
  1. Set criteria based on Created Time to create and download multiple exports.
  2. Take a local backup to get the entire set of records from that module.

Availability

Users with the Export (Module) permission in their profile can access this feature.

To export data

  1. Navigate to Setup → Data Administration → Export.
  2. In the Export Data page, click Start an Export.

    You can also navigate to the relevant module menu, go to Actions, and select Export to get the export dialog box to appear.

  3. Under Configure, do the following:
    1. Select a module, subform, or Notes from the Module drop-down list.
    2. Choose if you want to filter the records by custom view or criteria.
      1. If you have chosen Custom View, choose a custom view from the dropdown list.
      2. If have chosen Criteria, add the criteria
      3. If you've chosen a subform in the Module drop-down list, you can set criteria for the subform as well.
    3. You can choose to export all fields or specific fields
      1.  If you've chosen to export All Fields, all data will be exported. However, if you want to export all fields except a few fields, click Exclude Fields and select which fields need to be excluded. You can also exclude the Record ID
        field from being one of the columns in the export file.
        Notes
        Note: You can select up to 20 fields to exclude from your export action. If you've selected Choose fields, you can select a maximum of 200 fields from the respective module and its lookup modules altogether.
      2. If you choose to export the specific fields, click Choose Fields. You can select fields from the respective module and its lookup modules.
  4. Under Preferences, do the following:
    1. Select the download file format—CSV or XLSX—before exporting the data.
      1. If you opt to export as CSV, you can choose the character set for your CSV file as your encoding system, which retains international characters.
    2. You can opt to set password to the file that will be exported.
      Notes
      Note: When you set a password export, each time the viewer tries to unzip the exported file, the system's file archiver will prompt them to enter the password. The password secures the entire ZIP file, not the individual files inside it.
    3. Opt your preference of exporting the rich text data as plain text in order to preserve the rich text format of your data while you import your exported file to another platform.
  5. Click Export.
    Your export will be added to the Export History table, with the status In progress.
  6. When the status changes to Completed, hover over the entry and click the Download link to download the data to your local device.

To export a custom view

If you want to export a custom view quickly, you can initiate it from the Actions menu in the relevant module. To do this, follow these steps:
  1. Select a custom view in a module page.
  2. Click the ellipses (···) button and select Export [Module].
  3. In the Export Data pop-up that appears, select the options for export, then click Export.

To export selected records from a module

Select specific records to be exported from the list view of any module—directly from the module page. You can choose up to 500 records and click Actions → Export Selected Records.

Where can I track my exports?

Users with the requisite permission in their profile can access the Export Data page at Setup () > Data Administration > Export.

The following options are available on this page:
  1. Start an export: Use this button to create an export of the data in individual modules or their subforms.
  2. Export History: Use this table to track your exports over the past 60 days and view details, including the following:
    1. The module from which the data was exported
    2. The user who initiated the export
    3. The date and time when the export was initiated
    4. The number of records that were exported
    5. The status of the export (In Progress, Completed, Error while Processing)
  3. Filter: Use this to filter the entries in your export history. The list of exports can become lengthy, especially in large organizations where data is exported multiple times per week by multiple users. In such a situation, you can use this option to find a specific export or a set of exports quickly. You can filter by:
    1. User
    2. Module
    3. Date

  4. Individual export: Click on a specific export to access the Export Details page. This page contains the details found in the Export History table, as well as:
    1. The custom view or criteria that was used
    2. The file type and charset that were selected
    3. The fields that were selected
  5. Download link: When you hover over an individual export, you'll see a download link(). Click it to download the data to your local device. It will be available for a period of seven days from the time of export.
  6. Request Data Backup: Use this link if you want to export all the data in your CRM.
Notes
Note: Admins can view the exports performed by all the users. Non-admin users can only view exports they've initiated.

Notes

  1. You'll receive a notification when an export is ready for download.

  2. You can set a maximum of 25 criteria for an export. This number includes criteria set for the module and criteria set for the subform.
  3. You can select a maximum of 200 fields in an export.
  4. You can pick fields from a maximum of five lookup modules.
  5. Administrators can download the export data of other users.
  6. Tags can be included in exports.
  7. If your export encounters an error, you can try to export again using the retry option.
  8. Zoho CRM does not in any way include any kind of harmful information or data in your exported files. However, as a precautionary measure to safeguard yourself from unknown security threats, we recommend that you look for warnings about executable operations when opening exported files in MS Excel. Please refrain from updating any commands in the CSV file exported from Zoho CRM.
  9. To learn about how GDPR/HIPAA-related settings affect your export, see:
    1. Restrict Data in Export(GDPR)
    2. HIPAA compliance in Zoho CRM


        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 FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile 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 FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                    All-in-one knowledge management and training platform for your employees and customers.

                                              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


                                                                      • Desk Community Learning Series


                                                                      • Digest


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Glossary


                                                                      • Desk Marketplace


                                                                      • MVP Corner


                                                                      • Word of the Day


                                                                      • Ask the Experts


                                                                        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

                                                                                                                                • Importing Data to Zoho CRM

                                                                                                                                  Data can be gathered through various sources such as, purchasing a record database, collecting from trade shows and campaigns, and so on. Importing records from such external sources to Zoho CRM is one of the most important lead creation activities ...
                                                                                                                                • Data Administration - An Overview

                                                                                                                                  The purpose of the Zoho CRM data administration tools are to guide the CRM Administrator in creating, verifying and ensuring data integrity by maintaining relationships and implementing access controls throughout the databases. Based on the ...
                                                                                                                                • Migrating from Maximizer CRM to Zoho CRM

                                                                                                                                  Zoho CRM supports only .CSV file format for migration of data. However, the export data from Maximizer CRM is in .BAK format. To convert your data to .CSV format, you can contact our experts (migration@zohocrm.com), who will assess the possibilities ...
                                                                                                                                • Manage your Data

                                                                                                                                  There are a bunch of common operations that you would be performing as an administrator. Out of which, a few important tasks are to maintain a clean database and discover strategies to assess and improve the quality of your data in CRM. Some of your ...
                                                                                                                                • Migrating from Sugar CRM to Zoho CRM

                                                                                                                                  Welcome to Zoho CRM! Migrating your data from Sugar CRM to Zoho CRM can be done seamlessly using our data migration feature. All you need is to have an export file from Sugar, ready to use. Click here to learn to export data from their CRM. Before ...
                                                                                                                                  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