Things That Work Well in ZOHO CRM: - Sheet View

Introduction here

As far as I know Sheet View is exclusive to ZOHO CRM. A common task (chore) in the management of any CRM system is editing large swaths of data at once. Some systems like Oasis CRM only give you a really crappy (trust me) mass update function. Other systems like Salesforce make you export to Excel to update a bunch of records and then re-import. (not fun)

ZOHO has a great mass update function that works as expected but sometimes you want to be able to change selected records as a group. For example changing just certain records to a new sales territory without changing all of them at once. You want to be able to get a view of all the possibles, sort as needed and then make the changes as needed. Common problem in the CRM admin world and until now I have not seen a good solution until I started working with the ZOHO CRM Sheet View.

Check it out. In this case I want to add a Sub-Territory to the main Territory. All I have to do is create a custom list view of the information. Press the ZOHO Sheet View link and I get an instant ZOHO Spreadsheet of the exact data presented in a new browser tab.

Once I am in the ZOHO Sheet View I can use any normal spreadsheet functions to copy, add cells change case, whatever I want can be done in the spreadsheet and when I hit save the records are automatically updated in the CRM system.

Very well implemented feature, totally useful, easy to use and HUGE time saver.

Adam Stone is a Zoho CRM customer and CEO/Founder of D-Tools Software.

Comments

6 Replies to Things That Work Well in ZOHO CRM: - Sheet View

  1. I would love it if the mass update feature would make you do it only a page at a time. I would love to be able to do it truly en mass.

  2. I would love it if the mass update feature would make you do it only a page at a time. I would love to be able to do it truly en mass.

  3. I tried this to update Campaign Source for leads, but it didn't work for me. I displayed 50 leads on a page with Campaign Source included as a field in the view. Then I hit sheet view and edited/copied down campaign source ID as needed, repeating the exercise for each set of 50 records displayed. I hit Save in Sheet view but ZOHO CRM was not updated. Any ideas?

  4. I tried this to update Campaign Source for leads, but it didn't work for me. I displayed 50 leads on a page with Campaign Source included as a field in the view. Then I hit sheet view and edited/copied down campaign source ID as needed, repeating the exercise for each set of 50 records displayed. I hit Save in Sheet view but ZOHO CRM was not updated. Any ideas?

Leave a Reply

Your email address will not be published.

The comment language code.
By submitting this form, you agree to the processing of personal data according to our Privacy Policy.

Related Posts