> 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/data-management/import-certification-body/certification-body-templates/manage-data-in-xml.md).

# Manage Data in XML

### Import Certification Body Data from XML 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 XML 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 XML file, enter the data into their corresponding fields.

<details>

<summary>CB Data XML Fields</summary>

```
<?xml version="1.0" encoding="UTF-8"?>
<ab_cbs>
	<certification_body>
		<certification_body_identity_number>cbin-01</certification_body_identity_number>
		<certification_body_name>Bear Certify</certification_body_name>
		<certification_body_acronym>BC</certification_body_acronym>
		<website></website>
		<country>Philippines</country>
		<description></description>
		<accreditation_status>Active</accreditation_status>
		<public_email_address></public_email_address>
		<public_phone_number></public_phone_number>
		<public_fax_number></public_fax_number>
		<key_locations>
			<key_location>
				<key_location_id>A</key_location_id>
				<office_type>Branch</office_type>
				<street>Orange</street>
				<city>New York</city>
				<state></state>
				<country>United States</country>
				<zip_code></zip_code>
			</key_location>
		</key_locations>
		<standard_and_schemes>
			<standard_and_scheme>
				<scope_type>Management System</scope_type>
				<scheme_name>Quality Management Systems Scheme</scheme_name>
				<standard_code>ISO 9001</standard_code>
				<first_issue_date></first_issue_date>
				<issue_date>20230101</issue_date>
				<expiry_date></expiry_date>
				<standard_status></standard_status>
				<key_locations>A</key_locations>
			</standard_and_scheme>
		</standard_and_schemes>
		<technical_sectors>
			<technical_sector>
				<scope_type>Management System</scope_type>
				<scheme_name>Quality Management Systems Scheme</scheme_name>
				<standard_code>ISO 9001</standard_code>
				<sector_title>TickIT Plus</sector_title>
				<sector_code>IAF33</sector_code>
				<sector_accreditation_status>Active</sector_accreditation_status>
				<suspended_withdrawn_date><suspended_withdrawn_date/>
				<full_limited></full_limited>
				<extent_of_scope><extent_of_scope/>
			</technical_sector>
		</technical_sectors>
		<certification_body_countries>
			<certification_body_country>
				<country></country>
				<economy_accreditation_status></economy_accreditation_status>
				<suspended_withdrawn_date><suspended_withdrawn_date/>
				<scheme_name></scheme_name>
				<standard_code></standard_code>
			</certification_body_country>
		</certification_body_countries>
	</certification_body>
</ab_cbs>
```

</details>

**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
   1. **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)
   2. **FTP** [Learn how to import data through FTP​](https://support.iafcertsearch.org/accreditation-bodies/data-management/import-certification/data-import-methods/ftp)
4. Once selected, click the **Continue** button (the system will initiate file and data processing)
5. If all the files and data are valid, the certificate will be successfully added to the existing Certified Entity record.