Microsoft Excel
Overview
-
Navigate to the Integrations
tab in your form builder and click
Microsoft Excel
from the left menu.
-
Click Integrate.
-
If you have not authenticated Zoho Forms to connect with your Microsoft account already, you will see an authentication pop-up. Click Authenticate.
-
Select the
Workbook Name and
Sheet Name where you want to push your form responses.
-
Under Integration Settings, you can choose to add additional information, such as Added Email ID, Referrer Name , Payment Information , etc., under separate dedicated columns in the sheet for each form entry pushed.
-
Click Save.
If you have a Matrix Choice field (in Dropdown, Text Box, Number, Currency type) on your form, you can choose to send it's data into the sheet in any of the following 2 formats depending on how you want to analyze the data:
- Combine answers in a cell: In this format, all the choices selected within the Matrix Choice field are combined into a single cell in the exported data. This can be useful when you want a quick overview of the respondent's choices without the need for detailed analysis.
- Provide individual cells for each answer : In this format, each selected choice within the matrix choice field is exported into a separate cell. This format provides a more detailed view of the respondent's choices and allows for more granular analysis.
Once integrated, all the form responses will be saved in both Zoho Forms and Microsoft Excel sheet. As you add fields to your form, they will be automatically added in the Excel sheet.
-
Once integrated, all the form responses will be saved in both Zoho Forms and the Microsoft Excel sheet. As you add fields to your form, they will be automatically added in the Microsoft Excel sheet.
- If you have configured the Manage Form Attachments option to save your form attachments to a third-party service, the link to the stored attachment of each form entry pushed will be available under the File Upload / Image Upload column in the Microsoft Excel sheet.
-
If you have a Subform within your form, you can push a maximum of 50 subform entries to the integrated Microsoft Excel sheet.
- This integration is supported only for workbooks created via One Drive.
Integration Settings
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:
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Microsoft Teams Integration
If you wish to trigger notifications of form entries in your Microsoft Teams channel, you can use the Zoho Forms - Microsoft Teams Integration. Using this integration, you can trigger message cards using a bot in a Microsoft Teams channel when you ...How to re-push values into an integrated service after fixing the cause of integration failure?
Go to the All Entries section of your form. Click the filter-by All Entries dropdown in the top-left corner. Scroll down and select Integration - Failed Entries option from the list. Select the failed entries and click Re-push. The integrations for ...Zapier Integrations
Integrate Zoho forms to all the applications you already use with Zapier. You will be able to connect your forms to different applications and trigger different actions every time a form is submitted. You can receive instant alerts in your chat tool, ...Zoho Flow Integrations
Integrate your forms using Zoho Flow, and the information you collect will always reach the right apps. With this integration, you can connect your forms to different applications and trigger different actions each time a form is submitted. For ...Sending Email Notifications in Approval Process
You can set up email notification templates to notify your users and respondents during the approval process. If you choose to add Microsoft 365 users as approvers, you can create a separate email template to notify them when they receive a form ...