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

TOPIC: Problems exporting to "Excel"

Problems exporting to "Excel" 5 years 3 months 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 3 months ago by HIV7.
The administrator has disabled public write access.

Problems exporting to "Excel" 5 years 3 months ago #65089

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9600
  • Thank you received: 1376
  • Karma: 390
Trye to save the file on the desktop before open it.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (use private message).
The administrator has disabled public write access.

Problems exporting to "Excel" 5 years 3 months 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 3 months 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.
Time to create page: 0.232 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form