# Column mappings

## Create a column mapping

You need to create a column mapping for every column in your spreadsheet that you would like to be exported. Column mappings can be created by column names.

Navigate to **Column Mappings** page of your template settings and scroll to **Add new record** section.

<figure><img src="https://3238824156-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtOjnfl3UQfi1f5iyX2jf%2Fuploads%2F8qcU6eWnrS0BhhelFcWn%2FScreenshot%202023-07-28%20at%202.47.58%20PM.png?alt=media&#x26;token=ce9b8041-ab00-4cbf-9689-76c6675d2562" alt=""><figcaption></figcaption></figure>

**Mapping Entity** is the entity that value belongs to.

{% hint style="info" %}
Sometimes you might find Mapping Entity have an option for Extra entities. Then you would find Column source to have Custom value parameter. Selecting this column mapping would put a constant value for all exported entries in this column.
{% endhint %}

**Column source** is the parameter of the entity that will be in this column.

**Column destination** is the name of the column in exported file.

**Display order** arranges columns in exported file.