> For the complete documentation index, see [llms.txt](https://docs.saas.haut.ai/haut.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.saas.haut.ai/haut.ai/haut.ai-features/datasets/csv-file-with-raw-statistics.md).

# Export Results as CSV file

How to export analysis results as a CSV file from the Haut.AI SaaS interface or the API, and what each field in the file contains.

{% hint style="success" %}
Export as CSV file feature is available for <mark style="color:green;">**all**</mark> plans
{% endhint %}

{% hint style="warning" %}
Export via API is available only for <mark style="color:purple;">**Professional Plan**</mark> clients.
{% endhint %}

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`

{% hint style="success" %}
Please note, that the "overall" metric value is stored in the "face" area field (lines-face-Lines Score).
{% endhint %}

{% hint style="warning" %}
Note that only those batches/images with results will be included in the CSV file. If no result is available for an image, it will not be included in the export.
{% endhint %}

## 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.0](https://docs.google.com/spreadsheets/d/1SHJF9WqG7-UijzktagqRji3kNSdaYLMDTJlTL35FLXg/edit?gid=1058490684#gid=1058490684).

***

## Export Results as CSV from SaaS B2B UI

* Navigate to the [Datasets section in SaaS](https://saas.haut.ai/app/datasets).
* Go to the “CSV export” tab.
* Click on the “Schedule CSV export” button.

  <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2F9rlgOMLR9bCIXZZRMo3q%2FDatasets%20-%20CSV%20Export%20-%20Schedule.png?alt=media&amp;token=4d6537c5-6376-4294-90ec-06d610521b73" alt=""><figcaption></figcaption></figure>
* Select the period for the export.

  <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2FJS71k9Kkyx6IpFstUQeq%2Fimage.png?alt=media&amp;token=2480256c-4a51-4c14-ac50-abcd642eb86b" alt=""><figcaption></figcaption></figure>
* Select the set of metrics that you want to export. Currently, there is two options: export Face Skin Analysis 3.0 results or export Face Skin Metrics 2.0 and other metrics.

  <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2FJ7qzFiAZwqXFtoMFij9s%2Fimage.png?alt=media&amp;token=82e2a780-7c05-4b47-887b-d958cbf07a56" alt=""><figcaption></figcaption></figure>
* 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.

  <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2FN5QnBm5Lepsp3d5Vsgzr%2Fimage.png?alt=media&amp;token=ac377fd8-9d29-48aa-8893-8e91da2e49c0" alt=""><figcaption></figcaption></figure>
* In case if you datasets is a study dataset, you will be able to select stages and parameters to export<br>

  <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2Fi37zFTf8DIiA4WjZLOVQ%2Fimage.png?alt=media&amp;token=ffa276e4-e203-44d9-bd57-e847b32535c2" alt=""><figcaption></figcaption></figure>
* 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.

  <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2Fg8WWcjDt8f9aHWZZBzei%2FDatasets%20-%20CSV%20Export%20-%20Download%20CSV.png?alt=media&amp;token=f2b7f55f-e106-405c-b5aa-986bf96a9726" alt=""><figcaption></figcaption></figure>

***

## Exporting Results as CSV from API

{% hint style="warning" %}
Available only for <mark style="color:purple;">**Professional Plan**</mark> clients
{% endhint %}

For technical implementation details, such as request format and available filters, please refer to the [CSV export API documentation](/haut.ai/developers/saas-api-overview/api-for-datasets/api-for-csv-export-from-dataset.md).

## 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`.<br>

   <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2F0REzTwVEePLn21X0BaEt%2FCSV%20-%20Export%20%E2%80%93%20MS%20Excel%20%E2%80%93%201.png?alt=media&amp;token=93fa06d1-a646-4fc9-8b35-ab01c3ac0844" alt=""><figcaption></figcaption></figure>
7. On the step 2, select `Semicolon` as delimeter.<br>

   <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2F5LjODocboZxV6NDuQ4F7%2FCSV%20-%20Export%20%E2%80%93%20MS%20Excel%20%E2%80%93%202.png?alt=media&amp;token=f11926a9-06ea-4532-a546-bc1ea819a5af" alt=""><figcaption></figcaption></figure>
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`.

   <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2F1x1QKbbjx11BXDitSLGg%2FCSV%20-%20Export%20%E2%80%93%20MS%20Excel%20(Windows)%20%E2%80%93%201.png?alt=media&amp;token=c3be3ae6-88cc-468b-ab27-59ffd5deec7b" alt=""><figcaption></figcaption></figure>
5. Next, select `Semicolon` as delimeter.<br>

   <figure><img src="https://245161714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MWxBX_zB4FnflOpyBGO%2Fuploads%2F3MsORJNmHc8sn3Fa7vET%2FCSV%20-%20Export%20%E2%80%93%20MS%20Excel%20(Windows)%20%E2%80%93%202.png?alt=media&amp;token=9380faa8-a2f4-437d-8ad8-ac9c005f7883" alt=""><figcaption></figcaption></figure>
6. Click `Load`.
7. After that Excel will import the data to your spreadsheet.

***

{% hint style="warning" %}
Not a Haut.AI client yet?
{% endhint %}

<a href="https://haut.ai/book-a-demo?utm_source=referral&#x26;utm_medium=saas_docs&#x26;utm_campaign=Docs_SaaS_HautAI" class="button primary" data-icon="user-vneck">Book a demo</a> <a href="https://haut.ai/product/ai-skin-analysis?utm_source=referral&#x26;utm_medium=saas_docs&#x26;utm_campaign=Docs_SaaS_HautAI" class="button secondary" data-icon="external-link">Platform overview on haut.ai</a>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.saas.haut.ai/haut.ai/haut.ai-features/datasets/csv-file-with-raw-statistics.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.