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.

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.

Export

Export the data resulting from your analysis to various destinations.

You can choose to download the data as delimited text, Microsoft Excel workbook, or PDF file. In addition, you can export the data to your 1010data FTP directory or save the data to a 1010data Insights Platform table.

Figure 1. Export tab in the Trillion-Row Spreadsheet

Delimited Text: Download the data as a delimited text file, such as a comma-separated values (CSV) file. Selecting this option displays the delimited text export settings.
For more information, see Delimited text export settings.
Microsoft Excel: Download the data to an Excel workbook (XLSX) file. Selecting this option displays the Excel workbook export settings.
For more information, see Excel workbook export settings.
Apache Parquet: Export the data as an Apache Parquet file.
For more information, see Download the data as an Apache Parquet file.
Portable Document: Download the data to a portable document (PDF) file. Selecting this option displays the PDF export settings.
For more information, see PDF export settings.
FTP: Export the data to your 1010data FTP directory. Selecting this option opens the Save Data to FTP window.
For more information, see Save Data to FTP.
Table: Save the data resulting from your analysis to an Insights Platform table. Selecting this option opens the Save Data as Table window.
For more information, see Save Data as Table.