Skip to main content

Export Form Responses to Microsoft Excel

Users can connect their Microsoft account and automatically sync form responses to an Excel workbook

Written by Bidisha Sinha
Updated this week

Uniqode Forms now supports Microsoft Excel integration, allowing you to automatically export form responses to a workbook in real time. This makes it easier to analyze responses and derive insights faster.

Prerequisites

  • Uniqode Pro/Core plan or above

  • Admin or Editor access to Forms

  • A Microsoft account

Important: The "forms_microsoft_integration" feature permission must be enabled for the org. Microsoft Entra ID tenant admin may need to grant consent for first-time setup.

Connect Your Microsoft Account to Forms

  1. Sign in to your Uniqode account.

  2. Create a new Form or edit an existing Form.

  3. Go to Step 3: SET UP.

  4. Click the Microsoft Excel card under INTEGRATIONS.

  5. Click Sign in with Microsoft to connect your account.

  6. Select the Microsoft account you want to connect.

  7. Grant Uniqode permission to access and manage your Excel files.

  8. Click Continue.

Note: Any user with Admin or Editor access can connect their own Microsoft account to link Excel to their forms.

Admin Consent for first-time setup

Please follow the steps below to grant admin consent in Microsoft Entra ID, formerly Azure Active Directory (Azure AD):

  1. Go to Azure PortalMicrosoft Entra ID, formerly Azure Active Directory (Azure AD) Enterprise Applications

  2. Search for “Uniqode Forms Integration”

  3. Select the application

  4. Navigate to Permissions (under Security)

  5. Click “Grant admin consent for [tenant name]”

  6. Review the requested permissions:

    • Files.ReadWrite

    • User.Read

    • offline_access

  7. Click Accept to complete the process

Link a Workbook to Your Form

You can either create a new workbook or connect an existing one to export form responses.

Create a new workbook

  1. Enter a name for the workbook so you can easily identify it later.

Connect an existing workbook

  1. Select the workbook from the dropdown list, or

  2. Type the name of the workbook to find and select it.

  3. Click Save once done.

  4. Click Next to continue.

Sync Existing Responses

If your form already has responses, you can choose Sync existing responses to export all previous responses to the connected Excel workbook.

Note: It may take up to 15 seconds for responses to appear in the linked workbook.

Disconnect a Linked Workbook

  1. Go to Step 3: SET UP of the form you want to disconnect.

  2. Click the Microsoft Excel card under INTEGRATIONS.

  3. Click Disconnect Workbook.

  4. Click Disconnect in the confirmation dialog box to complete the action.

Note: Once disconnected, new responses will no longer be automatically added to the Excel workbook.

Disconnect Your Microsoft Account

  1. Go to Step 3: SET UP of any form connected to Microsoft Excel.

  2. Click the Microsoft Excel card under INTEGRATIONS.

  3. Click Disconnect Microsoft Account.

  4. Click Disconnect in the confirmation dialog box.

Note: Once your account is disconnected, all linked forms will be unlinked, and responses will stop syncing to Microsoft Excel.

Did this answer your question?