Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

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

Is there a way to export survey responses to an .xlsx file vertically?

More
2 years 9 months ago #233761 by ddanes
Is there a way to export survey responses to an .xlsx file vertically? was created by ddanes
Please help us help you and fill where relevant:
Your LimeSurvey version: [url=https://172.20.3.38/admin/globalsettings#modalSystemInformation]Version 5.4.8+221024[/url]
Own server or LimeSurvey hosting: Own Server
Survey theme/template: Vanilla
==================
Hello!

I was looking for a way to export my survey responses vertically in an excel document instead of horizontally as it does by default, is this possible? (Use rows instead of columns)

Also, I'm looking to increase my "max_input_vars", my LimeSurvey instance is hosted through an AWS EC2 instance, anyone know where I can access changing that variable?


Thank you!
 

Please Log in to join the conversation.

More
2 years 9 months ago #233775 by Joffm
Replied by Joffm on topic Is there a way to export survey responses to an .xlsx file vertically?
1. a. Excel:  Copy / Transpone    or Copy / Paste Special (Transpone)
1, b, To have a more customized result you may create an Excel macro

 
2. This setting you find in "php.ini"
Only, if you can access this file 
Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

More
2 years 9 months ago #233789 by ddanes
Replied by ddanes on topic Is there a way to export survey responses to an .xlsx file vertically?
Is there a way I can change it on the LimeSurvey end to auto export it that way?

Also, how would I go about accessing the php.ini file?

Thank you!

Please Log in to join the conversation.

More
2 years 9 months ago #233790 by Joffm
Replied by Joffm on topic Is there a way to export survey responses to an .xlsx file vertically?
1. No.
And two clicks in Excel are not too many.

2. Do you have access to the server?
Probably not.
If "yes", it is in the php-installation.
Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source