Exporting Data From Zoho Desk - Data administration | Zoho Desk

Exporting Data From Zoho Desk Modules

Exporting data from Zoho Desk allows businesses to migrate records to other platforms, ensuring a smooth transition. It also provides a secure backup of critical help desk data, helping businesses meet compliance and audit requirements. In addition, exporting data enables businesses to conduct offline analysis and generate reports in other applications.

For example, businesses can use their native applications to perform trend analysis, forecast resource allocation, and budget analysis for proactive decision-making.

Difference between Export and Data Backup  

  1. Export: Allows users to manually export records from individual modules (e.g., Tickets, Contacts, or Accounts) in CSV format. It is also useful to apply filters and extract only specific records, for example, tickets from ABC Corp that are overdue, contacts who purchased x product last month. 
  2. Data Backup: Provides a complete backup of the help desk data, including email threads, attachments, and other critical information such as tickets, contacts, products, KB articles, and so on. Unlike Export, Data Backup cannot be done for selected modules.

Availability

InfoPermission Required
Users with the permission to Export Records can export data from the Desk modules.
Check Availability and Limits

Exporting data from Zoho Desk

Users can choose specific modules and apply different options for exporting records in the CSV format. Here's a breakdown of the available export options:

All records

Users can export all records from a selected module (e.g., all Tickets, Contacts, Accounts, Tasks, etc.).

Export based on views

Users can export records based on custom views that have been created in the module. For example, a manager who has created a custom view called "John's Tickets for Review" can export this view for review instead of manually filtering all tickets.

Export based on criteria

Users can export records based on specific criteria. Multiple criteria can be applied to filter the data. For example, users can export "Closed Tickets" "Last month" for "X product" with issue "Manufacturing Defect".

Select fields to export

In addition to selecting records based on views and criteria, users can choose either all or specific fields to export.
  1. All fields: Users can export all available fields from the module.
  2. Specific fields: Users can select only the fields they want to export. This option includes fields from all layouts within the module, allowing users to choose the desired fields. 

Timelines

Users can specify a timeline and export the records. Note that this option is visible only when All Records is selected. The export can be based on:
  1. Created time
  2. Closed time
  3. Modified time
  4. Completed time

Date range

Users can export records within a predefined or custom date range:
  1. Custom date range: Users can select a start and end date for the data export.
  2. Predefined Date Range: Users can select from available date ranges, which can be found when creating a report.
Date range

Encrypt with password

The exported modules may contain sensitive information that should not be accessible to unauthorized users. Enabling the Encrypt with Password option protects the exported file with a password, ensuring the contents remain secure and confidential.

The password set for the export must be shared with the respective customer via an authorized channel such as email or chat for them to be able to access the file.



To set the password successfully, ensure that it meets all of the criteria:
  1. Eight characters
  2. One uppercase character
  3. One lowercase character
  4. Numbers (0-9)
  5. Special character (!@#$%^&*)
For security reasons, only the user who created the password can access and view the password entry on the Export homepage. Other users will not be able to access or view the password.

Info
Points to remember
  1. Modules available for export: Users can export data only from one module at a time. They can export data from both standard and custom modules.
  2. Export is department-specific, hence cannot be viewed when All departments is selected.
  3. Date and time: All Date/Time columns are exported in GMT format, regardless of the user’s timezone.
  4. Record Count: Users can export up to 50,000 records at once. Data above 50,000 can be retrieved as backup.
  5. Module-based limitation:
    1. When the Agent is selected, All Records will be exported with all respective fields; the View-Based Export and Criteria-Based Export options will be disabled.
    2. When the Article module is selected, the Criteria field will be disabled. Articles can be exported based on views, but not based on criteria.
  6. Blueprint views: All the blueprint views cannot be exported, blueprint views such as:
    1. Active Blueprint Tickets
    2. All Transitions
    3. My Transitions
    4. My Team Transitions
    5. Unassigned Transitions
  7. A maximum of five lookups can be exported using lookup ID and lookup names in specific fields. Any additional lookup selected will only have the lookup ID exported when a lookup field is selected.  
  8. Revoke export: Users cannot revoke an export once it has been initiated.

To export data

  1. Choose the desired Department.
  2. Go to Setup > Data Administration > Export and click New Export.
  3. In the New Export page, choose the Module.
  4. Select the desired export records option:
    1. All Records
    2. Export Based on Views
    3. Export Based on Criteria
  5. Choose between All Fields or Specific Fields for export.
  6. Choose the desired Time Frame, either by selecting the time in Based on field or by specifying a predefined or custom date range.
  7. Enable Encrypt with Password if required. 
  8. Click Export.

Accessing export history

Once the user initiates the export, they will be redirected to the export history page. On the export history page, users can view details about each exporting a tabular format:
  1. Module: The module from which the data was exported (e.g., Tickets, Contacts, etc.)
  2. Modified by: The user who initiated the export.
  3. Initiated time: The time when the export was initiated.
  4. Status: In progress, completed, failed. 
  5. Export can fail due to several reasons, such as internet connectivity issues, or technical glitches at the backend.
  6. Export file: Contains the exported file, which users can download. The downloadable link is valid ONLY for 7 days.  
    1. Once the export is complete, the user will be notified via email, as well as in the notification center in their Desk account.
    2. Export history can be filtered based on module, initiated by, initiated time, and status. 
  7. Audit log: Export history can be viewed in the audit log as well.


        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

                                                                                                                                • FAQs: Data Administration

                                                                                                                                  Can I retrieve deleted records from the recycle bin? Yes, it is possible to retrieve deleted records. The recycle bin is a temporary storage location for deleted records in Zoho Desk. It is designed to give users the ability to retrieve any ...
                                                                                                                                • FAQs: Custom Modules

                                                                                                                                  What is a custom module in Zoho Desk? Modules in Zoho Desk are like compartments. Just like each compartment holds different items, modules store different types of information in one place. For example, the Tickets module is a repository of customer ...
                                                                                                                                • Data Prep Tips for Smooth Migration of Critical Modules: Threads and Conversations

                                                                                                                                  Migrating your customer support data from a legacy system to Zoho Desk is a strategic step toward enhancing efficiency, scalability, and customer experience. However, the success of the transition relies on the completeness and accuracy of the data ...
                                                                                                                                • Migrate Data from Other Help Desk Services to Zoho Desk (Zwitch)

                                                                                                                                  Customer support is the cornerstone of every organization. Businesses rely on help desk software that simplifies ticket management, streamlines support processes, and improves overall customer satisfaction. As your business expands, your requirements ...
                                                                                                                                • Ensure Migration File is Submitted in CSV Format

                                                                                                                                  Data migration is not just about transferring information—it’s about preserving context, relationships, and history. By following the correct sequence, using the right file formats, and ensuring that external IDs are properly mapped, you can avoid ...
                                                                                                                                  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