Excel Export Truncates Field at 255 Characters

[doogieb]

I have a field on the form that is displayed as a text area on the form, but when I export to Excel the text is truncated. I can view the data in a web export and it is all there. It appears to be stopping at 255 characters. I don't see an Excel setting to overcome this. Any ideas?

DoogieB
_________________
Regards,

Doug

[aytekin]

Try getting it in CSV format. The reports section has that option. Then open it in Excel.

Even when the CSV file is correct, if you open it in Excel, it might only show upto 1024 characters on a single cell. So, you might need to open CSV file on a text editor to see it in full. Or use some other kind of spreadsheet program that allows larger cell sizes.

Here is what Microsoft says about it:
http://support.microsoft.com/kb/211580

[doogieb]

Thank you so much for your comments and article reference. After reading the article and trying your suggestions, I'm afraid it still truncated the text, even well below the 1024 limit. Your suggestion did get the juices flowing, though, and I exported using the pipe delimiter (my favorite in programming, since it's just never used in any text files). Once I exported the text file I opened it in Excel (2007) and it ran through its import wizard. Viola! All my text displays, now, after setting the desired width and checking the wrap text property. I then saved as Excel, and it opens properly.

I really appreciate your help here. It seems this is an Excel issue, and not JotForm. I hope this post will assist someone else as well.

Regards and many thanks,

DoogieB