Download and Export Limitations
Sigma provides many ways to download your data or export it to other systems. In addition, you can upload CSV files to Sigma. Limits apply, as described in the following tables.
One million row export limitation for all exports
Sigma has a 1 million row export limit for all exports. If your data exceeds the limit, Sigma trims it to 1 million rows.
Download or export file type limitations
Sigma has the following limits for downloading or exporting file types.
| Download or export type | Limits |
|---|---|
| CSV (.csv, a comma-separated text file) | 1 million rows |
| Excel |
1 million rows Max columns: 16,384 Max string UTF-8 characters: 32,767 Max URLs: 65,530 Max URL length: 2079 characters Max cell limit for pivot tables: 5 million If any limit is exceeded Sigma trims the data down to the limit. |
| PNG | No download limit. |
|
PDF: general |
No download limit. |
|
PDF: tables and pivot tables |
By default, table and pivot tables in exported PDFs only display the number of rows that appear on the dashboard. To display more rows in your export, there is an option to show up to 1,000 rows per table. You cannot export more than 1,000 rows per table. |
Destination limitations
Sigma has the following limits for export recipients and destinations.
| Destination | Limits |
|---|---|
|
30MB, combined for all attachments. An error message occurs if the limit is exceeded. |
|
| Google Sheets |
5 million cells per table. Sigma trims cells exceeding the limit. Google's limit is 10 million cells per sheet file, including all tabs. If you export to an existing sheet such that the sheet becomes larger than 10 million cells, there will be an error. |
| Slack |
1GB single file limit. An error message occurs if the limit is exceeded. |
CSV upload limitations
The maximum file size for uploading a CSV (.csv) file is 100MB.
