How can I export data from reports in Zoho CRM?

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

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

    • Scheduling Reports

      You can automatically send reports to your colleagues, executive management and non-Zoho CRM users by scheduling the desired reports daily, weekly, monthly or yearly. Once the Report scheduler is configured, specified reports will be delivered to the ...

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

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