@auk-blf - welcome to the Community!

this is from a user 

I just tested out the integration with a sample typeform that i have and i was successfully able to get all the existing data pulled across into the file: see the image below

not sure what might be the issue at your end.. maybe try ‘publishing’ the typeform again and that will push the data.. I did the integration and the creation of the new excel file after reading your post.. so these results were already existing 

des

Thanks @john.desborough I tried ‘publishing’ again but this did not change anything. This issue seems to be happening when there is a lot (e.g. over 6,000) existing responses. It seems to work fine when there are fewer existing responses to import (e.g. around 800 or less). I’m wondering if this is a limitation in Excel, or something that Typeform could potentially address.

@auk-blf welcome back 

you should probably raise a support ticket and have that team look into the issue. 

des

Hi @auk-blf Were you able to reach the support team? 

Hi @Liz yes I was, thank you.

Adding some info here in case it helps anyone else with this issue:

• Excel online integration only supports backfilling responses for forms with up to 1000 responses or less
• Google sheets integration doesn't support backfilling of responses for forms with over 3000 responses
• Recommendation is to download the responses to csv/xls and manually add them to an integrated sheet (making sure the data and the columns are in the expected order):
  • Token ID and network ID columns might have to be removed manually before copying/pasting the data over
  • Convert 1 or 0 boolean type into true and false
  • Concatenate data from ‘Other’ columns

Thank you so much, @auk-blf ! This is really helpful information. I appreciate it!