Supporters import

Upload supporters from a CSV file. Before reading this page, see the general rules in CSV Imports (file format, dates, booleans, tags, deduplication).

No column is required per row: an anonymous supporter (all cells empty) is valid and is skipped without error. Deduplication uses the chain supporter external ref → email → ssn → vat.

Columns

Column	Description
supporter external ref	External reference, primary reconciliation key. Unique per organization.
donor type	Supporter type. Values: individual, company, organization, family, group.
first name	First name.
last name	Last name.
company	Company name (for companies/organizations).
date of birth	Date of birth, format YYYY-MM-DD.
place of birth	Place of birth.
title	Title (e.g. Dr., Ms.).
job	Occupation.
phone	Landline phone.
mobile	Mobile phone.
email	Email. Secondary deduplication key.
tax identification number	Tax identification number. Format validation only (alphanumeric). Secondary deduplication key.
vat	VAT number. Format validation only (alphanumeric). Secondary deduplication key.
address	Address.
city	City.
province	Province.
zip	ZIP code.
country code	Country, ISO 3166-1 alpha-2 (e.g. IT).
accepts email marketing	Email consent. Boolean value (t/f, true/false, 0/1).
accepts sms marketing	SMS consent. Boolean value.
accepts phone marketing	Phone consent. Boolean value.
accepts postal marketing	Postal consent. Boolean value.
accepts profilation marketing	Profiling consent. Boolean value.
tags	Multi-value tags (cell in quotes if it contains multiple values).
note	Free-text note.

In addition, you can include custom_<key> columns for custom fields of type supporter (see Custom fields).

Notes

• The code column is not importable: code remains a system identifier, generated and managed by Riseact.
• Imported marketing consents must be tracked with their source ("import N of <date>"). For privacy matters, refer to the DPO.
• If a supporter matches an existing record (by any key), it is reused without changes: its personal data is not updated.