Exporting large text fields to .xlsx without truncating?

Hello crazy angels. I am trying to export a table with a large text field from alteryx to excel. The field values for this field can be up to 1.2 million characters in length. When I export as .xlsx or .csv, it truncates the field to ~32k characters for each cell. Any ideas?

Output

Tips and Tricks

Accepted answers

geraldo

@structuredigital

Well, 32k is the excel column limit.
already for the csv has no limits.
Now if you generate the csv you will not be able to open it with excel use a text editor like Notepad++ or higher

also check if the columns are like V_string VW_String that support large amount of characters

Sheet and workbook specifications and limits

ResourceMaximum limit

open workbooks	Limited by available memory and system resources
Total number of rows and columns in a worksheet	1,048,576 rows by 16,384 columns
column width	255 characters
Line height	409 points
page breaks	1026 horizontally and vertically
Total number of characters a cell can contain	32,767 characters

All comments

structuredigital

Update:
It looks like I get an Output Data (14) error: "The output code page couldn't fully convert the value in the field.

geraldo

@structuredigital

Well, 32k is the excel column limit.
already for the csv has no limits.
Now if you generate the csv you will not be able to open it with excel use a text editor like Notepad++ or higher

also check if the columns are like V_string VW_String that support large amount of characters

Sheet and workbook specifications and limits

ResourceMaximum limit

open workbooks	Limited by available memory and system resources
Total number of rows and columns in a worksheet	1,048,576 rows by 16,384 columns
column width	255 characters
Line height	409 points
page breaks	1026 horizontally and vertically
Total number of characters a cell can contain	32,767 characters

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280