Import formats and canonical headers

CSV, Excel, and ODS

Use UTF-8 CSV, .xlsx, or value-only .ods. Legacy binary .xls is not accepted; convert it in a trusted spreadsheet application, inspect the converted workbook, and save it as .xlsx. A canonical closed-table row contains table_code, row_code, column_code, and value. A canonical cell identity can instead use cell_id and value. Open tables and tables with additional axes require the dimensions needed to identify a unique cell:v2 context.

Example synthetic CSV:

table_code,row_code,column_code,value

S.01.02.01.01,R0010,C0010,Synthetic value

Column names must be unique. Duplicate logical cells, unknown templates, invalid values, and noncanonical aliases are rejected. CSV follows quoted-field rules, including escaped double quotes.

Decimal text from CSV and ODS remains decimal text through mapping, preview, validation, and apply. Scaling, offsets, sums, tolerance checks, and reconciliation use decimal arithmetic and do not route reported values through JavaScript binary floating point.

Generated filing template

Select Download Excel template in a filing's import panel to create the recommended .xlsx starting point. The workbook is specific to that filing and contains an instruction sheet plus one worksheet for each applicable EIOPA form. If the regulatory S.01.01 contents template explicitly marks another form as reported, that form is included too, so the workbook never declares a reported form while omitting its worksheet. Any disagreement with the filing's confirmed applicability decisions remains visible to validation and must be resolved before review or export.