Translations:Exporting results/170/en
From LimeSurvey Manual
This is a partial workaround that seems to work in 1.82-essentially, only use Excel on the part of the file that is the data:
- Export a question similar to what you would like to reuse as .csv file
- Open the CSV file in a rawtext editor
- Copy the part that has the answers to Excel, and parse it with Text to Columns or equivalent.
- Use the talent of Excel to allow pasting text in columns to paste in 20, 50, 100 answers, as you wish
- Save the file as Excel CSV, which will likely have no quotes.
- Open this file in the editor, and Select All, Copy
- Go back to the file you opened with the rawtext editor
- Paste over the answers there
- Save AS, with a different name, maybe one that you can remember for reuse
- Import this file.