The Alchemer Excel Integration is available as an add-on and only available to customers in enterprise plans. If you are interested in purchasing the Excel Integration, please contact us for additional information.
With the Alchemer Excel integration you can easily:
- Push survey data from Alchemer into a Excel Worksheet.
Video Walkthrough
Integration Setup
Adding an Integration Action
1. Select an existing survey or create a new survey. Then navigate to the Survey Builder.
2. Click "Add New: Action"
You cannot add this Integration Action to the first page of the survey.
3. In the Add Action modal, scroll down to Integrations. Then click "Add" for one of your purchased integrations.
If you haven't purchased any additional integrations, you will see the below screen:
4. Select Microsoft Office 365 under "Your Integrations".
5. Select the action you would like to perform:
- Excel: Push data to a worksheet.
Excel | Push Data to a Worksheet
Before configuring this integration action, you will need:
- Your Office 365 login information.
- Fields in this survey that contain the data you want to use to insert data into your worksheet.
- Fields in this survey that you would like to use to return some information regarding the update. (Optional)
1. You will need to first create an Excel worksheet within a workbook.
This worksheet must contain a header row with column titles.
2. Select "Excel: Push Data to a Worksheet" as your action.
3. Click "Next" on the integration overview screen.
4. Authenticate with your Office 365 account. Click add a new account.
5. Name your new authentication and click "create".
6. In the sign-in window that appears input your Microsoft 365 credentials. Once complete, return to the setup wizard in Alchemer.
After signing in you will need to grant Alchemer (Tray.io) access to Microsoft 365.
7. Choose the Excel workbook that you would like to use to insert data into.
8. Choose the Excel worksheet that you would like to use to insert data into.
9. Choose the fields in your survey that you would like to use to insert a row into your Excel worksheet and map it to a column.
10. (Optional) After an integration action occurs, data about the action is available for use in your survey. You can map this data back to fields in Alchemer.
11. Click "Save" to complete your integration action.
Monitoring an Excel Integration Action
A log of each run result can be found in Results > Individual Responses > Action Log.
Select an individual response and then navigate to the Action Log. In the Action Log, you can monitor whether the action was successful.
FAQs
1. The Integration Manager Permission is required to set up and use the Excel Integration. If you don't have this permission you will see the following when trying to add the integration to a survey:
2. To check if you have this permission or grant this permission to someone on your team, go to the left-side product navigation and select the Account drop-down, then click on the user management tab.
3. Then select the Users tab under User Management.
4. Click your username or the username for another member of your team.
5. Scroll down to the Permissions section and check if the Integration Manager box is checked. If you are an admin you can check the box for other members of your team.
Alchemer is committed to continuously releasing updates and enhancements to our survey integrations. If you have specific use cases, questions, or just general feedback, we would love to hear it. Contact us here!
