Text copied from Excel produces 500 Internal Server Error

[jwkai]

When copying and pasting fields from a XLSX file opened in Excel (or Open Office Calc 4.1.11), a 500 Internal Server Error occurs.

This is presumably due to an illegal character, although this is not visible in the text input field.

Since in practice, researchers will input their data in this manner, this tool should handle such illegal input. It could either produce a more informative error message, or strip illegal text from the input (within reason).

Test file which reproduces the error (copy and paste all fields into the Text To Columns tool, then Run)
test_ttc_error.xlsx