Welcome to the LimeSurvey Community Forum

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

Extract LS responses in Google Sheets

  • Tiudivnet_418126
  • Tiudivnet_418126's Avatar Topic Author
  • Offline
  • Banned
  • Banned
More
10 months 2 weeks ago #244017 by Tiudivnet_418126
Extract LS responses in Google Sheets was created by Tiudivnet_418126
Please help us help you and fill where relevant:
Your LimeSurvey version: [Version 5.6.25]
Own server or LimeSurvey hosting: 
Survey theme/template: 
==================
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.

Lime-years ahead

Online-surveys for every purse and purpose