# Export data

The action node **Export Data** is used to export data from a *Data Source* to *CSV*. 

The action node supports exporting data from a Data Source row by row, as well as aggregation of data (e.g. export the number of sales per department).

{% hint style="info" %}
An example setup of Export Data is showcased in our [Showroom](https://showroom.appfarm.app/action-nodes/exportdata)! You may view a demo, as well as access the setup in Appfarm Create. If you do not have access, you may register [here](https://showroom.appfarm.app/sign-up).
{% endhint %}

## Settings

### File Name

Set a name for the exported file. The file type will always be .csv.

### Delimiter

Specify which *delimiter* to use in the file*,* i.e. the character that marks the end of the data. The default value is a comma (`,`), but you can set whatever you want (e.g. `;`) 

### Wrap strings in quotes

If you want to *wrap strings in quotes* (e.g. `"some text"`).

### Exclude Column Headers

Export the data without including column headers.

### Data **Source**

Select the *Data Source* you want to export data from.

### **Row grouping**

If you want to group the data on a row basis, select a *Row grouping property*. If you do not select a row grouping each data object in the Data Source will result in a row in the exported file.

Button **Add all columns** will add all the Object Class Properties (and runtime properties) of the selected Data Source as Static Columns. Reference properties will only be added if the refered Object Classes have a [Display Property](/reference/data-model/object-classes.md#general-properties) set. *Example: Adding all columns for Data Source `Contacts` (having a reference `Contact.Company`) will add `Contact.Company.Name` as a columns if the Object Class `Company` has `Name` as Display Property.*

### **Static columns**

Set up the columns you want to display in the export. This can be columns with text or some sort of aggregated value. The aggregated values are set up by selecting a property with datatype *Float* or *Integer* and specifying an aggregation function. If you leave the column blank it will display the count of the objects in the row.

### Data Column

If you want to group data on a column basis and display one column per data property item, you can select a *Column Property* under *Data Column*.

### **Column Headers**

Define the information you want to display as header rows per data column. This is typically information about the Column Property.

### **Value Property**

Add a *Value Property* to display in the rows per column, and optionally select an aggregation function. If none is selected *Count* will be used.

### **Target**

The action node lets you choose between two target types: 

1. **Download immediately** downloads the file directly
2. **Add to file** lets you add the file to a *File Data Source*


---

# 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://docs.appfarm.io/library/action-nodes/export-data.md?ask=<question>
```

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.