# 在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. 如果所有文件和数据都有效，则证书将成功添加到现有的认证实体记录。


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.iafcertsearch.org/accreditation-bodies/ab-zh/data-management/import-certification-body/certification-body-templates/manage-data-in-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.