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?

- Why are there quotation marks added to cells around text in Excel?

- 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.

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.