Translations:Exporting results/128/en
From LimeSurvey Manual
If you used Microsoft Excel to edit the exported vv file, the data structure of this file may be corrupted, so LimeSurvey is not able to import the edited file. You can try the following workaround to get the import working without an error:
- Open your exported vv file in Excel and do your changes (I guess you already did that)
- Save it as tab-separated text file (It creates a new file with the extension .txt)
- Do another "clean" vv export from LimeSurvey
- Open this new exported vv file with a texteditor like notepad or something else (I used textwrangler on mac)
- Press CTRL + A to mark all of the content and delete it
- Open the Excel edited vv file (the tab separated .txt file) with a texteditor and press CTRL + A to mark all of the content
- Press CTRL + C to copy the content and paste it into the new (now empty) vv file
- Press CTRL + S to save the file as it is (as .csv)
- Now try to import this file