# 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.
2. In the toolbar, click *Write* and select *Excel* from the drop-down.
3. This opens *Recipe Configuration – Write Excel* panel.
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.
* **Start Address:** Indicate the cell value from where you want Astera Dataprep to start writing the data.
5. Click *Apply* to save settings or *Cancel* to discard.
6. Click *Execute Dataprep Recipe* to generate the Excel file.
Alternatively, you can ask in Chat to write to an Excel file and then later instruct it to execute the recipe.
{% 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.
2. In the toolbar, click *Write* and select *Delimited File* from the drop-down.
3. This opens the *Recipe Configuration – Write Delimited* panel.
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.
* **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.
5. Click *Apply* to save settings or *Cancel* to discard.
6. Click *Execute Dataprep Recipe* to generate the file.
Alternatively, you can ask in Chat to write to a delimited file and then later instruct it to execute the recipe.
{% 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.
2. In the toolbar, click *Write* and select *Log File* from the drop-down.
3. This opens the *Recipe Configuration – Log* panel.
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 *Apply* to save settings or *Cancel* to discard.
6. Click *Execute Dataprep Recipe* to generate the file.
Alternatively, you can ask in Chat to write to a log file and then later instruct it to execute the recipe.
{% endtab %}
{% endtabs %}
---
# Agent Instructions: 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:
```
GET https://documentation.astera.com/dataprep/exporting-data.md?ask=
```
The question should be specific, self-contained, and written in natural language.
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.