Data Export Limit Reference
Export Card Related
To be compatible with Excel 2007, all exported Excel files have the following limitations, regardless of how large the backend setting limit is:
Maximum rows: 1 million rows,
Maximum columns: 16 thousand columns,
Maximum parameters for a single function: 255,
Maximum cell format types: 64,000,
Maximum characters per cell: 32,767
The total number of available rows is 1M (2^20)
The total number of available columns is 16K (2^14)
The maximum number of arguments to a function is 255
Number of conditional format conditions on a cell is unlimited (actually limited by available memory in Excel)
Number of cell styles is 64000
Length of text cell contents is 32767
Export Table Data with evaluate and template
Server Memory | Maximum Supported Table Size |
3G | 40K rows 30 columns |
8G | 140K rows 30 columns |
16G | 260K rows 30 columns |
Export Table Data without evaluate but with template
Server Memory | Maximum Supported Table Size |
3G | 600K rows 30 columns |
8G | 1M rows 30 columns |
16G | 1M rows 30 columns |
Export Table Data without evaluate and without template
Server Memory | Maximum Supported Table Size |
3G | 1M rows 30 columns |
8G | 1M rows 30 columns |
16G | 1M rows 30 columns |
Export Raw Data Excel
Server Memory | Maximum Supported Table Size |
3G | 1M rows 30 columns |
8G | 1M rows 30 columns |
16G | 1M rows 30 columns |