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

TOPIC: Problems exporting to "Excel"

Problems exporting to "Excel" 5 years 1 day ago #65033

  • HIV7
  • HIV7's Avatar
  • Offline
  • Bronze Donor
  • Posts: 73
  • Karma: 0
Hello Ls Team,

I just tried to export my survey to Excel. When I do this and try to open the File in Excel 2010, I got an Error Message. Attached you can find the exported File.

Can someone please tell me what to do or what is going on?

My Ls-Version is: Version 1.91RC4 Build 9797

THX,
HIV7
Last Edit: 5 years 1 day ago by HIV7.
The administrator has disabled public write access.

Problems exporting to "Excel" 5 years 6 hours ago #65089

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9305
  • Thank you received: 1330
  • Karma: 386
Trye to save the file on the desktop before open it.
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.

Problems exporting to "Excel" 5 years 4 hours ago #65097

  • HIV7
  • HIV7's Avatar
  • Offline
  • Bronze Donor
  • Posts: 73
  • Karma: 0
Hello,

I did save it before opening. In my view it's due to the amount of columns. Because I have ab out 280 Columns in my exportfile of the survey. I think I'd need an xslx-Export format to do that. So I have to split it (unfortunately)...

Or do you have any other idea?

Regards,
hiv7
The administrator has disabled public write access.

Aw: Re: Problems exporting to "Excel" 5 years 1 hour ago #65102

  • Earl
  • Earl's Avatar
  • Offline
  • Senior Lime
  • Posts: 41
  • Thank you received: 1
  • Karma: 3
Hi,

try export as .csv then import .csv to excel (do not just open the .csv with excel but import data from text....)
should work

Earl
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.387 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form