Once you have configured a sensor in EKO Q, you can import its measurement data from a file. Follow the steps below to upload a file, clarify its format, and confirm the import.

1. Open the sensor data import

Select the configured sensor from the site navigation, then click “Import Data” on the sensor page.

2. Select a data file

Click the file selection area or drag and drop your data file into the Import Data panel. Click “Upload” to continue.

3. Prepare the data file

For the smoothest upload process, it is recommended to use a standard CSV file format.

The file should contain at least two columns:

• Timestamp
  First column, optionally named “timestamp”, containing date and time in a common format, such as:
  2024-12-31 08:00:00or 2024-12-31 10:00:00+0200
• Irradiance
  Second column named according to your sensor (e.g. “MS-80_1”), containing irradiance data in W/m², for example:
  580.01

Example of a supported format

timestamp_UTC;MS-80_1;GHI_2;GHI_3
2025-05-24 00:00:00;-0.4;0.0;0.0
2025-05-24 00:01:00;-0.3;0.0;0.0
2025-05-24 00:02:00;-0.3;0.0;0.0
...

EKO Q support variety of formatting options from different regions, operating systems and conventions, it automatically detects the file format. Some custom formatting may be unclear to EKO Q, and you can overview and adjust the format detection with a step-by-step dialog. At each step, review the original file, detected formatting parameters and parsed preview with standardised formatting.

A “Detected” label identifies the automatically selected option. If EKO Q detected it wrong, select the correct option.

The color of a selection indicates whether the chosen option matches the data and the parameters set on earlier steps:

• Green: no errors detected for this selection.
• Orange: a potential issue requires attention.
• Red: the selection is invalid and would lead to further errors. A tip explains the problem

Time zone

If the timestamps do not include a UTC offset, select the correct timezone manually. EKO Q will independently verify the time zone match further.

5. Review and confirm the upload

In the final “Review & confirm” step, check the summary of the chosen format parameters. You may be offered to save the parameters as a template for future imports of files with the same structure.

Click “Preview data” to inspect the parsed readings and check how many rows contain errors. Check for errors, if any, and consider cleaning the data file outside EKO Q.

Note: Many erroneous lines typically signify a mistake in format selection. You can go back and change any parameter before confirming. 

Note: EKO Q discards any rows with errors. Other valid rows can still be uploaded successfully.

When everything looks correct, click “Confirm” to start uploading the data.

Next steps

After importing your data, verify the result by running a sensor data configuration check: Run a sensor data configuration check.