# 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](https://docs.appfarm.io/reference/data-model/object-classes#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*