LogoLogo
English
PortugueseArabicChineseHindiGermanRussianSpanishKoreanFrenchJapaneseEnglish
English
PortugueseArabicChineseHindiGermanRussianSpanishKoreanFrenchJapaneseEnglish
  • Getting Started
    • Overview
    • Activation
    • Documentation Legacy
  • Overview
    • Dashboard
    • Analytics
      • Certifications
      • Certified Entities
      • Certification Bodies
  • Data Management
    • Mandatory Document (MD) Compliance
    • Overview
    • Certification Bodies
      • Update All
      • Add CB
      • CB Activation
      • Manage CB Details
      • CB Participating Status Matrix
      • Exclusion to Data Obligations
      • Manage CB Accreditation
      • Manage CB Accreditation Information
        • Manage CB Standards and Schemes
        • Manage CB Key Locations
        • Manage CB Technical Sectors
        • Manage CB's Country/Economy
    • Certified Entities
      • Mark CE Information as Confidential
    • Certifications
      • Bulk Import Certification
      • Edit Certification
      • Mark Certification Information as Confidential
      • Add Multiple Standards
      • Add Additional Sites
      • Edit Additional Site
      • Delete Additional Site
      • 🆕Add Technical Sectors
      • Remove Technical Sectors
      • Delete Certification
    • Standards and Schemes
      • Manage Standards and Schemes
        • Add Standard to Library
        • Add Scheme to Library
      • IAF MLA
      • 🆕Technical Sectors
    • Import Certification Body
      • Certification Body Templates
        • Manage Data in Excel
        • Manage Data in XML
      • File Upload
      • FTP Upload
    • Import Certification
      • Certification File Templates
        • Excel General Rules
        • Manage Data In Excel
        • XML General Rules
        • Manage Data in XML
      • Data Import Methods
        • File Upload
        • FTP Upload
        • API Documentation
      • Import Activities
    • Import Settings
      • FTP Settings
      • API Integration
      • Global Mapping
        • Data Mapping
          • Data Mapping by Country
          • Data Mapping by Certification Type
          • Data Mapping by Certification Status
          • Data Mapping by Certification Site Type
          • Data Mapping by Sectors
        • Field Mapping
      • Auto-import Settings
      • Template Versioning
  • IAF CertSearch Data Structure
    • Templates
    • Certification Fields Glossary
    • Certification Body Fields Glossary
    • IAF CertSearch Dataset
      • Countries
      • Accreditation Status
      • Certification Status
      • Certification Sites
      • Standards
      • Schemes
      • Technical Sectors
  • Error Handling
    • Error Handling
    • Resolve Field Mapping Issues
    • Resolve Field Check Issues
    • Resolve Data Mapping Issues
    • Resolve Data Check Issues
      • Handling CE Records
  • Settings
    • Accounts
    • Users
    • Accreditation Body Profile
    • Settings
      • User Settings
      • Notification Settings
      • Security Settings
Powered by GitBook

Copyright © 2023 IAF CertSearch. All Right Reserved

On this page
  • Import Data in Excel
  • Import Certification Body Data from Excel file

Was this helpful?

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

Manage Data in Excel

Import Data in Excel

We have added useful guides to help you manage your data in an Excel file.

Adding CB Data

Updating CB Data

Withdraw a CB

Suspend a CB

Add Accreditation details to an existing CB

Import Certification Body Data from Excel file

NOTE: Adding Certification Body via Excel is recommended for bulk data import. If you want to update a single record or records not more than 10 certificates we recommend you use the Manual Data Entry. Prerequisites:

  • Clean and format data according to the IAF CertSearch data structure.

To update the Certification Body via Excel

  1. In the Certification Body Excel spreadsheet, enter the data into their corresponding fields.

-> View Certification Body Fields to know more.

  • Certification Body Identity Number

  • Certification Body Name

  • Certification Body Acronym

  • Accreditation Status

  • Website

  • Public Email Address

  • Public Phone Number

  • Public Fax Number

  • Country/Economy

  • Description

  • Certification Body Identity Number

  • Key Location ID

  • Office Type

  • Street

  • City

  • State

  • Country/Economy

  • Zipcode/Postcode

  • Certification Body Identity Number

  • Scope Type

  • Scheme/Program

  • Certification Standard Code

  • Standard Status

  • Accreditation First Issue Date

  • Accreditation Issue Date

  • Accreditation Expiry Date

  • Key Location ID

  • Certification Body Identity Number

  • Scheme/Program

  • Accredited Standard

  • Sector/IAF Code Title

  • Sector/IAF Code

  • Sector Accreditation Status

  • Suspended/Withdrawn Date

  • Full/Limited

  • Extent of Scope

  • Certification Body Identity Number

  • Country/Economy

  • Scheme/Program

  • Accredited Standard

  • Economy Accreditation Status

  • Suspended/Withdrawn Date

It is important to know what are the record identifiers to minimize data integrity issues.

Tips: Ensure that the Certification Body Identity Number and the Certification Body Name match with the existing Certification Body record.

  1. Once completed, go to the IAF CertSearch Data Import page

  2. Choose how you would like to import your data

  • File Upload - Learn how to import data through File Upload​

  • FTP Learn how to import data through FTP​

  1. Once selected, click the Continue button (the system will initiate file and data processing)

  2. If all the files and data are valid, the certificate will be successfully added to the existing Certified Body record.

PreviousCertification Body TemplatesNextManage Data in XML

Last updated 7 months ago

Was this helpful?