> ## Documentation Index
> Fetch the complete documentation index at: https://docs.spicom.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Import Contracts (CSV)

> Learn how to import your contracts into Spicom using a simple CSV file.

# Import Contracts (CSV)

Importing your contracts is the fastest way to populate your dashboard and start analyzing **margins**, **risk**, and **forecasts**.\
Spicom accepts a simple and flexible CSV format designed to work with any CRM, billing tool, spreadsheet, or custom export.

<Callout type="info">
  You can download a sample CSV directly inside the import modal in Spicom.
</Callout>

***

## 📥 How to Import Your Contracts

1. Go to **Contracts → Import CSV**
2. Click **Upload File**
3. Select your CSV
4. Validate and import

The dashboard will be populated instantly with:

* real margins
* cost breakdown
* client risk score
* 12-month forecast

***

## 📄 CSV Format (Required Columns)

Your CSV must include the following minimum columns:

| Column                 | Type   | Example                                     | Description                            |
| ---------------------- | ------ | ------------------------------------------- | -------------------------------------- |
| `customer_name`        | string | Acme Corp                                   | Client name                            |
| `customer_email`       | string | [contact@acme.com](mailto:contact@acme.com) | Client Email                           |
| `contract_name`        | string | Social Media Management                     | Contract or project name               |
| `contract_description` | string | Social Media Management                     | Description of the project or contract |
| `contract_amount`      | number | 2500                                        | Monthly recurring revenue (HT)         |
| `contract_start`       | date   | 2024-01-01                                  | Contract start date                    |
| `contract_end`         | date   | 2024-12-31                                  | Contract end date or renewal date      |

Optional but recommended:

<Callout type="tip">
  Dates must be in ISO format (`YYYY-MM-DD`) for best compatibility.
</Callout>

***

## 📂 Sample CSV

```csv theme={null}
customer_name,customer_email,contract_name,contract_description,contract_amount,contract_start,contract_end
Acme Corp,contact@acme.com,Website Maintenance,Monthly maintenance and monitoring,1200,2024-01-01,2024-12-31
Blue Media,hello@bluemedia.com,SEO Retainer,SEO tracking + monthly optimization package,1800,2024-02-01,2024-12-31
Nova Group,team@novagroup.io,Branding Package,Full branding redesign including guidelines,3500,2024-01-15,2024-03-15
TechFlow,info@techflow.dev,Cloud Hosting Management,AWS infrastructure monitoring & updates,950,2024-03-01,2025-03-01
Skyline Agency,contact@skyline.agency,Content Production,Creation of 8 monthly content pieces,2200,2024-01-10,2024-10-10
```

❗ Import Errors & How to Fix Them

1. “Invalid date format”

Use the ISO format:
2024-05-20

2. “Amount is not a number”

Make sure cells don’t contain:

* currency symbols
* commas
* spaces

Use:
2500
not:
2,500€

3. “Missing required column: customer\_name”

Ensure your CSV includes the required headers.

4. “File is empty or unreadable”

Check encoding: UTF-8 recommended.

#### What Happens After Import?

Once imported, Spicom automatically computes:

* revenue distribution
* workforce allocation impact
* global cost distribution
* real margin per contract
* future revenue over 12 months

Every update to workforce or global costs recomputes margins automatically.