# 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](https://support.iafcertsearch.org/accreditation-bodies/data-management/certification-bodies/add-cb)
>
> [Updating CB Data ](https://support.iafcertsearch.org/accreditation-bodies/data-management/certification-bodies/manage-cb-details)
>
> [Withdraw a CB](https://support.iafcertsearch.org/accreditation-bodies/certification-bodies/manage-cb-accreditation#withdraw-cb-accreditation-information)
>
> [Suspend a CB](https://support.iafcertsearch.org/accreditation-bodies/certification-bodies/manage-cb-accreditation#suspend-cb-accreditation-information)
>
> [Add Accreditation details to an existing CB](https://support.iafcertsearch.org/accreditation-bodies/data-management/certification-bodies/manage-cb-accreditation)

### Import Certification Body Data from Excel file <a href="#adding-certification-data-from-excel-file" id="adding-certification-data-from-excel-file"></a>

{% hint style="info" %}
**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. &#x20;
  {% endhint %}

**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](https://support.iafcertsearch.org/accreditation-bodies/iaf-certsearch-data-structure/certification-body-fields-glossary) to know more.

{% tabs %}
{% tab title="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
  {% endtab %}

{% tab title="Key Locations" %}

* Certification Body Identity Number
* Key Location ID
* Office Type
* Street
* City
* State
* Country/Economy
* Zipcode/Postcode
  {% endtab %}

{% tab title="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
  {% endtab %}

{% tab title="Technical Sectors" %}

* Certification Body Identity Number
* Scheme/Program
* Accredited Standard
* Sector/IAF Code Title
* Sector/IAF Code&#x20;
* Sector Accreditation Status
* Suspended/Withdrawn Date
* Full/Limited
* Extent of Scope
  {% endtab %}

{% tab title="Certification Body Countries" %}

* Certification Body Identity Number
* Country/Economy
* Scheme/Program
* Accredited Standard&#x20;
* Economy Accreditation Status
* Suspended/Withdrawn Date
  {% endtab %}
  {% endtabs %}

{% hint style="info" %}
It is important to know what are the record identifiers to minimize data integrity issues.&#x20;

**Tips:** Ensure that the **Certification Body Identity Number** and the Certification Body Name match with the existing Certification Body record.
{% endhint %}

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​](https://support.iafcertsearch.org/accreditation-bodies/data-management/import-certification/data-import-methods/file-upload)
* **FTP** [Learn how to import data through FTP​](https://support.iafcertsearch.org/accreditation-bodies/data-management/import-certification/data-import-methods/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.