Exporting to Excel Truncates after 255 Characters

[mlchan]

As title describes, when attempting to export a table where the cell values are quite long (longer than 255 characters) the csv export has each cell truncated down to 255 characters. Is there any way around this that anyone knows of? 

[v-danhe-msft]

Hi @mlchan,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @mlchan,

Based on my research, there is a limitation of column width in Excel, you could refer to this link: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269...

If you want to see the whole characters of your data, I suggest you to open the exported csv file with Notepad.

Regards,

Daniel He