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 |