Certification Bodies
English
English
  • Getting Started
    • Overview
    • Activation
    • Documentation Legacy
  • Overview
    • 🆕Dashboard
    • 🆕Analytics
      • Certifications
      • Certified Entities
  • Data Management
    • Mandatory Document (MD) Compliance
      • Exclusion from Data Obligations
    • Certified Entities
      • All Imported Certified Entities
      • Add Certified Entity
      • Edit Certified Entity
      • CE Activation
      • Mark CE Information as Confidential
      • Add Certification
      • 🆕Add Certified Entity Sites
      • 🆕Edit Certified Entity Sites
      • 🆕Delete Certified Entity Sites
      • Certified Entity Detail Page
    • Certifications
      • All Imported Certifications
      • CB Imported Data
      • Update All
      • Add Certification
      • Edit Certification
      • Mark Certification Information as Confidential
      • Delete Certification
      • Add Multiple Standards
      • Add Technical Sectors
      • Remove Technical Sectors
      • Add Certification Sites
      • Edit Additional Sites
      • Delete Certification Site
    • Standards and Schemes
      • Standards and Schemes
      • Technical Sectors
      • Country / Economy
      • Key locations
    • Import Certification
      • Certification Templates
        • Excel General Rules
        • Manage Data in Excel
        • XML General Rules
        • Manage Data in XML
      • Data Import
        • Data Import Methods
          • File Upload
          • FTP
          • API
        • API Integration
      • Import Activities
    • Import Settings
      • Template Versioning
      • Global Mapping
        • Data Mapping
          • Data Mapping by Country
          • Data mapping by Certification Status
          • 🆕Data Mapping by Sectors
          • Data Mapping by Certification Type
        • Field Mapping
      • FTP Settings
      • Auto Import Settings
  • Error Handling
    • Error Handling
    • Resolve Field Mapping Issues
    • Resolve Field Check Issues
    • Resolve Data Mapping Issues
    • Resolve Data Check Issues
  • Settings
    • Accounts
    • Users
    • Certification Body Profile
    • Settings
      • User Settings
      • Security Settings
      • Notification Settings
  • Field Name Glossary
    • Certified Entity and Certification Data Fields
      • Version 1
        • Certified Entity Data Fields
        • Certification Data Fields
      • Version 1.1
        • Certified Entity Data Fields
        • Certification Data Fields
      • Version 2.0
        • Certified Entity Data Fields
        • Certification Data Fields
          • Certification Standard & Scheme
          • Certification Sites
      • Version 2.1
        • Certified Entity Data Fields
        • Certification Data Fields
          • Certification Standard & Scheme
          • Certification Sector
          • Certification Sites
    • IAF CertSearch Dataset
      • Countries
      • Certification Sites
      • Certification Status
      • Technical Sectors
Powered by GitBook

Copyright © 2023 IAF CertSearch. All Right Reserved

On this page
  • General Rules
  • DOs
  • DONTs
  • Tips

Was this helpful?

  1. Data Management
  2. Import Certification
  3. Certification Templates

Excel General Rules

General Rules

File Format

File format should be .xlsx only

Column Header Names

Keep the column names the same as the template.

If changed, the system requires field mapping to recognise the data.

Column Sequence

Keep the order of the columns the same as in the template.

If changed, the data processing may be disrupted and cause data errors.

Sheet Tab Sequence

Keep the order of the sheet tabs the same as in the template.

If changed, the data processing may be disrupted and cause data errors.

Record limit

The maximum record limit for the certification sheet of the Excel file is 10,000. If the certification sheet in your Excel file has more than 10,000 records, then you need to upload multiple files that are only limited to up to 10,000 records per file.

File size

The maximum file size for Excel files is 50MB. If your Excel file is greater than 50MB then you need to upload multiple files that are all less than 50MB.

File name(s)

IAF CertSearch recommends you name your files as per below:

Single: cb_certs.xlsx

Multiple files: cb_certs_1.xlsx, cb_certs_2.xlsx, cb_certs_3.xlsx

DOs

  1. Keep data format consistent

  2. Format data into the provided IAF CertSearch template

  3. Enter single data value entry per cell

DONTs

  1. Do not upload other formats supported in Excel, such as .xls, .xlsm, .xlsb, .xlr

  2. Do not delete any columns from the template. If deleted, the system will throw a missing field error.

  3. Do not skip field mapping. If skipped, data is not processed and imported.

  4. Do not merge columns. If merged, the system throws a data field error.

  5. Do not leave the required fields empty

  6. Do not format data values as formulas.

Tips

  • To minimize import interruptions, it is recommended not to update/delete/change any of the field names and structure.

  • Remove any unnecessary or redundant columns that won't be used in the analysis.

  • Check for missing or incomplete data and decide how to handle it (e.g., filling in missing values, removing rows, etc.).

  • Validate data entries to ensure they meet required standards (e.g., valid dates, numeric values, etc.).\

  • Remove Duplicates. Eliminate duplicate rows or entries to prevent redundancy and inaccuracies in analysis.

  • Make sure data types for each column match the requirements of IAF CertSearch. For example, data values should be in the text format.

  • Thoroughly understanding the IAF CertSearch requirements and the characteristics of your data will help ensure a successful data import process.

PreviousCertification TemplatesNextManage Data in Excel

Last updated 10 months ago

Was this helpful?