Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Export
Export the data resulting from your analysis to various destinations.
Excel workbook export settings
Fields and options for downloading the data to a Microsoft Excel workbook file.

Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
- Analyze
  The Analyze tab displays the object browser and the Analysis Timeline.
- Query
  The Query tab displays the current timeline query as Macro Language XML code. It also provides the ability to undo and redo operations in the timeline.
- View
  Select among the ways to view and interact with the data resulting from your analysis.
- Visualize
  The 1010data Insights Platform provides a mechanism to generate high-quality charts, which in turn can support the notion of visual data discovery.
- Develop
  Use the query that represents your analysis as a base for further development.
- Export
  Export the data resulting from your analysis to various destinations.
  - Delimited text export settings
    Fields and options for downloading the data as a delimited text file.
  - Excel workbook export settings
    Fields and options for downloading the data to a Microsoft Excel workbook file.
  - PDF export settings
    Fields and options for downloading the data to a portable document (PDF) file.
  - Download the data as a delimited text file
    Download the data resulting from a query as a delimited text file.
  - Download the data as an Excel workbook file
    Download the data resulting from a query as a Microsoft Excel workbook file.
  - Download the data as an Apache Parquet file
    Download the data resulting from a query as an Apache Parquet file.
  - Download the data as a PDF file
    Download the data resulting from a query as a portable document (PDF) file.
- Results pane
  The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.

Excel workbook export settings

Fields and options for downloading the data to a Microsoft Excel workbook file.

The Excel workbook export settings allow you to customize an exported file to suit your needs. The file extension of the exported file is .xlsx.

Figure 1. Export settings for Excel workbook files

Export formatted data: If selected, keep the display format is it is in the 1010data table (such as date and currency formatting).
Format as a table: If selected, the exported Excel workbook file is saved as an Excel Table object and formatted. If not selected, the exported Excel workbook file is not formatted and appears as a plain, non-styled worksheet.
Format big integers as decimals: If selected, if big integers exist in the 1010data table, convert to decimals in Excel.
Include query text in worksheet: If selected, the exported Excel workbook includes the text of the Macro Language query.
Filename: By default, exported .xlsx files are named exported.xlsx. You can choose to name the exported file something else by entering a new name in this field.
Export: Click Export to export the query with the selected settings.