> For the complete documentation index, see [llms.txt](https://support.iafcertsearch.org/accreditation-bodies/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.iafcertsearch.org/accreditation-bodies/ab-zh/data-management/import-certification-body/certification-body-templates/manage-data-in-excel.md).

# 在Excel中管理数据

## 在Excel中导入数据

我们已经添加了一些有用的指南，帮助您在Excel文件中管理您的数据。

> [添加CB数据](/accreditation-bodies/ab-zh/data-management/certification-bodies/add-cb.md)
>
> [更新CB数据](/accreditation-bodies/ab-zh/data-management/certification-bodies/manage-cb-details.md)
>
> [撤销CB](/accreditation-bodies/ab-zh/data-management/certification-bodies/manage-cb-accreditation.md#withdraw-cb-accreditation-information)
>
> [暂停CB](/accreditation-bodies/ab-zh/data-management/certification-bodies/manage-cb-accreditation.md#suspend-cb-accreditation-information)
>
> [向现有CB添加认证细节](/accreditation-bodies/ab-zh/data-management/certification-bodies/manage-cb-accreditation.md)

### 从Excel文件中导入认证机构数据 <a href="#tian-jia-ren-zheng-shu-ju-cong-excel-wen-jian" id="tian-jia-ren-zheng-shu-ju-cong-excel-wen-jian"></a>

{% hint style="info" %}
\*\*注意：\*\*通过Excel添加认证机构是推荐的批量数据导入方式。如果您只想更新一条记录或不超过10个证书的记录，我们推荐您使用手动数据录入。\
\
**前提条件：**

* 根据IAF CertSearch数据结构清理和格式化数据。
  {% endhint %}

**更新认证机构通过Excel**

1. 在认证机构Excel电子表格中，将数据输入到相应的字段中。

{% tabs %}
{% tab title="认证机构" %}

* Certification Body Identity Number
* Certification Body Name
* Certification Body Acronym
* Accreditation Status
* Website
* Country/Economy
* Description
  {% endtab %}

{% tab title="办公室目录" %}

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

{% tab title="标准和计划" %}

* Certification Body Identity Number
* Scope Type
* Scheme/Program
* Certification Standard Code
* Standard Status
* Accreditation First Issue Date
* Accreditation Issue Date
* Accreditation Expiry Date
  {% endtab %}

{% tab title="技术领域" %}

* Certification Body Identity Number
* Scope Type
* Scheme/Program
* Sector/IAF Code
* Title Sector/IAF Code
* All Sectors
  {% endtab %}

{% tab title="认证机构国家" %}

* Certification Body Identity Number
* Country/Economy
  {% endtab %}
  {% endtabs %}

\*\*提示：\*\*确保认证机构身份代码和认证机构名称与现有的认证机构记录匹配。

2. 完成后，转到IAF CertSearch数据导入页面。
3. 选择如何导入您的数据
   1. **文件上传** - [了解如何通过文件上传导入数据](https://app.gitbook.com/s/tS6z5hiHjMyFZFqdXIJ0/iaf-certsearch-data-structure/data-import-methods/file-upload)
   2. **FTP** [了解如何通过FTP导入数据](https://app.gitbook.com/s/tS6z5hiHjMyFZFqdXIJ0/iaf-certsearch-data-structure/data-import-methods/ftp)
4. 选择完毕后，点击 **继续**按钮（系统将启动文件和数据处理）
5. 如果所有文件和数据都有效，则证书将成功添加到现有的认证实体记录。