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 Bodies

• 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

Key Locations

• Certification Body Identity Number

• Key Location ID

• Office Type

• Street

• City

• State

• Country/Economy

• Zipcode/Postcode

Standards & Schemes

• 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

Technical Sectors

• 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 Countries

• 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.

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

3. 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​

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

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