# CertificatesList

#### <span style="color: rgb(0, 65, 130);">General</span>

<span lang="EN-US">This part is used to load all information about certificates in MXSuite.<span style="mso-spacerun: yes;">  </span>The sheet is called “CertificatesList”.</span>

#### <span style="color: rgb(0, 65, 130);">Details fields</span>

<span style="color: rgb(0, 0, 0);">To fill the Excel file correctly, ensure that all fields are completed accurately. Below are the fields listed.</span>

<table border="1" id="bkmrk-field-max-characters" style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Oxygen, Ubuntu, Roboto, Cantarell, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; width: 105.357%; height: 892.763px;"><colgroup><col style="width: 25.7388%;"></col><col style="width: 10.2479%;"></col><col style="width: 9.77064%;"></col><col style="width: 54.2189%;"></col></colgroup><thead><tr style="background-color: rgb(230, 126, 35); height: 46.5875px;"><td style="height: 46.5875px;">Field</td><td style="height: 46.5875px;">MAX Characters</td><td style="height: 46.5875px;"> Required</td><td style="height: 46.5875px;">Comment</td></tr></thead><tbody><tr style="height: 38.1875px;"><td style="height: 38.1875px;">Category</td><td style="height: 38.1875px;">128</td><td style="height: 38.1875px;">X</td><td style="height: 38.1875px;">Name of the category to which the certificate is connected</td></tr><tr style="height: 35.1875px;"><td style="height: 35.1875px;">Name</td><td style="height: 35.1875px;">128</td><td style="height: 35.1875px;">X</td><td style="height: 35.1875px;">Name of the certificate</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Number</td><td style="height: 29.6px;">128</td><td style="height: 29.6px;">X</td><td style="height: 29.6px;">The number of the certificate</td></tr><tr style="height: 180.8px;"><td style="height: 180.8px;">CertificateType</td><td style="height: 180.8px;">  
</td><td style="height: 180.8px;">X</td><td style="height: 180.8px;">Here can be given if an annual or intermediate survey is needed for this certificate.  
In case that an annual as well as an intermediate survey is needed, enter both values  
comma-separated like in the second example below.  
Possible values are:  
- None  
- Annual  
- Intermediate  
- Annual, Intermediate  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">RenewalAfterValue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">RenewalAfterIntervalType</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">DateOfIssue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">The date of issue of the certificate (dots, but nl-NL)</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">DateOfExpiry</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BirthDateOfShip</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeAnnualIntervalValue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeAnnualIntervalType</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">AfterAnnualIntervalValue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">AfterAnnualIntervalType</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeIntermediateIntervalValue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeIntermediateIntervalType</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">AfterIntermediateIntervalValue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">AfterIntermediateIntervalType</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeNoneIntervalValue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeNoneIntervalType</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeLastSurveyIntervalValue</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">BeforeLastSurveyIntervalType</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Storage</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Comment</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr></tbody></table>

#### <span style="color: rgb(0, 65, 130);">Example</span>

[![image.png](https://docs.mxsuite.nl/uploads/images/gallery/2026-11/scaled-1680-/O0eimage.png)](https://docs.mxsuite.nl/uploads/images/gallery/2026-11/O0eimage.png)