# Importing Data

You can import contract data from a spreadsheet into Aerofiler. To begin, navigate to the "Documents" page and then click Actions -> Import from Excel:

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2FXFLum4S9xAr8iVcVZMsb%2Fimage.png?alt=media&#x26;token=1bd4ab8d-2d05-428e-a9c9-2f03b4ef9ed5" alt=""><figcaption></figcaption></figure>

In this example, we have the following file names already uploaded in Aerofiler:

* saas-agreement.docx
* services-agreement-supply-to-a-customer.docx

We wish to import the following fields:

* Counterparty
* Contract Value
* Start Date
* Title
* Document Type

Prior to the import, this is how the documents appear in Aerofiler:

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2FDgFG4E5pHF62qJfVesXz%2Fimage.png?alt=media&#x26;token=1835517f-6b84-4fd2-870b-52f2155832d6" alt=""><figcaption></figcaption></figure>

Here are the values from the spreadsheet import:

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2F2LsFhOK0GMnrAfLvglzS%2Fimage.png?alt=media&#x26;token=e54c0589-b8b6-47e2-a296-82510437c0d3" alt=""><figcaption></figcaption></figure>

After clicking "Import from Excel", drag and drop the spreadsheet into Aerofiler:

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2Fzj8ebAM5HgIukhowXwnK%2Fimage.png?alt=media&#x26;token=2c17d22a-cf9f-467a-bd43-8e66ab699c96" alt=""><figcaption></figcaption></figure>

Where the column titles in the spreadsheet match those in Aerofiler, mapping is performed automatically:

&#x20;

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2FqH3IkaRK5DMEn6QpCWcS%2Fimage.png?alt=media&#x26;token=a7011fb1-21cf-4d07-ba8f-fd214d0ca2df" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
If the column title are different, you can click the dropdown under "Mapping" to map the spreadsheet column title to the Aerofiler column title
{% endhint %}

Next, you need to choose a column to use for matching. Typically, matching is done by file name:

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2FFOodHnHakEtJCLIDO70O%2Fimage.png?alt=media&#x26;token=12e8955d-533b-47e7-a73d-67c4bdf4e821" alt=""><figcaption></figcaption></figure>

After clicking next, Aerofiler will display a preview of the import data:

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2FqIyqmHBOfFyvaQ0v9NXw%2Fimage.png?alt=media&#x26;token=ac0cdb8b-1031-4864-bdbf-f4d5e1fe11bd" alt=""><figcaption></figcaption></figure>

After clicking "Import", the spreadsheet values will be imported into Aerofiler:<br>

<figure><img src="https://990055713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpzhcJuh5qEG7uLa8k3LR%2Fuploads%2FXoj88NE6gbR6w32YKQAM%2Fimage.png?alt=media&#x26;token=11d529d3-1f83-4d2c-8288-6ee315beca02" alt=""><figcaption></figcaption></figure>
