Download your search
You can download your search as either a table or chart. You have the option to download your table as a CSV (comma separated values), PDF, or XLSX (Excel) file. When you download a chart, it will be a PNG file. If you do not see all the search download options, your company may have removed them. If you would like to download your search in one of these formats, contact your ThoughtSpot administrator.
Currently, ThoughtSpot limits the maximum number of rows that can be downloaded to 10M (default is 1M). Your system limit is configured by your ThoughtSpot administrator.
Download a chart or table
| Your administrator may have set a standard footer for all answer and Liveboard downloads. If you have admin privileges, you can edit that footer for the whole cluster from the Admin Console. If you do not have admin privileges, you cannot edit the standard footer for downloads. |
To download your search, click the More icon 
, and select any of the following options, depending on your search type:
-
For a table, choose Download as CSV, Download as PDF, or Download as XLSX. Note that this does not include pivot tables. ThoughtSpot classifies pivot tables as charts.
-
For a chart, select Download.
Table formatting
When you download tables, the format in the downloaded table may look different. The following table describes the behavior for formatting in downloaded tables. If a formatting type is Supported, the formatting in the downloaded table is the same as the formatting in ThoughtSpot. Note that this does not include pivot tables. ThoughtSpot classifies pivot tables as charts.
| Formatting type | XLSX download | CSV or PDF download |
|---|---|---|
Number formatting |
Supported, with limitations |
Not supported |
Number formatting based on custom format patterns |
Supported |
Not supported |
Conditional formatting |
Supported, with limitations |
Not supported |
Column order |
Supported |
Supported |
Custom calendar |
Supported |
Supported |
Table themes |
Not supported |
Not supported |
Text wrapping |
Supported |
Not supported |
Content density |
Not supported |
Not supported |
Column width |
Supported |
Not supported |
Table summaries |
Not supported |
Not supported |
For number formatting, the following limitations apply:
-
Auto formatting shows only the raw number
-
Locale-based thousands separators are based on locale settings from your computer in Excel or from your Google Sheets locale settings in Google Sheets
-
The currency symbol in the downloaded table may be different from what is visible in ThoughtSpot
-
For India, Japan, and Afrikaans locales, the downloaded table shows only the raw number, and the comma separation is based on the locale
For conditional formatting, the following limitation applies:
-
Bold, italics, underline, and strikethrough are not supported
Date columns for tables
When you download tables with date columns or view these tables in scheduled Liveboards, the format for those dates may differ from their appearance in ThoughtSpot, depending on the type of download.
XLSX files appear as they do in ThoughtSpot, but CSV and PDF files may look different. The following date bucketing types may look different for CSV and PDF downloads:
| Bucketing Type | Appearance in ThoughtSpot and XLSX download | Appearance in CSV or PDF |
|---|---|---|
Hourly |
AM/ PM |
24 hour |
Day of week |
Name of day (for example, Saturday) |
Number of day (for example, 6)[1] |
Monthly |
January 2021 |
1/1/2021 |
Month of year |
Name of month |
Number of month[2] |
Quarterly |
Q1 2021 |
1/1/2021 |
Quarter of year |
Name of quarter (for example, Q4) |
Number of quarter (for example, 4) |
Yearly |
2021 |
1/1/2021 |
