# Exporting Data

This document explains how to export data from Astera Dataprep using different output formats. You can choose between *Excel, Delimited File,* and *Log File.*

\
Each method can be done through the *toolbar* or by simply asking in *Chat.*

{% tabs %}
{% tab title="Write to Excel" %}
Suppose you have a Dataprep Recipe containing cleansed data that you want to save as an Excel file for reporting purposes.

1. Open your Dataprep Recipe.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FDtdpuWULDqjZl5k0N6XN%2Fimage.png?alt=media&#x26;token=0a8df91f-77c0-466b-98cf-7acbb6235868" alt=""><figcaption></figcaption></figure>

2. In the toolbar, click *Write* and select *Excel* from the drop-down.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FwXSdNaaJUzfK5DCWnpBS%2Fimage.png?alt=media&#x26;token=e391a96a-62e6-46ba-8aa8-dcd6b0403cbf" alt="" width="331"><figcaption></figcaption></figure>

3. This opens *Recipe Configuration – Write Excel* panel.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2F5uCeyW1QLkziyGDDKn46%2Fimage.png?alt=media&#x26;token=af96e54d-9bd6-44d8-a3c6-968135cdba40" alt="" width="386"><figcaption></figcaption></figure>

4. In this panel, you can configure the following options:
   * **File Path:** Specify the file path (and name) for the output file. You can type the path directly or click the folder icon to browse.
   * **Worksheet:** Specify the name of your worksheet. This can be used to either overwrite data in an existing worksheet or to add a new worksheet.&#x20;
   * **Start Address:** Indicate the cell value from where you want Astera Dataprep to start writing the data.&#x20;
5. Click <img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FoeiTEWXcnkBYJXz5mSQ7%2Fimage.png?alt=media&#x26;token=f1f10cab-92ae-425b-8665-0d8af019174a" alt="" data-size="line">*Apply* to save settings or <img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FfNpGINCyjDQ2trGtqVoS%2Fimage.png?alt=media&#x26;token=665140d4-e8fa-48ba-95ed-0e6273f94be9" alt="" data-size="line">*Cancel* to discard.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FVPSREjusxQyu61d03504%2Fimage.png?alt=media&#x26;token=2664dcec-69b6-4f9e-b3af-0c40354d2290" alt=""><figcaption></figcaption></figure>

6. Click *Execute Dataprep Recipe* to generate the Excel file.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2F9gS2Lo0v6xaSdwp50J20%2Fimage.png?alt=media&#x26;token=380e1916-54cf-4415-8bc9-0dcf4d390156" alt=""><figcaption></figcaption></figure>

Alternatively, you can ask in Chat to write to an Excel file and then later instruct it to execute the recipe.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FUjv4toky2TjNL8alHaIJ%2Fimage.png?alt=media&#x26;token=a7427a35-6e8e-4802-b163-f75f290ad022" alt=""><figcaption></figcaption></figure>
{% endtab %}

{% tab title="Write to Delimited File" %}
Suppose you have a Dataprep Recipe containing cleansed data that you want to save as a CSV file for sharing.

1. Open your Dataprep Recipe.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2F0dMyodr4G1MFGgfomfMv%2Fimage.png?alt=media&#x26;token=f4dc735e-f27d-4ac1-9b4d-a5ed18addc71" alt=""><figcaption></figcaption></figure>

2. In the toolbar, click *Write* and select *Delimited File* from the drop-down.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FR4g9pu44wntH0Kq8MTo1%2Fimage.png?alt=media&#x26;token=935f69c5-1070-4644-8643-49a0c43942d2" alt="" width="334"><figcaption></figcaption></figure>

3. This opens the *Recipe Configuration – Write Delimited* panel.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2F2PLM3Ym7IxgznTafCi9H%2Fimage.png?alt=media&#x26;token=7a0cb08e-cb55-4c09-b09d-80d12d6d7504" alt="" width="387"><figcaption></figcaption></figure>

4. In this panel, you can configure the following options:

   * **Append To File (If Exists):** Choose whether to append new entries or overwrite the file.
   * **File Path:** Specify the file path (and name) for the output file. You can type the path directly or click the folder icon to browse.
   * **Field Delimiter:** Allows you to select a delimiter from the drop-down list for the fields.

   <figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FAWXHvQFp3Pe3D9e0N7Oq%2Fimage.png?alt=media&#x26;token=5480ded8-064a-4fe9-9e1e-6c7871959679" alt="" width="356"><figcaption></figcaption></figure>

   * **Record Delimiter:** Allows you to select the delimiter for the records in the fields. The choices available are carriage-return and line-feed combination, carriage-return and line-feed. You can also type the record delimiter of your choice instead of choosing the available options.

   <figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FEiiNru09kTzzc89TBqw0%2Fimage.png?alt=media&#x26;token=a0694dbb-6288-4675-bb9d-661976bc6e0e" alt="" width="351"><figcaption></figcaption></figure>
5. Click <img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FoeiTEWXcnkBYJXz5mSQ7%2Fimage.png?alt=media&#x26;token=f1f10cab-92ae-425b-8665-0d8af019174a" alt="" data-size="line">*Apply* to save settings or <img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FfNpGINCyjDQ2trGtqVoS%2Fimage.png?alt=media&#x26;token=665140d4-e8fa-48ba-95ed-0e6273f94be9" alt="" data-size="line">*Cancel* to discard.
6. Click *Execute Dataprep Recipe* to generate the file.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2F9gS2Lo0v6xaSdwp50J20%2Fimage.png?alt=media&#x26;token=380e1916-54cf-4415-8bc9-0dcf4d390156" alt=""><figcaption></figcaption></figure>

Alternatively, you can ask in Chat to write to a delimited file and then later instruct it to execute the recipe.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FdnyyPMFeSJorPyvRkWYw%2Fimage.png?alt=media&#x26;token=668dcbd2-15bb-462d-9533-d4c534ba4163" alt=""><figcaption></figcaption></figure>
{% endtab %}

{% tab title="Write to Log File" %}
Suppose you have a Dataprep Recipe processing customer transaction and you want to log specific records for tracking or debugging.

1. Open your Dataprep Recipe.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2F0dMyodr4G1MFGgfomfMv%2Fimage.png?alt=media&#x26;token=f4dc735e-f27d-4ac1-9b4d-a5ed18addc71" alt=""><figcaption></figcaption></figure>

2. In the toolbar, click *Write* and select *Log File* from the drop-down.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FYQORuo3G9dQbOw9RMcV5%2Fimage.png?alt=media&#x26;token=300cc25f-ca97-4456-a70c-0e58d18d3c2c" alt="" width="334"><figcaption></figcaption></figure>

3. This opens the *Recipe Configuration – Log* panel.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2Fqt7y4YoFAQaEqtSQA50K%2Fimage.png?alt=media&#x26;token=9c49e0c0-9550-4fef-9306-5c4fd5511c4a" alt="" width="425"><figcaption></figcaption></figure>

4. In this panel, you can configure the following options:
   * **File Path:** Specify the file path (and name) for the output file. You can type the path directly or click the folder icon to browse.
   * **Create a new file on each run:** Check this box if you want a separate log file generated every time the recipe runs.
   * **Log Level Type:** Select which log entries to include:
     * **All:** Logs all messages.
     * **Errors:** Logs only error messages.
     * **Warnings:** Logs only warnings.
     * **Error and Warnings:** Logs both errors and warnings.
   * **Stop Logging After:** Specify the number of records after which logging should stop.
5. Click <img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FoeiTEWXcnkBYJXz5mSQ7%2Fimage.png?alt=media&#x26;token=f1f10cab-92ae-425b-8665-0d8af019174a" alt="" data-size="line">*Apply* to save settings or <img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FfNpGINCyjDQ2trGtqVoS%2Fimage.png?alt=media&#x26;token=665140d4-e8fa-48ba-95ed-0e6273f94be9" alt="" data-size="line">*Cancel* to discard.
6. Click *Execute Dataprep Recipe* to generate the file.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FpOYcfbSy1KoLpd44TwoH%2Fimage.png?alt=media&#x26;token=e649b668-8240-4428-80de-fd6f9b8cfc8b" alt=""><figcaption></figcaption></figure>

Alternatively, you can ask in Chat to write to a log file and then later instruct it to execute the recipe.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FPVOl2efIPSsqXC4OhaY1%2Fimage.png?alt=media&#x26;token=bd7dadca-81fb-4b3f-9bda-e884d25720a3" alt=""><figcaption></figcaption></figure>
{% endtab %}
{% endtabs %}
