# Ignored Columns

There can be a situation where users want to skip a column during data submission. This is especially useful when using the importer to update existing data. To avoid overwriting existing columns, the users can mark those columns as **Ignored** and the importer will skip them.

With CSVbox you can give the option to the users to mark certain columns as Ignored. 

### Enabling Ignored Columns

The first step is to activate the Ignore Columns option via your CSVbox dashboard.

1. Login to your account.
2. Edit the sheet of your choice.
3. Go to the '**Options**' Tab.
4. Select '**Yes**' for the '**Allow Columns to be Ignored**' field.
5. Click '**Save**'.

The importer will then show the option to mark the columns as Ignored on the Column Mapping screen.

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2Fv8lBqR7i9Zpq6mNuEFCe%2FIgnore%20Colum1..png?alt=media&#x26;token=506a5877-2f91-4a41-815e-f34aa6a60825" alt=""><figcaption><p>Ignored Column Selection</p></figcaption></figure>

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2FbHwpJ9JMWBOlw9e6dli4%2FIgnore%20Colum2.png?alt=media&#x26;token=4fd6c3d0-7f12-4dad-b517-cd75ffb68dc2" alt=""><figcaption><p>Ignored Column</p></figcaption></figure>

The columns that are marked as Ignored will not be visible on the Verify Data screen.

{% hint style="info" %}
For columns that are marked as "Required", the Ignore Column option will not be available for selection.
{% endhint %}

#### Default Selection

When the Default Selection option is configured to 'Yes', all the unmapped columns will default to Ignore Column.

### **Data from Ignored Columns**

The Ignored Columns will not be pushed to any destination. Only the metadata (List of Ignored Columns) will be pushed to the following destinations:

1. [API/Webhook](https://help.csvbox.io/destinations#webhook)
2. [Zapier](https://help.csvbox.io/destinations/zapier)
3. [Client Side](https://help.csvbox.io/getting-started/3.-receive-data#data-at-the-client-side)

#### Ignored Column List

In the API response JSON object, the list of Ignored Columns will be displayed inside the **ignored\_columns** object as shown below. The **ignored\_columns** object will be visible only if the Ignored Columns are activated. In the example below check lines 16 and 36.

{% code lineNumbers="true" %}

```json
[
  {
    "import_id": 79418895,
    "sheet_id": 55,
    "sheet_name": "Products",
    "row_number": 1,
    "row_data": {
          "Name": "TP-Link TL-WN822N Wireless N300 High Gain USB Adapter",
          "SKU": "AS-100221",
          "Price": "33.00",
          "Quantity": "3"        
    },
    "custom_fields": {
      "user_id": "1002"
    },
    "ignored_columns": ["qualification", "experience"]
  },
  {
    "import_id": 79418895,
    "sheet_id": 55,
    "sheet_name": "Products",
    "row_number": 2,
    "row_data":{
          "Name": "EPower Technology EP-600PM Power Supply 600W ATX12V 2.3 Single 120mm Cooling Fan Bare",
          "SKU": "AS-103824",
          "Price": "95.35",
          "Quantity": "8",
           "_ignored_data":{
		"qualification": "MA",
		"experience": "6"
           }
        },
    "custom_fields": {
      "user_id": "1002"
    },
    "ignored_columns": ["qualification", "experience"]
  }
]
```

{% endcode %}