In this document
We will show you how to export datasets in to various formats, including CVS, Exchange file, PVSyst standard format, and Solargis JSON and parquet files.
Exporting the datasets
Analyst offers dataset exports in various formats to accommodate different scenarios. You can export datasets as:
CSV file: Standard CSV file format readable by most applications.
Exchange file: Creates an Analyst-specific file to transfer data between Analyst applications. Ensures no loss of data and a smaller file size.
PVsyst standard format: Exports the dataset in PVsyst-compatible format.
CSV file export
Open the CSV export from the main menu via Dataset/Export/CSV.
Choose how you want to export the header information.
Use the checkboxes in the Columns section to include/exclude parameters from the export.
Select how to export the maintenance logs. The maintenance log header can only be imported if it is included in the data table. It cannot be imported via the importer on its own.
Browse the folder where the export will be saved.
Click “Export” to initiate the export.
Export exchange file
Exchange files are Analyst-specific files created for seamless import/export of the datasets between various Analyst applications or projects. The exchange file ensures that all metadata is correctly exported and no values will be lost or misinterpreted. Use this export type when you plan to transfer a dataset to another Analyst instance or project. It will save the exchange file to the selected location in the export window.
Note: The exchange file size is smaller compared to the CSV export.
PVsyst Standard Format file export
PVsyst Standard Format export will export the data to the PVsyst-compatible format.
Important: PVsyst Standard Format export supports harmonized datasets without gaps and with hourly temporal resolution only.
Open the PVsyst export from the main menu via Dataset/Export/PVsyst Standard Format.
Select the dataset to export.
Use the checkboxes in the Columns section to include/exclude parameters from the export.
Browse the folder where the export will be saved.
Click “Export” to initiate the export.
Exporting Solargis JSON or parquet files
If you want to export the database to Solargis JSON or parquet file, go to Database/Exports and select the relevant export. Enter the name of the export file and click the “Save” button.
Solargis JSON file: Text-based, self-describing file following the public Solargis dataset schema. Best for transparency, archiving, and integration with your own scripts or third-party tools.
Solargis parquet file: Compressed columnar binary file carrying the same metadata. Roughly 3× smaller than the JSON equivalent and much faster to load in analytical environments. Best for large, high-resolution datasets.
