# 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="https://1316799053-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJUgglNpaUYIABSWTFnzb%2Fuploads%2FB06QJMk9CuQlzW55rLvI%2Fbrave_YBDrUec58P.png?alt=media&#x26;token=4a2d8a02-d161-488a-87b3-cbafc7211dcc" 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 %}