Zoho Show integration with Zoho Sheet
The external data linking option in data fields allows you to integrate Zoho Sheet with Zoho Show. You can link any cell in the spreadsheet to your presentation as a data field. Any changes made to the spreadsheet can be synced with your presentation.
- Create a Zoho Sheet with the required data.
- Navigate to the required slide in your presentation, click Text from the top, and choose Data Fields within it.
You can also enter $ in the required slide and choose Create New to create a new data field.
The data fields window will appear. - Click Add New.
- By default, the data field will be named as Untitled 1. You can rename it.
- Select External from Source. By default, Zoho Sheet will be selected.
- From the Document dropdown, select the spreadsheet.
- Click the
to choose a spreadsheet from WorkDrive.
- From the Sheet dropdown, select the sheet in which your data is stored.
You can link a cell, range, or a named range data to your presentation.
Cell:
- Click Cell next to Data and enter the cell location in which the data is stored.
Alternatively, you can also click Select Range, choose a cell from the spreadsheet, and click Update from the top-right corner. - Click
next to Value to fetch a different data.
- Click Insert field.
- To use the added data field in other slides, navigate to the required slide, enter the $ symbol, and from the dropdown choose the data field that you wish to insert.
Range:
- Click Range and enter the range from the sheet.
Alternatively, you can also click Select Range, select the required cell range from the spreadsheet, and click Update from the top-right corner. - Click the Insert as Table dropdown to select between Insert as Table or Insert as Chart to insert the selected range as a table or a chart.
Named Range:
- Click Named Range and choose the required Named range from the Select Range dropdown.
- Click the Insert as Table dropdown to select between Insert as Table or Insert as Chart to insert the selected range as a table or a chart.
When changes are made to the Sheet, you can use the Sync icon to sync the values to your presentation.
When you map values from the Sheet, your collaborators will be able to view the mapping. However, only those with access to the Sheet will be able to sync the changes.
Access your files securely from anywhere
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Zoho Show integration with Zoho Flow
Zoho Flow is an integration platform that helps you connect two different apps without any code. It works on the trigger-action methodology, where when an event is triggered in an app, you can instruct another app to perform an action. For example, ...Add and manage data fields
A data field is used to store values and access them when required. With the Zoho Show app, you can define a data field and use it across your presentation. It can be used to store numerical and alphanumeric information. The data field is ...Zoho Show integration with Zapier
Zapier lets you connect an app with thousands of other popular apps to automate your work. Zaps are workflows that link two or more apps together. Zap consists of two parts: a trigger and an action. A trigger is an event in an app that starts the Zap ...Overview of Zoho Show for Slack
Zoho Show integrates with many external services to enhance its presentation services. One such integration is that with Slack. Once the Show app for Slack is installed, the app listing page opens in a new tab. The app lists under the Recent apps in ...Install the Zoho Sprints add-on for Zoho Show
Let's say you are going to deliver a presentation about an ongoing project (developed using agile methodology) to your manager. In such a case, you may want to include a few reports in the presentation so they can easily track and monitor the ...
New to Zoho LandingPage?
Zoho LandingPage Resources