# Overview

## Overview

Column mapping leverages a technique Osmos calls AutoMap. AutoMap automatically maps headers and columns from your uploaded data to your destination schema. Osmos leverages Generative AI to maps your columns quickly and more accurately.   When AutoMap is triggered, it notes it in the top right hand corner.&#x20;

### Column Mapping Panel

On the left, you will see the column mapping panel. This is where you start, and where you map the relationship between the input (uploaded) and output (cleaned) columns.&#x20;

Each card in this section represents an output column for your Uploader Destination. You can map one or more uploaded columns to each cleaned (Our Field) column.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FA0Ligyrmhl0kYPMjeSqh%2FCleanShot%202023-07-20%20at%2014.21.43%402x.png?alt=media&#x26;token=4033b375-5139-4590-b466-8d3c210e654d" alt=""><figcaption></figcaption></figure>

### Input and Output Columns&#x20;

After you map an input (uploaded) column to an output (cleaned aka Our Field) column, you will see the data that corresponds to the selected columns to the right of the mapping section.&#x20;

When you select a different cleaned column in the mapping section, the section to the right will update to display the corresponding data for those columns.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FMLwPxPhdDdGOLtwJxSn2%2Fimage.png?alt=media&#x26;token=84ef2cb8-2b7f-41b3-b99d-022116579741" alt=""><figcaption></figcaption></figure>

### Column Mapping Filters

To streamline the mapping process, you can filter fields by a variety of factors.  These include   mapped vs unmapped, required vs optional, field errors, warnings, skipped rows, fields with formulas, SmartFill or QuickFixes. In addition, you can filter by field type, specific fields themselves or simply search for fields.

{% tabs %}
{% tab title="Show Filter" %}

<div align="left"><figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FNEpYQEOpXzxtBGMJdDa6%2FCleanShot%202023-12-28%20at%2013.55.26%402x.png?alt=media&#x26;token=8b830334-caff-4033-babc-aaddfabbb2bc" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Type Filter" %}

<div align="left"><figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2F3dpSnbTTyN42v7pzdMtf%2FCleanShot%202023-12-28%20at%2013.55.41%402x.png?alt=media&#x26;token=4ddb5ec7-0dc0-4124-a2ab-396559b18d26" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Field Filter" %}

<div align="left"><figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FYuFt3gc1hW7cn6wV2pLM%2FCleanShot%202023-12-28%20at%2013.55.57%402x.png?alt=media&#x26;token=e3330323-bade-48a6-84eb-5a79eb3e40f0" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}
{% endtabs %}

### Data Cleanup

Users can cleanup data through [AutoClean](https://docs.osmos.io/uploader/standard-mode/autoclean) and **single-cell edits**. &#x20;

AutoClean is a capability which allows end users clean data with one click. Your Osmos Uploader comes with prebuilt AutoClean capability for certain scenarios detailed below, but also empowers developers with the ability to transform data on the fly by creating their own AutoClean functions.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2F06CKmrL3Q1BZqDQf1Ips%2FCleanShot%202023-07-20%20at%2010.16.30%402x.png?alt=media&#x26;token=3c422b9a-b6d5-47d3-866a-b6c9de426a95" alt=""><figcaption></figcaption></figure>
