You can import your contacts from another application into Quaderno easily using our CSV template.
Quaderno uses CSV (comma-separated value) files to perform this kind of bulk task. Here is an example: contacts.csv
To import contacts, follow these steps:
- Go to the contacts page and click
- Drag & drop your CSV file in the modal window.
Duplicates are detected based on the
name column. When this happens, we’ll update the contact instead of creating a new one. Take into account that if the contact had info on a field that now comes empty on the CSV, that field will be emptied.
CSV columns breakdown
name field is required.
All other are optional, although we highly recommend always filling
tax_id and business info for companies, so that we can apply reverse charge automatically on their invoices when their VAT number is verified.
Optional fields can be left empty or be removed. Note that empty fields will remove existing fields when updating contacts.
|The contact type: company or person. Default is company.
|The contact's name. This is a required field. If your customer or vendor doesn’t already exist in Quaderno, they will be created as a new contact. When they do exist, Quaderno will override the existing contact, including removal of empty fields on the CSV that existed before.
|The contact’s email address
|The contact’s address (first line)
|The contact’s address (second line)
|The contact’s city
|The contact’s postal or ZIP code
|The contact’s region or state
|The contact’s country, represented with its ISO code. Defaults to your account’s base country.
|The contact’s telephone number
|The contact’s web address (URL)
|The contact’s tax id (VAT number). Make sure you fill this for B2B sales! Quaderno will automatically apply reverse charge for invoices issued to contacts with a verified tax id.