# Process

**Step 1:** Upload Data. &#x20;

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FAJAz9eJgoMA8MXtuXtvn%2Fimage.png?alt=media&#x26;token=eca0b7a5-e1bc-467f-a0d2-f93fa390f6f7" alt="" width="375"><figcaption></figcaption></figure>

For Excel based files, you can select the starting cell for your upload.  For CSV, it will pull the entire file.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FlB7v8jvT3BMPI3Cb0IIW%2FCleanShot%202023-07-20%20at%2010.29.52%402x.png?alt=media&#x26;token=e11aad3b-0aa8-4060-922e-742756f05fa5" alt=""><figcaption></figcaption></figure>

**Step 2**: Begin Column Mapping from the left panel. Select the column(s) that contain the data for the first output column listed.&#x20;

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2Fh8tO0W7fOrytETSN8lmg%2FCleanShot%202023-07-18%20at%2012.08.24%402x.png?alt=media&#x26;token=4c8a22dc-dd82-49c6-b2b7-1d61aca904b1" alt="" width="296"><figcaption></figcaption></figure>

When you are mapping columns, on the right side of the Your Column, you can opt to **show more columns**.  These columns are for viewing only and display italicized.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FHBOaB5BkA0P2svFPXgbw%2Fimage.png?alt=media&#x26;token=f7b221ab-146c-4d5d-9f3a-34274cccb063" alt=""><figcaption></figcaption></figure>

**Step 3**: If you want to cleanup or modify the data in the cleaned (output) column (or resolve errors), you can either apply AutoClean or directly edit the cell, which we call a single-cell edit.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FAoJUpnhA1yPim7bLodYr%2FCleanShot%202023-07-20%20at%2010.16.30%402x.png?alt=media&#x26;token=1c08d279-7c10-4aa7-b0ee-cc0e6b130be5" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
For more information on [AutoClean](https://docs.osmos.io/uploader/standard-mode/autoclean).
{% endhint %}

Use the tabs at the top of the page to filter for rows with errors, skipped, AutoCleaned and/or rows flagged for review to confirm all issues with your data have been addressed.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FwfkwmyP4ZQzGoAcUs0L6%2FCleanShot%202023-07-20%20at%2010.51.25%402x.png?alt=media&#x26;token=2ee75a48-1cc9-4e30-841e-12c8a48db9be" alt=""><figcaption></figcaption></figure>

**Step 4**: Once the data is mapped and cleaned, select Continue.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2F5Cth5nAsYEfjXCUwQU10%2FCleanShot%202023-07-18%20at%2012.36.23%402x.png?alt=media&#x26;token=3db0f0db-3cda-4156-907e-21a4a538bb55" alt=""><figcaption></figcaption></figure>

**Step 5**:  Perform a final review.  This spreadsheet-like view allows you to make any single-cell edits before final submission.  It will also display the columns that were not mapped (display in gray).  Hit Submit

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FcFTcQuv1MK5vnJjFVvuy%2FCleanShot%202023-07-18%20at%2012.38.10%402x.png?alt=media&#x26;token=d2cfb3f4-f824-4bed-a7f8-ce964ae2194c" alt=""><figcaption></figcaption></figure>

**Upload Complete!** Note you can upload another file from within this window.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2F4CVyfvf8j0TtGqxFq1pD%2FCleanShot%202023-07-18%20at%2012.38.44%402x.png?alt=media&#x26;token=414f6182-b570-4ed1-9a84-da657571cb0c" alt="" width="375"><figcaption></figcaption></figure>
