> For the complete documentation index, see [llms.txt](https://exportmanager.docs.foxnetsoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://exportmanager.docs.foxnetsoft.com/column-mappings.md).

# 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="/files/lbr62EmO4yUdJ29P7hn7" 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.