FAQs: Export Data from Zoho CRM

FAQs: Export Data from Zoho CRM

How do I export Zoho CRM data and garbled foreign characters?

For Excel 2003

1. Open Microsoft Excel.
2. Data - Import External Data - Import Data.
3. Choose the file.
4. In Text Import Wizard Choose 'Delimited' as 'Original data type'.
5. Choose UTF-8 from the File-origin List box.
6. Click Next.
7. Choose 'Comma' as 'Delimiters'.
8. Click Next.
9. Choose 'Text' as 'Column data format' by selecting each column from Data Preview.
10. Click Finish and open in New Work Sheet.

For Excel 2007 & 2010

1. Open Microsoft Excel.
2. Data - From Text.
3. Choose the file.
4. In Text Import Wizard Choose 'Delimited' as 'Original data type'.
5. Choose UTF-8 from the File-origin List box.
6. Click Next.
7. Choose 'Comma' as 'Delimiters'.
8. Click Next.
9. Choose 'Text' as 'Column data format' by selecting each column from Data Preview.
10. Click Finish and open in New Work Sheet.


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 20,001-22,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

How can I share data only with certain selected users?

You can provide access rights to selected users belonging to other roles and groups by creating your own Data Sharing Rules.

How can I export notes?

The Export Notes feature allows you to export the notes from Zoho CRM in CSV format. You can export a maximum of 3000 notes at a time.

To export notes
  1. Go to Setup > Data Administration > Export.
  2. In the Export Data page, select Notes from the drop-down list.
  3. Click Export. You will get a dialog box saying, "Are you sure?".
  4. Click Ok.
All the note records will be exported and saved in .CSV format in your local disk.

Can I export certain selected records from Zoho CRM?

No. Currently you can't export certain selected records from Zoho CRM. However, you can create a report based on criteria (your requirement) and export the report. For more information, see Working with Reports.











    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





                        Still can't find what you're looking for?

                        Write to us:  support@zohoforms.com


                              



                            



                          Manage your brands on social media




                              Zoho Marketing Automation

                                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 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 ...
                                                                                          • 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 ...
                                                                                          • FAQs: HIPAA Compliance

                                                                                            How does Zoho CRM help organizations be HIPAA Complaint? At Zoho CRM, we allow organizations to be compliant with the HIPAA guidelines by providing the following options: Select modules that contain personal health data: All modules that contain ...
                                                                                          • FAQs: Data Migration

                                                                                            What is Data Migration wizard in Zoho CRM? The data migration wizard in Zoho CRM ensures that your data is migrated correctly and helps you reduce much of the manual work. It automatically maps import files to CRM modules and matches data columns to ...
                                                                                          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