How can I export data from reports in 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

• Related Articles

• FAQs on Reports

  1. What are reports in Zoho CRM? As an organization, the more you grow, the more complex your data becomes. This data holds powerful information about your customers, employees, profit, sales, opportunities, and other aspects of your business. It is ...

• How do I export my leads from CRM to an XLS file?

  You can export the leads in your account to an XLS file using reports. To export leads: Go to the Reports module and click Create Report. Select the Leads module and choose a report type, e.g. Tabular. Select the fields you want to add to your ...

• Can I sync data between multiple CRM accounts?

  No, the multi-org functionality does not allow any kind of data sync between the orgs. The sole purpose of creating multiple accounts is to provide users with ease of access. You can however, import/export data or use functions to transfer data ...

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

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