Hi everyone! I'm starting to use LimeSurvey and hope I can get some help here. We need to export our responses.
I'm still a junior developer with some knowledge in javascript and learning python, so I thought the easiest way would be to export the answrers directly into a Google Sheets to analyse data.
I found and old VBA script shared
in this thread
. We are trying to adapt it but we are encountering two errors:
- with a questionaire with only one answer, the reponse arrived in the spreadsheet but as a sequencie of numbers separated by comma. All in one cell A1.
- with a questionaire with over 200 answers, the error says "The entry contains more than the max limit of 50000 carachters in one single cell."
I saved the adapted script
in this github repo
.
Can anyone help me on that, please? =]