Welcome to the LimeSurvey Community Forum

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

Export to SPSS - The columns label in Excel does not communicate with the spss

  • abhijeet1810
  • abhijeet1810's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 4 months ago #224103 by abhijeet1810
Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Theme: Export to SPSS - The columns label in Excel does not communicate with the spss 

==================
[Write here your question/remark]
Hello, 
I need urgent suggestions please. 

I have exported .dat and .sps files from my survey for SPSS (i have tried prior and after v16 spss files). 

however The columns label with dat file in Excel format does not communicate with the spss

could you kindly suggest what i should be doing in such a case?
 
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 4 months ago - 3 years 4 months ago #224106 by Joffm
Hi,

I need urgent suggestions please. 

But you do not show anything.
If it is so urgent, you should do the very best to help us help you.
Shall we really create a survey (we do not know your survey design), activate it, enter some data, then export to EXCEL and SPSS to be able to reproduce what you are talking about?

No, no, it's up to you to provide a lss export of your survey and explain - e.g. by screenshots - where you see issues.

Or did you have a different setting in your EXCEL export.
You see there are several options how to export to EXCEL
  • questions (question code, abbreviated text, fll text)
  • answers (answer code, full answers)

One last word:
In my opinion one of the first tasks is to adapt the VARIABLE LABELS and VALUE LABELS to your needs in analysis.
Very often there are hints for the participant in the question text that you do not want in your analysis; or in array questions the question text and the subquestion texts are joined - and sometimes truncated.

Joffm

P.S. And why didn't you answer the questions at the beginning about your LS version and whre it is hosted?
 

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 3 years 4 months ago by Joffm.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
3 years 4 months ago #224158 by DenisChenu
Else :
www.limesurvey.com/integration

And www.acspri.org.au/limesurvey are the company create the SPSS plugin.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose