Spreadsheet node cropping text at 255 characters

[kinreas]

Describe the problem/error/question

I have a PostgreSQL node running a query that extracts some very long text. The result of the query is then used in a Spreadsheet node to generate a .XLS file, however the text is cropped at 255characters. How can i solve this?

Please share your workflow

Information on your n8n setup

• n8n version: 0.231.3

[EmeraldHerald]

Hi @kinreas

Not too sure if this will help, but can you check out this post and see if this is a solution for you?

Spreadsheet File text length limit for xlsx?

Hi @Bahadur, your input looks like a single long string. So you’re probably right about having to split it. I am not 100% sure how exactly your data looks like as n8n does not display line breaks in JSON view. However based on your description I suspect something like this would do the job: This first splits up your data into rows on newlines (\n), then each row into fields using the comma , (and trimming any additional spaces). If that’s not it, could you copy the raw…

[kinreas]

Hello @EmeraldHerald,
That’s not the same issue that i’m facing.
My problem is that if a text is longer than 255 characters and I try to put it in a CSV file using the Spreadsheet Node, it gets cropped to 255.

[EmeraldHerald]

Had a further look into this - Versions of Excel before 2007 were limited to 255 characters in a cell, and this was changed when the XLSX / XLSB format was released. To fix this issue, change the File Format to XLSX in the dropdown and it will work.