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.

You can download a sample CSV directly inside the import modal in Spicom.

📥 How to Import Your Contracts

Go to Contracts → Import CSV
Click Upload File
Select your CSV
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	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:

Dates must be in ISO format (YYYY-MM-DD) for best compatibility.

📂 Sample CSV

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

“Invalid date format”

Use the ISO format: 2024-05-20

“Amount is not a number”

Make sure cells don’t contain:

currency symbols
commas
spaces

Use: 2500 not: 2,500€

“Missing required column: customer_name”

Ensure your CSV includes the required headers.

“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.

Getting Started

Setup Guide

Features

How It Works

Troubleshooting

LTD Activation

Account & Security

Import Contracts (CSV)

Import Contracts (CSV)

📥 How to Import Your Contracts

📄 CSV Format (Required Columns)

📂 Sample CSV

What Happens After Import?

​Import Contracts (CSV)

​📥 How to Import Your Contracts

​📄 CSV Format (Required Columns)

​📂 Sample CSV

​What Happens After Import?

Import Contracts (CSV)

📥 How to Import Your Contracts

📄 CSV Format (Required Columns)

📂 Sample CSV

What Happens After Import?