Forum Discussion
Exporting to Excel Truncates after 255 Characters
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?
Hi Anonymous,
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-269d656771c3
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
2 Replies
v-danhe-msftMicrosoft Employee
Hi Anonymous,
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-269d656771c3
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
- v-danhe-msft
Hi Anonymous,
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