Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Rows instead of columns

Rows instead of columns 5 years 4 months ago #63708

  • phousing
  • phousing's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Can anyone help?

My survey contains 389 responses. As my version of Excel is limited to 255 columns, I can't export all responses at once. A solution to this would seem to be exporting data as rows instead of columns - but I can't find a way to do this.

Is this possible with Limesurvey, or is there another way round? Exporting twice seems like a bit of a clumsy and time-consuming solution.

Thanks,

Luke
Last Edit: 5 years 4 months ago by phousing.
The administrator has disabled public write access.

Rows instead of columns 5 years 4 months ago #63715

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6566
  • Thank you received: 1477
  • Karma: 578
Unfortunately it's not possible to export that way.
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Last Edit: 5 years 4 months ago by tpartner.
The administrator has disabled public write access.

Rows instead of columns 5 years 4 months ago #63716

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5417
  • Thank you received: 806
  • Karma: 239
I am a little confused: with responses do you mean completed questionnaires or answers for within one questionnaire?

As the answers of reach respondent are usually stored in the lines, I assume you mean that you have 389 answers to questions.

I don't think that there is much to do within Limesurvey. The problem is the limit of your excel. I don't think that you will find something that is less clumsy and time-consuming than exporting 2 files. Actually exporting 2 files isn't too much.

But, if you want to do it in a different way: you could always download the newest version of LibreOffice/OpenOffice. They can work with more than 255 columns. Then you either use this software to work with on the data, or you copy the data, transpose it and then you should be able to open it in Excel, as long as you have less than 254 participants...
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | [url=https://manual.limesurvey.org/Workarounds[/url]

If you found this answer helpful and it saved you some time please consider a [url=https://donate.limesurvey.org[/url] to the...
The administrator has disabled public write access.

Rows instead of columns 5 years 4 months ago #63718

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5417
  • Thank you received: 806
  • Karma: 239
tpartner wrote:
Unfortunately it's not possible to export that way.

Tpartner, you must be some kind of vampire... :evil: do you never sleep?
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | [url=https://manual.limesurvey.org/Workarounds[/url]

If you found this answer helpful and it saved you some time please consider a [url=https://donate.limesurvey.org[/url] to the...
The administrator has disabled public write access.

Rows instead of columns 5 years 4 months ago #63720

  • phousing
  • phousing's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thanks for your reply.

I want to export the results that I've got from completed questionnaires. The nature of the questionnaire is that there are 389 possible responses - but those questioned won't always give 389 answers. However, this still produces 389 results, including blank answers.

Unfortunately, as I work for a local authority I'm stuck with my old version of Excel, and can't download OpenOffice. You're right though, it would be a much better spreadsheet to use.

Thanks again,

Luke
The administrator has disabled public write access.

Rows instead of columns 5 years 4 months ago #63721

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6566
  • Thank you received: 1477
  • Karma: 578
Only when the sun is up :laugh:
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The administrator has disabled public write access.
Time to create page: 0.312 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form