How can you help me solve this problem of automating my kobo data on excell

Bonjour !

How can you help me solve this problem of automating my kobo data on excell
Below are some photos illustrating :
Importing with API: No worries


Adding databases: A problem, the different tables are not displayed

Loading and Transformation: At this level, I should be able to select each table and make the necessary changes but it’s impossible it displays all the tables in one

image

Voici le message d’erreur

Hi @niang_wv, how many submission do you have in your form? does it more than 30000?

1 Like

@niang_wv, the first step is to download your data from the project UI. If you fail this step, you may not be able to connect your KoboToolbox data to Excel.

More than 50 000

It is a limitation of Kobotoolbox, if you data exceed the 30000 submission, the API mostly returns timeout errors. Please check the topic below for the solution