Problem while loading a csv file


I am getting this error while loading a csv file:

Error: Maximum string length (65534 characters) exceeded

But if I save it as an excel book easymorph lets me load it. How can i fix this issue? Transforming all csv files to excel workbooks would be hard since I have many files like this one.

I think the problem is caused because the file has 5300 columns, so the names of the headers sum lots of characters. Is there a limit to the number of characters the columns headers can have?


1 Like

Hello Sebastian,

Yes, there is a limit on the number of characters in the column headers line. It was added in order to prevent the application from hanging on the column list loading when a malformed file is specified.

We increase that limit to 200 000 characters. We assumed that it will be enough to make it possible to import that file. You can get the updated version from our website: