Format Validator

Our online validation tools allow you to check integrity of your files and document’s embedded metadata. In case you are using one of the industry standards for templates (FinDatEx, openfunds, …) or embedded metadata, ensure your files and documents meet the required criteria for system processing. You should only submit your data/documents after you have successfully validated them.

Please refer to the Templates and Guides section for the specification details of various template types.

openfunds static data files

Spreadsheet validation - check static data files in openfunds format.

To validate openfunds regulatory files, please use the validator on this page, section ‘Regulatory data files’.

Document Validator

There are various tools available for the validity testing of PDF metadata, document URLs and CSV structure.

PDF Metadata - this tool checks whether a PDF document meets the metadata specifications.

Document URL - validate a document URL as such, not the PDF itself. Test if the URL is returning a PDF in a way that we are able to process the document.

Doc-Transfer System - validate your Doc-TS feed file to ensure that you are meeting the requirements of our specifications.

Regulatory data templates, old FE static data files and Portfolios

Please select the template you want to test:

REGULATORY STATIC DATA FULL PORTFOLIO HOLDINGS RATIOS AND EXPOSURES

Please select a specific template type to validate:

EPT
CEPT
EMT
EET
CET
DCPT
FVPT
DDO
FE Static Europe
FE Static Asia
FE Static Australia
TPT (subset for portfolio holdings)
TPT (full delivery for Solvency II)
openfunds
openfunds

Select which EPT format you want to test:

FinDatEx EPT V2.0 / V2.1 / V2.1 UK
openfunds EPT V2.0 / V2.1 / V2.1 UK

Select which CEPT format you want to test:

FinDatEx CEPT Performance V2.0
FinDatEx CEPT History V2.0

Select which EMT format you want to test:

FinDatEx EMT V4 / V4.1 / V4.2 / V4.3
openfunds EMT V4 / V4.1 / V4.2 / V4.3

Select which EET format you want to test:

FinDatEx EET V1.1.1
FinDatEx EET V1.1.2 / V1.1.3

Select which data type you want to test:

Ratios
Exposures (breakdowns)

Select which DDO format you want to test:

DDO V1.3
DDO V2.0
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Submission”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Please note that EPT data is expected to be supplied only once, either in FinDatEx or in openfunds standard.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Please note that CEPT V2.0 data is expected to be supplied in FinDatEx standard.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Please note that EMT V3.0 / V3.1 data is expected to be supplied only once, either in FinDatEx or in openfunds standard.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Please note that EMT data is expected to be supplied only once, either in FinDatEx or in openfunds standard.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Please be aware that if an "N" value is received in the section field (00006 / 00007 / 00008) in a new file, FEfundinfo will distribute the data from the previous file, where the corresponding section field was marked as "Y".
  • Please note that EMT data is expected to be supplied only once, either in FinDatEx or in openfunds standard.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Please be aware that if an "N" value is received in the section field (00006 / 00007 / 00008) in a new file, FEfundinfo will distribute the data from the previous file, where the corresponding section field was marked as "Y".
  • Please note that the portfolio holdings data is expected to be supplied only once, either in TPT or in openfunds format.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Please note that Ratios and Exposures data is expected to be supplied in two separate templates, both adhering to the OFRE codification.
  • Files in xlsx with multiple tabs: Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.
  • Files in csv or txt: Please ensure that you are using pipes [|] (Alt + 124) as field separators.
  • Files must be in xlsx. Please ensure that the sheet containing the data is labelled “Data”, so that our system recognises the sheet which the data needs to be extracted from.

Please select a file to validate.

Validate File

Error Occured
Error Details:

Cell Position: {{item.ExcelColumnName}} Row Position: {{item.ExcelColumnName}} error warning

Error: {{item.ErrorMessage}}

Column Name: {{item.FieldName}}, Column Value: {{item.FieldValue}}

Error: {{item.ErrorMessage}}

Validation successful