# 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 imported. Column mappings can be created either by column names (in the first row of your spreadsheet document) or by column numbers.

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

<figure><img src="/files/cKSUgoq1thsYUcXxd35O" alt=""><figcaption><p>Add new record section</p></figcaption></figure>

**Column source** is either the name of column or column number (starting with 0).

**Column destination** is the field that this column represents in your table.

| SKU  | Product name | Picture    |
| ---- | ------------ | ---------- |
| 0001 | Laptop       | laptop.png |
| 0002 | Phone        | phone.png  |

{% hint style="info" %}
In this sample table, SKU has column number 0, Product name has column number 1, and Picture has column number 2.
{% endhint %}

{% hint style="info" %}
In your table you can use TRUE or FALSE for boolean values. Also, you can use 1 or 0, true or false, t or f, True or False.
{% endhint %}

{% hint style="info" %}
Some column destinations support input of multiple values using | (vertical bar) symbol. Check page for your import target to see if these destinations support this input method.
{% endhint %}


---

# 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://importmanager.docs.foxnetsoft.com/column-mappings.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.