Importing CSV Contacts for an Annual Report: The Guide

Why Import Your Contacts in CSV Format for an Annual Report?

Every year, joint stock companies, holding companies and associations must have their annual report signed by a set of stakeholders: board members, shareholders, statutory auditors and, depending on the articles of association, by all share holders. Manually entering each email address into an electronic signature platform represents considerable time loss 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 in just a few seconds directly into your signature workflow.

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

---

Preparing Your CSV File: Structure and Best Practices

The quality of the import depends directly on the rigour 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)
• firstname: contact's first name, used to personalise the invitation message
• lastname: surname
• role: role in the signature process (e.g. `signatory`, `viewer`, `approver`)
• signature_order: integer indicating position in a sequential workflow (leave empty for parallel signature)
• telephone (optional): number in international E.164 format (+33XXXXXXXXX) for SMS authentication as part of advanced signature
• group (optional): business category (e.g. `majority_shareholder`, `board_of_directors`, `statutory_auditor`)

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

Cleanse Data Before Import

Before uploading your CSV, carry out a cleansing 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 over the value of the signature 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 rights (management report) while others must affix a formal signature (assembly resolutions). Distinguish them clearly in the `role` column.
4. Phone number checks: if you opt for advanced electronic signature with OTP via SMS, 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,firstname,lastname,role,signature_order,telephone,group jean.dupont@example.fr,Jean,Dupont,signatory,1,+33612345678,board_of_directors marie.martin@example.fr,Marie,Martin,signatory,2,+33698765432,majority_shareholder pierre.durand@example.fr,Pierre,Durand,viewer,,+33677889900,statutory_auditor ```

Note that `Pierre Durand`, statutory auditor with read-only access, has no signature order (empty column) as 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 space and click New folder.
2. Upload the PDF document of the annual report (management report, consolidated accounts, resolutions). You can use Certyneo's AI contract generator if you need to prepare a supplementary assembly 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: tick the box if the first line of your CSV contains column names (recommended).
• Column mapping: Certyneo proposes automatic mapping based on standard column names. Verify that each column is correctly associated with the right 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 fields are empty or incorrectly formatted. The system flags in red lines containing blocking errors (invalid email, unknown role) and in orange non-blocking warnings (missing phone number for an advanced signatory).

Validate and Configure the Workflow

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

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

---

Managing Errors and Follow-ups After Import

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

Handling Bounces and Invalid Addresses

Certyneo reports in real time soft bounces (full mailbox) and hard bounces (non-existent address). 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 card.
3. Resend the invitation individually without recreating the entire folder.

This granular correction capability is essential to meet legal deadlines for notice or distribution of the report defined by your articles or by the 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:

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

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

Export the Signature Report

Once all signatories have affixed their signature (or at folder expiry), 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 period (5 to 30 years depending on the retention policy defined in your space).

This audit report is the key document 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 accordance with the obligations of article 1366 of the Civil Code and the eIDAS regulation.

---

Optimising Your Import Process for Future Years

The CSV import of an annual report is not an isolated event: it repeats each financial 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 address changes) rather than rebuilding the file from scratch.

Use Certyneo Folder Templates

Certyneo allows you to save a folder as a template: workflow parameters, personalised invitation message, signature order, signature levels by group. The following 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 Register via the API

For businesses with a shareholder register in management software (ERP, cap table tool), Certyneo's REST API enables complete automation of export-import. A scheduled script can extract the shareholder list the day before the report send, generate the CSV, upload it via API and launch the signature folder without human intervention. This approach is particularly relevant for structures managing several dozen subsidiaries or several hundred shareholders. For teams wishing 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

The import of CSV contacts and sending of an annual report to signatories via an electronic signature platform falls within a specific legal framework that any business must master before deploying this type of process.

Legal Value of Electronic Signature

Article 1366 of the French Civil Code provides that "electronic writing has the same probative force as writing on paper" subject to "the person from whom it emanates being duly identified and it being established and preserved under conditions designed to guarantee its integrity". Article 1367 specifies that electronic signature "consists of the use of a reliable identification method guaranteeing its link with the act to which it attaches".

At European level, regulation eIDAS 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 the use of signature creation data uniquely linked to the signatory.

Personal Data Protection (GDPR)

Importing a CSV file containing personal data (name, surname, email address, phone number) constitutes data processing within the meaning of regulation GDPR No. 2016/679. As such, the business carrying out this import is qualified as data controller and must:

• Ensure that data collection is based on a valid legal basis (article 6 GDPR): execution of a contract (shareholding) or compliance with a legal obligation (filing accounts, general assembly) constitute solid legal bases.
• Inform signatories of data processing in accordance with articles 13 and 14 of the GDPR (legal notices in the invitation message).
• Frame the relationship with Certyneo by a data processing agreement (Data Processing Agreement, DPA) compliant with article 28 GDPR. Certyneo provides this contractualised document in the general terms of use.
• Respect retention periods: signatory data and the audit report must be kept for at least 5 years (commercial limitation period, article L.110-4 of the 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 standards ETSI EN 319 132 (XAdES), ETSI EN 319 122 (CAdES) and ETSI EN 319 162 (PAdES for PDFs). These standards guarantee interoperability of signatures between EU Member States and their recognition by European legal systems.

Finally, the NIS2 directive (2022/0383/COD), transposed into French law in 2024, imposes strengthened 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 programme.

Usage Scenarios: CSV Import and Annual Report in Practice

Scenario 1 — A Family Holding Managing Twenty-odd Subsidiaries

A family holding owning stakes in around 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 contact details into the signature tool, with a data entry error rate of approximately 8% (incorrect addresses, reversed first names).

After adopting structured CSV import on Certyneo, the time to prepare the folder dropped to 25 minutes (of which 15 minutes updating the master CSV). The data entry error rate fell to zero. Automatic follow-ups scheduled for Day 3 and Day 7 enabled 100% of signatures to be obtained within an average timeframe of 9 days, versus 22 days with the old postal process. This 60% reduction in signature collection time is consistent with 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 each year submit the management report and certified accounts for approval by its members. Members, spread 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 its members with a parallel signature workflow. The CSV file, exported directly from share management software, contains all up-to-date contact details. Simple electronic signature (SES) was selected 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 item according to 2026 La Poste rates).

Scenario 3 — A Consulting Firm Supporting Several Clients at Their Annual Closure

A consulting firm assisting twenty TPE/SME clients with their annual accounting obligations centralises annual report signature collection for its clients' accounts. Each client has a different list of signatories (partners, managers, accountants).

Thanks to Certyneo's multi-client sub-spaces and CSV import per folder, the firm standardised its process: one CSV template per structure type (SARL, SAS, SA), an import procedure documented for assistants, and a consolidated dashboard allowing the manager to track signature progress for all clients. The estimated time saving is 2 to 3 hours per client per financial year, that is 40 to 60 hours across the entire annual portfolio. This saving 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 conditions 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 a holding, cooperative or firm supporting several clients, Certyneo provides the tools needed to industrialise this import whilst respecting eIDAS regulation and GDPR requirements. Ready to simplify your next annual report? Create your Certyneo account free of charge and import your first CSV in under five minutes.