Export Results as CSV file

circle-check
circle-exclamation

Our system supports exporting results in CSV format. This is ideal if you need to work with data in a flexible, machine-readable format for further processing or integration with other systems.

The CSV file contains one row for each batch (single or 3-side analysis), generic fields like image ID, subject ID, date/time, image quality parameters, and all calculated skin parameters (metrics). The results are stored for each facial area, column names reflect related algorithm and area names.

Naming convention

Face Skin Analysis 3.0

The naming convention for the Face Skin Metrics 2.0 adopts the following pattern:

  • Main results for the whole face area: <parameter>_<result>. For example, for the Lines, it is:

    • lines_tag

    • lines_grade

    • lines_score

  • Results for the whole specific area: <parameter>_<face_area>_<result>. For examples, for the Lines parameter, it is:

    • lines_forehead_amount

    • lines_forehead_length

    • lines_left_eye_amount

    • lines_left_eye_length

    • lines_right_eye_amount

    • lines_right_eye_length

    • lines_perioral_amount

    • lines_perioral_length

Face Skin Metrics 2.0

The naming convention for the Face Skin Metrics 2.0 adopts the following pattern: <parameter>_<face_area>_<result>.

For example, for the "lines" algorithm the column names are:

  • lines-face-Lines Score

  • lines-forehead-Lines Score

  • lines-left_cheek-Lines Score

  • lines-left_eye_area-Lines Score

  • lines-left_eye_corner-Lines Score

  • lines-right_cheek-Lines Score

  • lines-right_eye_area-Lines Score

  • lines-right_eye_corner-Lines Score

  • lines-face-Jowls Grade

  • lines-face-Sagging Score

circle-check
circle-exclamation

CSV Export Field Reference

You can find the description of all fields in the following Google Sheets: CSV Export Fields Description for Face Skin Analysis 3.0arrow-up-right.


Export Results as CSV from SaaS B2B UI

  • Go to the “CSV export” tab.

  • Click on the “Schedule CSV export” button.

  • Select the period for the export.

  • Select the set of metrics that you want to export. Currently, there is two options: export Face Skin Metrics 3.0 results or export Face Skin Metrics 2.0 and other metrics.

  • Select the export settings. You can select what parameters to export, what data to export (scores, grades, tags, statistical parameters) and what areas you want to export.

  • In case if you datasets is a study dataset, you will be able to select stages and parameters to export

  • Click Export to schedule an export. You will see your export being scheduled. Depending on the amout of data, the report might take some time to process.

  • Update the page to see the updated status.

  • Click to Download CSV to download the CSV.


Exporting Results as CSV from API

circle-exclamation

For technical implementation details, such as request format and available filters, please refer to the CSV export API documentation.

Opening CSV file in Microsoft Excel

Due to the complexity of the CSV file structure, Microsoft Excel may not display the CSV file correctly if you open it directly. The instructions below will help you open the file so that it is ready for use and reading.

On you Mac

  1. Open Microsoft Excel.

  2. Create a new file.

  3. In the Menu bar select File and then select Import.

  4. In the opened window, select CSV file.

  5. Click Import and select the file you want to work with.

  6. On the step 1 of the wizard, select Delimeted and click Next.

  7. On the step 2, select Semicolon as delimeter.

  8. Click Finish.

  9. Select where to put the data and click Import.

  10. After that Excel will import the data to your spreadsheet.

On your Windows

  1. Open Microsoft Excel.

  2. Create a new file.

  3. In the Menu bar select Data and then select From Text/CSV.

  4. In the opened window, select CSV file.

  5. Next, select Semicolon as delimeter.

  6. Click Load.

  7. After that Excel will import the data to your spreadsheet.


circle-exclamation

user-vneckTalk to sales

Last updated

Was this helpful?