Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Extract LS responses in Google Sheets

  • alinebw
  • alinebw's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #244103 by alinebw
Extract LS responses in Google Sheets was created by alinebw
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? =]

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose