Excel Online integration: Troubleshooting, limitations, and other FAQs
If you’ve set up our Excel Online integration already, you can find the answers to some of the most common questions about it here. Read on to find out more.
- Is there a guide to setting up the Excel Online integration?
- Can I choose a different destination folder for my workbook?
- Is the Matrix question type supported?
- Are the Address and the Contact Info questions supported?
- Are Hidden Fields supported?
- Can I use the Excel Online integration with Sharepoint or only with OneDrive?
- Why are my folders not appearing in the dropdown list?
- Will the integration still work after updating my Microsoft 365 password?
Is there a guide to setting up the Excel Online integration?
Yes, check out our step-by-step guide here.
Can I choose a different destination folder for my workbook?
At the moment, Excel workbook files will be created in the root folder of your OneDrive account at onedrive.live.com by default. However, once the files have been created in that folder, you can move them to a different folder, as you wish.
Is the Matrix question type supported?
Unfortunately, the Matrix question is not compatible with the Excel Online integration as of now.
Are the Address and the Contact Info questions supported?
Unfortunately, the Address and Contact Info question types are not compatible with the Excel Online integration as of now.
Are Hidden Fields supported?
Yes, Hidden Fields are supported and are added as an additional column with the name of the Hidden Field in Excel Online.
Can I also use the Excel Online integration with Sharepoint or only with OneDrive?
At the moment, you can only use this integration with OneDrive.
Why are my folders not appearing in the dropdown list?
The issue in this case might be that the dropdown list you’re using to select a folder, a list, an account, or a file is only showing the first 500 entries in alphabetical order. So, if you have more than 500 entries in a list and you want to add an entry from the bottom of the list, it won’t show up in the dropdown list.
The solution for this would be to rename the entry so it shows up at the top of the list. For example, if you have an entry called “My list”, you can rename it to “0. My list” to make sure that it shows up at the top of the dropdown list.
Will the integration still work after updating my Microsoft 365 password?
Unfortunately, after changing things in Excel,—for example, updating your Microsoft 365 password— the integration will stop working. After such updates, you'll have to create a new Excel spreadsheet and integrate that with your typeform. Once the integration is up and running again, you can copy over your existing data to the new spreadsheet.