Hi,

i created two identical surveys with limesurvey (One in english, one in german). Now i want to merge the answers into one "List". I exported both results to excel and merged them into one list.
Now my question: Is it possible to re-import these new List? I did not find out how to do.

If it is not possible, it would be great if you can give me another solution (tool, or something else) to evaluate the results.

thank you

Have a look at VVExport and VVImport - docs.limesurvey.org/Exporting+results&st...Export_and_VVImport_

For data analysis using LS features:

You can use vv.csv files export/import features

1) Export english + german results (vv.csv files)
/!\ Backup those 2 files in case of.... :evil:
2) Open english one (with text editor not as spreadsheet) and add responses related lines from german file (don't touch the 2 first lines with the columns IDs)
3) If your survey is off, desactive it; A backup answer table will be created to restore those results if further need...
4) Import your "composite" vv file to your english version survey


Ben/

thanks, i will try and give feedback

This might not work if you are not using the exact same question, answer and subquestion codes.

In this case SPSS should offer features to merge such data files.

Mazi wrote: This might not work if you are not using the exact same question, answer and subquestion codes.

Yes, i found that out, thanks.
But after i corrected the codes, everything was fine. Import after editing (as i expected) did not work. To solve this i did a new, "clean" vv-export, pasted my edited list in this new created file (deleted the new exported data out of it before), saved it and imported this one. Works perfectly.

Thanks for your help guys.

Thanks for ths additional nstructions. Please also help other by improving our manual at docs.limesurvey.org/Exporting+results&st...Export_and_VVImport_
Would be great if you could extend it after what you have learnt.

Mazi wrote: Thanks for ths additional nstructions. Please also help other by improving our manual at docs.limesurvey.org/Exporting+results&st...Export_and_VVImport_
Would be great if you could extend it after what you have learnt.

Did it here: docs.limesurvey.org/Exporting+results#Im...ing_a_VV_survey_file

Thanks!

I think you are facing issue in exporting data to excel. If yes then I have something to share with you.

after trying the solution mentioned in the below given link, i am very much sure that you can easily get rid of the Excel data exportation issue.

So, check it out…..!

source:
[link deleted - Reason: spam]