How can I export data from Zoho CRM?

How can I export data from Zoho CRM?

You can export data from the modules as well as reports.

In case of reports, you can export the data in three different formats - Excel, CSV and PDF. Each one of them have different export limits.

Export limit
  1. In PDF and Excel formats you can export 2000 records per batch (records from a single page of a report).
  2. In CSV format you can export 20,000 records from the first page of a report and 2000 from the subsequent pages.
Note that one page of a report consists of 2000 records only. 
So, assume you have a report of 30,000 records that you want to export in CSV format. From the first page of the report you can export 20,000 records and from the subsequent pages you can export 2000 records only. Now, since every page of a report consists of 2000 records, you would have exported from 10 pages to get 20,000 records. Therefore, to export the remaining 10,000 records you must start export from the 11th page of the report. From here you can export 2000 records (i.e 21,000-23,000) and so on.
Note:
  1. You can export 20,000 records only from the first page of a report up to 5 times in a day. That is, if you think the first export was incorrect you can repeat the process upto 5 times a day. The limit applies to same or different reports.
  2. Irrespective of the number of records in a report, the export limit is 5 times a day. 
Related Link
Exporting Data

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

                Zoho SalesIQ Resources



                    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

                                                        • Exporting CRM Data

                                                          Zoho CRM provides two options to export your CRM data: Export data (modules and reports)  Request CRM data backup  Export Module Data The Export Data feature allows you to export data (in CSV format) from individual CRM modules. After exporting the ...
                                                        • Troubleshooting Data Import and Export

                                                          1. When I try to import leads, I get an error message which says "Duplicate record exist in system: Email." I've checked my CRM data and there is no duplicate record with the same email address. How do I resolve this? Once you have ensured there is ...
                                                        • Migrating Data Between Zoho CRM Accounts

                                                          Retrieve Data files from Zoho CRM If you are planning to use a backup of data from Zoho CRM to import, the file structure does not change. If you exported data from another CRM, use the following folder structure: The Data folder should contain all ...
                                                        • 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 ...
                                                        • 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 ...

                                                        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