> For the complete documentation index, see [llms.txt](https://adminguidesgitbook.aerofiler.com.au/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://adminguidesgitbook.aerofiler.com.au/repository/importing-data.md).

# 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="/files/fqGtJvHjp4NJMZqvq3Er" 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="/files/ShAE7kypA3P2TjoOyQ7b" alt=""><figcaption></figcaption></figure>

Here are the values from the spreadsheet import:

<figure><img src="/files/amwgDr1B0MPLGR2O6VrO" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/YjxR0ufzfbioon10CKvM" alt=""><figcaption></figcaption></figure>

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

&#x20;

<figure><img src="/files/5mo8p90nAtMCPWPa86pX" 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="/files/cx4T1iCATu6xkrnNWOuw" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/wzyX30W8JM8lPpdIiv0X" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/HIuEVRYkLd7ToAuJFaVy" alt=""><figcaption></figcaption></figure>