Importing Data
Last updated
Last updated
You can import contract data from a spreadsheet into Aerofiler. To begin, navigate to the "Documents" page and then click Actions -> Import from Excel:
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:
Here are the values from the spreadsheet import:
After clicking "Import from Excel", drag and drop the spreadsheet into Aerofiler:
Where the column titles in the spreadsheet match those in Aerofiler, mapping is performed automatically:
If the column title are different, you can click the dropdown under "Mapping" to map the spreadsheet column title to the Aerofiler column title
Next, you need to choose a column to use for matching. Typically, matching is done by file name:
After clicking next, Aerofiler will display a preview of the import data:
After clicking "Import", the spreadsheet values will be imported into Aerofiler: