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?
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. We advise that you leave your Excel file in the same folder after setting up the integration. Anytime you move an Excel file in your OneDrive, this causes changes to the file and it'll make the integration break. If the Excel file is moved to another folder, your responses will not be sent to the file in the new location.
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 URL parameters supported?
Yes, URL parameters are supported and are added as an additional column with the name of the URL parameters in Excel Online.
Why are there quotation marks added to cells around text in Excel?
The quotation marks added to Excel cells are called text qualifiers, and they let Excel and other tools used to open CSVs know where the text begins and where it ends. This can be especially important when importing data in text files.
As a workaround, you can modify this data to remove the quotation marks in your Excel workbook, but we recommend transferring the data to a different tab before making any changes. You can find detailed instruction on how to transfer data from one Excel worksheet to another automatically here.
Once you've transferred your data, you can start removing quotes for text or strings in Excel by using the Find and Replace function. You can find detailed instructions on how to do that here, or a video explaining the solution here.
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.
Can I send Partial responses to Excel Online?
Yes. If you've added a Partial Submit Point(s) to your form, you can send Partial Responses to integrations in your form's settings. Make sure the Send partial responses to integrations setting is toggled on before you collect responses.
Each time a respondent passes a Partial Submit Point, this will create a new row in Excel Online. Then if the same respondent continues with the form and completes it, this will create a second row in Excel Online. More information on how to send Partial responses to Excel Online can be found here.
If you've have already collected partial responses in your form before you've set up the integration, you won't be able to backfill any previously collected partial responses.