> For the complete documentation index, see [llms.txt](https://docs.avanoo.ai/public-knowledge-base/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avanoo.ai/public-knowledge-base/renewals-and-contract-management/importing-contracts-by-csv.md).

# Importing Contracts by CSV

#### Bulk Upload or Update Contracts in Avanoo

Avanoo simplifies the process of uploading or updating your contracts in bulk. Utilize the contract import tool to seamlessly import contracts from either a CSV file.

## Template

Send a csv file with at least the following columns in any order:

* contactName: string
* applicationName: string
* LicenseName: string
* yearlyCost: number > 0
* currency: ISO 4217 (EUR,BTN,...)
* autoRenewal: (true | false)
* startDate: dd/MM/yyyy
* endDate: dd/MM/yyyy
* resilisationDate: dd/MM/yyyy
* contractManagerEmail: string
* businessUnit: string
* supplierName: string
* paymentTerm:
  * WEEKLY
  * MONTHLY
  * YEARLY
  * BIWEEKLY
  * BIMONTHLY
  * TRIMONTHLY
  * SEMIYEARLY
* CancellationNoticePeriod: number > 0
* licenseCount: number > 0

Optional:

* userEmail: user email with a license as a string

You can add any other fields, but it might not be supported.\
\
Here is the csv template: with examples

{% file src="/files/yyapwMpBtKtRqsFhMBHp" %}