In Astrato there are multiple ways to export data.
Type | Method | Use cases | Embed support |
Data | Context menu / right click export to CSV/Excel | Filter data to suit your analysis and use in a selected object, up to 1 million rows. (In Excel, there is an option to export metadata that includes the underlying query, user, and time.
| ✅ Supported |
Image/PDF | Context menu / right click export to chosen graphics format | Export chart as it is shown on screen | ✅ Supported |
Image/PDF | Click a button to export an object/group/sheet to image/PDF | ✅ Supported |
ℹ️ Learn more about generating PDFs with Scheduled PDF Reporting
Exporting Data Objects
Please note: Data object export has a maximum limit of 1,000,000 rows.
In your draft or published workbook, right-click on your data object to view the Export to options for CSV or XLSX.
Download and print your export.
Special settings for export:
Custom null vlaue for export- defince a value to replace any null vlaues in the exported data.
Add metadata to export- (Excel Only) Adds a second sheet to the export file, the information added includes:
The underlying query
User and time of the export
Source semantic layer
Data Exports - Add Custom metadata to data export files
Exports can provide additional information to help users understand the origin of the export, from workbook name, down to the object and even the entire query. What is included in the export is optional.
For XLSX files, the metadata is added to a separate sheet. For CSV export files, the metadata is added to a separate CSV, which is downloaded as a zip, containgn a data file and a metadata file.
Options available:
|  |
Pulling a custom value from a database, into a variable
You can pull a value from a database in case you want to retrieve a shared value, to use in the custom export.
Use cases
Legal notices → in the event you require a copyright / disclaimer / fair use notice, you can add that here.
Link to dashboard → guide users back to where they exported the data.
Tokenized exports → track exports back to specific requests/instructions from Astrato.
Audit & governance → use the export to track who exported what charts, when, and on which semantic layer for compliance and support.
Faster debugging → copy the exact SQL behind a chart to validate logic, test performance, or reproduce queries in the data warehouse.
Personalisation at scale → use Custom Input key/value pairs to pass information of your choosing into export metadata, such as IDs, tokens, locale, or scenario configuration.