Skip to main content

Importing Companies and Contacts from CSV

Import your client companies and their contacts into Productive from CSV templates, with the columns each one takes and the rules to know.

You can import your client companies and their contacts into Productive from CSV files, instead of adding them one by one.

👉 For how CSV imports work in general, see CSV Data Imports: Overview.

Download the Templates

Go to Settings > Data import and click Download .csv templates.

Download Companies.csv, Contacts.csv, or both.

Save your files with UTF-8 encoding, so special characters in names come through correctly.

Fill In the Companies Template

Only Name is required. Leave any column you don’t need empty, but don’t delete it.

Name

The client company’s name. Each name can appear only once in the file.

Full Company Name

The legal name shown on invoices. If it’s empty, Name is used.

Due Days

How many days the company has to pay your invoices.

Address, City, State, Zipcode

The company’s address. If you fill in any of the address, city, or zipcode, Country is required too.

Country

The country’s full name in English, for example "United Kingdom".

Phone

The company’s phone number.

Email

The company’s email address.

Website

The company’s website or LinkedIn page.

VAT

The company’s tax ID.

Company Code

A short code used in invoice numbers. Each code can appear only once.

📌 Every row creates a new company. Productive doesn’t match rows to companies you already have, so leave existing companies out of the file.

Fill In the Contacts Template

Each contact needs a First Name or a Last Name.

Company

The company the contact works for. If no company with this name exists, it’s created.

First Name

The contact’s first name.

Last Name

The contact’s last name.

Email

The contact’s email address. Optional, but each email can belong to only one contact in Productive.

Title

The contact’s job title.

Phone

The contact’s office phone number.

Mobile

The contact’s mobile phone number.

Upload and Fix Errors

Drag your file into the upload box, or click it to choose the file.

Productive checks the file and marks each problem with ⚠️. Hover over the symbol to see what’s wrong.

Fix errors right in the import window, then click Check for errors. You can also use Remove all rows with errors or Only show rows with errors.

Finish the Import

When there are no errors left, click Proceed to import, then Import. One import can have up to 999 rows.

Your companies and contacts are now in CRM > Companies and CRM > Contacts, where you can review and edit them.

Did this answer your question?