Hi,

Can you explain me, step by step, how can I automatically export answers from a survey to excel?

Thank you!

What do you mean by "automatically"?
Each day at midnight?
After each complete?
Or what?

Too much work to click 5 to 8 times to do the built-in export?

Joffm

Automatically=After each complete
We are running telephone surveys and the interviewers need to access, in real time, an excel file with the updated answers to the survey

Thanks!

This is not built in.
And as long as you do not tell us what for this is needed (for quota management, for "least filled" options, or) we cannot know if this special feature is built in (or there is a workaround), so that you do not need an EXCEL file.

Of course, You may create your own script using the API.
Here a small example how to get the entire data by the API
forums.limesurvey.org/forum/can-i-do-thi...-sql-database#194005
As you see the data is displayed as a HTML table. This part you have to change so the data is saved to EXCEL, e.g. by using "phpSpreadsheet".

But only to have the updated, actual answers you'd better create a small dashboard for this.
With php and a chart library, either by direct access to the LimeSurvey database or by the API.


And you have the option to display the interesting cumulated results of the previous interviews in the next one using a plugin.

Best regards
Joffm

www.encuesta.biz/en/producto/limesurvey-...le-sheets-connector/

gitlab.com/SondagesPro/ExportAndStats/SpreadsheetTemplator (no free support)