You can export data as an email, PDF or other file type. Whatever data is currently displayed on your screen will be exported, with some limits on the size of the dataset. You can also copy data directly from the grid to paste into another application, e.g., Excel.
Note that you need to have permission to export or copy.
Permission to export and copy is set via individual 'Export' check boxes in profile settings. Administrators can refer to Assign profiles to users for more information.
About this option
Using this option
Converts the data currently on your screen into a print-friendly format.
Only data can be printed. The status bar displays automatically.
Select Export > Print. Then follow your usual printing process.You can also select Options > Monochrome exports to export and print in 'black only'.
Exports as a PDF.
Only the data is exported. Selections or period ranges may not be visible in the exported file. Formatting, such as red data for negative values, carries across.
Select Export > PDF. Different browsers will handle an exported file differently. You may be prompted to open or save the file, or it may appear at the bottom of your screen or in your downloads folder.
Exports as a Microsoft Excel worksheet
Only the data is exported. Formatting such as red data for negative values carries across.
Sheet 1 of the worksheet contains the data and Sheet 2 contains information relating to the export such as selections and period ranges.
Select Export > XLSX. You may be prompted to open or save the file, or it may appear at the bottom of your screen or in your downloads folder.
See note about limits on number of rows and columns.
Exports as a CSV (Comma Separated Value) file, a file format commonly used as an alternative import/export format.
Select Export > CSV. You may be prompted to open or save the file, or it may appear at the bottom of your screen or in your downloads folder. See note about limits on number of rows and columns.
Emails your current analysis (data, chart or map) to a specified recipient. Only users with a valid username and password will be able to open the hyperlink to view the data. Permissions also apply, i.e., if a user is emailed data they would not normally have permission to view, they won't be able to open the hyperlink.
The 'from' name will be your username and the reply address your email address.
Administrators may need to add SMTP settings for this feature to function correctly. See Configure SMTP settings to send emails
Select Export > Email. A screen will appear containing your own email address – you can replace this with another recipient's email address or enter multiple email addresses separated by a semicolon.
Exports as a KML (keyhole markup language) file, a format used to display geographic data in an Earth browser or open source map. Use this option when exporting a map chart.
From a map chart select Export > KML.
|Copy||You can copy rows of data or individual cells from the grid to paste into another application, e.g., Excel. Even though this is done directly from the grid, it is classed as an export' option.|
From the grid either right-click > copy, or select a row or cell and then CTRL+C (or CMD+C on a Mac).
Note that you need the 'Clipboard' option checked within the Export box in profile settings. Assign profiles to users for more information.
Limits on number of rows and columns
If you try to export too many rows or columns, some export options in the dropdown list will gray out and not be available. For example, if you tried to export 70,000 rows you might only see the 'CSV' option.
- XLSX supports up to 1,048,576 rows and 16,384 columns.
Very large exports may return an error message. If this occurs, check that you really want to export the entire dataset. You can filter or make selections and focus to reduce the dataset to the information you require.