Exporting View Data

From Explore Analytics: The Wiki
Jump to navigation Jump to search

Introduction

You can export the data that's displayed in the view. The data is exported in CSV format, suitable for spreadsheet programs such as Excel and for import into other applications.

The data that's exported is the formatted display data.

Exporting View Data

While the view is displaying, select "Export this view's data" from the "File" menu. The data will be exported and a file will be downloaded.

Please beware that the data is formatted and some accuracy may be lost or truncated. Do not rely on this data for backup.

International Characters

The data is exported using the UTF-8 character set. Please make sure to select this character set when using this data, for example in Excel, to ensure accurate display of international characters.

To use a UTF-8 CSV file in Excel, follow these steps:

  • Open Excel with a blank new workbook
  • From the Data menu select "From Text" and select the CSV file
  • In the dialog, select "delimited" and then (very important!) for "File Origin" select "65001: Unicode (UTF-8)"
  • Click next and select "Comma" as the delimited and click Finish

Limitations

There is a limit to the amount of data to be exported. The limit is on the total number of table cells. In other words, the limit is on the number of rows times the number of columns -- hence the number of cells.

The limit depends on the type of view and the type of data source.

Export Limit for List Views

The limit for list views is higher for data sources that can stream the data, typically databases. For these data sources, the limit is 5 million cells. For example, if your list has 10 fields, you may be able to export up to 500,000 rows.

For other data sources, such as ServiceNow, the limit is lower and is 360,000 cells.

Export Limit for Pivot and Chart Views

Because Pivot/Chart data cannot be streamed, a lower limit is implemented. Internally, the query limit is 360,000 cells. That's the number of cells that are requested from the data source. The data is then transformed into a Pivot table and the exact number of rows that this translates to is hard to predict. This is true for both Chart and Pivot because they are both processed in the same way.