Exporting View Data

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.

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.

Limitations

There is a limit to the 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 is managed in memory on the application server, a lower limit is implemented. The limit is 360,000 cells. For example, if your Pivot table has a total of 5 fields (in the row, column, and value areas), you can export up to 120,000 rows. If you have 8 fields, then you can export up to 45,000 rows.

⇦ View Editor

⇧ Table of Contents

⇨ List