When I add the attached question to my tab-delimited file, the import is not successful any longer. It says 'import of the survey is completed' but it shows zero groups and questions (second attachment), and when I click on 'go to survey' it says 'internal server error' (third attachment). I have omitted other questions/groups in the survey from the first attachment for simplicity. Any help much appreciated!

Look at a simple TSV file : there are Survey and group before the 1st question.

You need Survey and one Group before 21st question.

There still an issue : LimeSurvey muts check it for you (and give you a clean information) : you can report.

Thanks Denis, sorry if I wasn't clear in my message, I have got other groups and questions in my survey but I removed them in that attachment so that readers can quickly see the problematic question without having to browse through a lot of guff.
Anyway, I have solved the issue, it was caused by a combination of me doing copying and pasting from Word to Excel and UTF-8 encoding. Basically Excel was converting some characters like the apostrophe into funny characters and that was causing LimeSurvey to detect them as non-English, hence the error message about languages. Here is my 'cookbook' for avoiding this issue:
- first either (a) copy your text in Word, paste it into Notepad, save that document BUT CHOOSE UTF-8 ENCODING AT THE BOTTOM OF THE SAVE WINDOW, or (b) save your Word document as ‘Plain Text’ and in the following window choose ‘Other encoding’ => Unicode (UTF-
- then copy text from that Notepad / Word document and paste it into LimeSurvey Excel form
- then save that Excel document as UNICODE, not tab-delimited!
- the reason is that the default encoding of a text file is ANSI and it converts characters like ‘ to funny ones which are then not recognised by LS as English characters

:laugh:

Else : my advice for TSV file : www.libreoffice.org/discover/calc/

When you export, juts rename txt to tsv and : nothing other to do.