Import CSV Contacts for Annual Report: The Complete Guide

Why import your contacts in CSV format for an annual report?

Every year, joint-stock companies, holdings, and associations must have their annual report signed by a set of stakeholders: board members, shareholders, statutory auditors, and, depending on bylaws, all equity holders. Manually entering each email address into an electronic signature platform represents a considerable waste of time and a source of human error. Importing a CSV file (Comma-Separated Values) solves this problem by allowing you to inject hundreds of structured contacts directly into your signature workflow in just seconds.

This approach aligns with the increasingly widespread logic of electronic signature in business: automating bulk sends while guaranteeing the legal traceability of each signature. In this guide, we detail each step, from preparing the CSV file to final signature validation.

---

Preparing your CSV file: structure and best practices

The quality of the import depends directly on the rigor with which the CSV file is constructed. A poorly formatted file generates import errors, missing contacts, or duplicates that slow down the entire signature process.

Essential columns

For an annual report involving signatories and shareholders, your CSV file must contain at minimum the following columns:

• email: email address of the signatory (RFC 5321 format mandatory)
• prenom: first name of the contact, used to personalize the invitation message
• nom: last name
• role: role in the signature process (e.g., `signatory`, `reader`, `validator`)
• ordre_signature: integer indicating position in a sequential workflow (leave empty for parallel signing)
• telephone (optional): number in international E.164 format (+33XXXXXXXXX) for SMS authentication in the context of advanced signature
• groupe (optional): business category (e.g., `majority_shareholder`, `board_of_directors`, `statutory_auditor`)

Certyneo accepts UTF-8 and UTF-8 BOM encodings, which avoids the display problems of accented characters common with exports from Excel on Windows. The standard separator is the comma, but semicolon is also supported — specify it during import if your management software uses this convention.

Clean your data before import

Before uploading your CSV, perform a data cleaning phase:

1. Deduplication: a shareholder appearing twice with two different email addresses must be resolved beforehand. A duplicate generates two invitations and can create legal ambiguity about which signature is retained.
2. Email format validation: use a validation formula in Google Sheets (`=REGEXMATCH(A2,"^[a-zA-Z0-9._%+\-]+@[a-zA-Z0-9.\-]+\.[a-zA-Z]{2,}$")`) or a dedicated tool like Hunter.io Verifier.
3. Role verification: for an annual report, some shareholders have read-only access (management report) while others must affix a formal signature (assembly resolutions). Distinguish them clearly in the `role` column.
4. Phone number verification: if you opt for advanced electronic signature with SMS OTP, all numbers in the `telephone` column must be in E.164 format. A missing number blocks sending for that contact.

Example of valid CSV structure

```csv email,prenom,nom,role,ordre_signature,telephone,groupe jean.dupont@exemple.fr,Jean,Dupont,signatory,1,+33612345678,board_of_directors marie.martin@exemple.fr,Marie,Martin,signatory,2,+33698765432,majority_shareholder pierre.durand@exemple.fr,Pierre,Durand,reader,,+33677889900,statutory_auditor ```

Note that `Pierre Durand`, statutory auditor with read-only access, has no signature order (empty column) since he is not a signatory.

---

Importing the CSV into Certyneo: step-by-step procedure

Once your file is prepared, importing into Certyneo takes just a few steps from the signature folder creation interface.

Create the signature folder for the annual report

1. Log in to your Certyneo account and click New folder.
2. Upload the annual report PDF (management report, consolidated accounts, resolutions). You can use the AI contract generator from Certyneo if you need to prepare a supplementary meeting minutes.
3. In the Signatories tab, click Import from CSV.

Configure the import

A configuration window opens:

• Encoding: select `UTF-8` or `UTF-8 BOM` depending on your file.
• Separator: comma or semicolon.
• Header line: check the box if the first line of your CSV contains column names (recommended).
• Column mapping: Certyneo offers automatic mapping based on standard column names. Verify that each column is properly associated with the correct field. If your column is called `mail` instead of `email`, adjust the mapping manually.

Certyneo displays a preview of the first 5 contacts before validation. Check that no critical field is empty or misformatted. The system flags lines with blocking errors (invalid email, unknown role) in red and non-blocking warnings (missing phone for advanced signatory) in orange.

Validate and configure the workflow

After import validation, Certyneo displays the complete list of imported contacts. You can then:

• Define the signature type by group: simple signature (eIDAS article 3.10) for readers, advanced or qualified signature for board members. See the comparison of electronic signature solutions to choose the level appropriate for your context.
• Configure signature order: sequential (majority shareholder signs before board members) or parallel (all signatories receive invitation simultaneously).
• Customize the invitation message: include the signatory's name (`{{prenom}} {{nom}}`) and document title in the email body.
• Set the folder expiration date: for an annual report, 15 to 30 days provide sufficient time for non-resident shareholders.

---

Managing errors and follow-ups after import

Even with a well-prepared CSV, unexpected situations arise once sending is launched.

Handle bounces and invalid addresses

Certyneo reports soft bounces (mailbox full) and hard bounces (non-existent address) in real time. For an annual report with legal implications, a bounce must trigger immediate action:

1. Identify the affected contact in the folder dashboard.
2. Update their email address from the contact sheet.
3. Resend the invitation individually without recreating the entire folder.

This granular correction capability is essential for respecting legal deadlines for convocation or distribution of the report defined by your bylaws or the French Commercial Code.

Automate follow-ups

For an annual report with many shareholders, manual follow-up management is impractical. Certyneo allows you to schedule automatic follow-ups:

• D+3: first follow-up for signatories who have not opened the invitation email.
• D+7: second follow-up for signatories who have opened but not yet signed.
• D+14: final follow-up mentioning the folder expiration deadline.

Each follow-up is logged in the folder with a timestamp, which constitutes proof of diligence in case of later dispute. For companies managing multiple annual reports (subsidiaries, funds) and wanting to refine their electronic signature productivity calculation, the electronic signature ROI calculator helps estimate gains compared to a paper or standard email process.

Export the signature report

Once all signatories have affixed their signature (or at folder expiration), Certyneo automatically generates:

• The audit report (audit trail) in PDF format, listing each timestamped event: opening, authentication, signature, electronic identity used.
• The consolidated signed document with integrated electronic signatures, archived for a configurable duration (from 5 to 30 years depending on the retention policy defined in your account).

This audit report is the cornerstone in case of dispute: it proves that each signatory received, opened, and signed the document under the required conditions. It must be preserved at the same security level as the document itself, in compliance with obligations under article 1366 of the French Civil Code and the eIDAS regulation.

---

Optimizing your import process for subsequent years

CSV import of an annual report is not an isolated event: it repeats each fiscal year. A few best practices allow you to reduce preparation time from one year to the next.

Maintain a master CSV file

Keep a master CSV file of your permanent signatories (board members, statutory auditors, stable shareholders). Each year, you only need to update entries that have changed (departures, new shareholders, email changes) rather than rebuild the file from scratch.

Use Certyneo folder templates

Certyneo allows you to save a folder as a template: workflow parameters, personalized invitation message, signature order, signature levels by group. Next year, simply load the template, import the updated CSV, and replace the report PDF. This configuration saving represents in practice 60 to 80% of the setup time for a new folder.

Connect your shareholder registry via API

For companies with a shareholder registry in management software (ERP, cap table tool), Certyneo's REST API allows complete automation of export-import. A scheduled script can extract the list of shareholders the day before sending the report, generate the CSV, upload it via API, and launch the signature folder without human intervention. This approach is particularly relevant for structures managing dozens of subsidiaries or hundreds of shareholders. For teams wanting to evaluate Certyneo pricing suited to this usage volume, the dedicated page details API options and enterprise packages.

Legal framework applicable to electronic signature of an annual report

Importing CSV contacts and sending an annual report to signatories via an electronic signature platform falls within a precise legal framework that every company must master before deploying this type of process.

Legal value of electronic signature

Article 1366 of the French Civil Code states that "electronic writing has the same probative force as writing on paper support" provided that "the person from whom it originates can be duly identified and it is established and preserved under conditions capable of guaranteeing its integrity". Article 1367 clarifies that electronic signature "consists in the use of a reliable identification process guaranteeing its link with the act to which it is attached".

At the European level, eIDAS Regulation No. 910/2014 (and its eIDAS 2.0 update currently being transposed) defines three levels of signature: simple electronic signature (SES), advanced electronic signature (AES), and qualified electronic signature (QES). For an annual report intended for shareholders, the minimum recommended level is advanced signature, which requires strong authentication of the signatory (SMS OTP, certificate) and use of signature creation data uniquely linked to the signatory.

Personal data protection (GDPR)

Importing a CSV file containing personal data (name, first name, email address, phone number) constitutes data processing under GDPR Regulation No. 2016/679. As such, the company performing this import is qualified as a data controller and must:

• Ensure that data collection is based on a valid legal basis (article 6 GDPR): contract performance (shareholding) or compliance with a legal obligation (account filing, general assembly) constitute solid legal bases.
• Inform signatories of data processing in accordance with articles 13 and 14 of GDPR (legal notices in the invitation message).
• Govern the relationship with Certyneo via a data processing agreement (Data Processing Agreement, DPA) compliant with article 28 GDPR. Certyneo provides this contractualized document in the terms of service.
• Respect retention periods: signatory data and audit report must be kept for at least 5 years (commercial limitation period, article L.110-4 of the French Commercial Code) and up to 30 years for acts relating to real property rights or major corporate commitments.

Applicable technical standards

The advanced and qualified electronic signature formats used by Certyneo comply with ETSI EN 319 132 (XAdES), ETSI EN 319 122 (CAdES), and ETSI EN 319 162 (PAdES for PDFs) standards. These standards guarantee interoperability of signatures between EU member states and their recognition by European judicial systems.

Finally, the NIS2 Directive (2022/0383/COD), transposed into French law in 2024, imposes enhanced cybersecurity requirements on digital service operators, including electronic signature platforms. Certyneo integrates these requirements via TLS 1.3 encryption of communications, encryption at rest of documents, and an active bug bounty program.

Use scenarios: CSV import and annual report in practice

Scenario 1 — A family holding managing twenty subsidiaries

A family holding with stakes in twenty structures must each year have the consolidated annual report signed by all managers and partners of its subsidiaries, approximately 80 signatories. Before implementing CSV import, the general secretary spent on average 3 hours manually entering coordinates into the signature tool, with a data entry error rate of approximately 8% (incorrect addresses, reversed names).

After adopting structured CSV import on Certyneo, the folder preparation time dropped to 25 minutes (including 15 minutes to update the master CSV). The data entry error rate fell to zero. Automatic follow-ups scheduled at D+3 and D+7 achieved 100% signature completion in an average of 9 days, versus 22 days with the previous postal process. This 60% reduction in signature collection time is consistent with the ranges published by professional associations of group general secretaries.

Scenario 2 — An agricultural cooperative with several hundred members

An agricultural cooperative with 340 active members must annually submit for member approval the management report and certified accounts. Members, scattered across several departments, could not all attend the general assembly, which delayed formal process closure.

By integrating CSV import into Certyneo, the cooperative was able to simultaneously send documents to all members with a parallel signature workflow. The CSV file, exported directly from the equity management software, contains all current coordinates. Simple electronic signature (SES) was chosen for member signatories of the approval deed, this level being sufficient for routine management acts according to internal legal analysis. The signature rate within 10 days reached 91%, versus 67% via the previous postal process, significantly reducing registered mail costs (estimated at €4 to €6 per piece according to La Poste 2026 rates).

Scenario 3 — A consulting firm assisting multiple clients with year-end closing

A management consulting firm assisting twenty TPE/SME clients with annual accounting obligations centralizes annual report signature collection on behalf of its clients. Each client has a different signatory list (partners, managers, accountants).

Thanks to Certyneo's multi-client sub-spaces and CSV import per folder, the firm standardized its process: one CSV template per structure type (SARL, SAS, SA), a documented import procedure provided to assistants, and a consolidated dashboard allowing the manager to track signature progress across all clients. The estimated time savings is 2 to 3 hours per client per fiscal year, representing between 40 and 60 hours across the entire annual portfolio. This gain is reinvested in higher value-added missions for clients.

Conclusion

Importing contacts from a CSV file for an annual report is not simply a matter of technical convenience: it is a strategic decision that determines the legal reliability, execution speed, and GDPR compliance of your signature process. A well-structured CSV, careful mapping, automated follow-ups, and rigorous audit reporting form the four pillars of a seamless annual signature workflow.

Whether you are a holding, cooperative, or firm assisting multiple clients, Certyneo provides the tools needed to industrialize this import while respecting eIDAS Regulation and GDPR requirements. Ready to simplify your next annual report? Create your Certyneo account free and import your first CSV in less than five minutes.