Excel General Rules
Last updated
Last updated
Copyright © 2023 IAF CertSearch. All Right Reserved
Keep data format consistent
Format data into the provided IAF CertSearch template
Enter single data value entry per cell
Do not upload other formats supported in Excel, such as .xls, .xlsm, .xlsb, .xlr
Do not delete any columns from the template. If deleted, the system will throw a missing field error.
Do not skip field mapping. If skipped, data is not processed and imported.
Do not merge columns. If merged, the system throws a data field error.
Do not leave the required fields empty
Do not format data values as formulas.
To minimize import interruptions, it is recommended not to update/delete/change any of the field names and structure.
Remove any unnecessary or redundant columns that won't be used in the analysis.
Check for missing or incomplete data and decide how to handle it (e.g., filling in missing values, removing rows, etc.).
Validate data entries to ensure they meet required standards (e.g., valid dates, numeric values, etc.).\
Remove Duplicates. Eliminate duplicate rows or entries to prevent redundancy and inaccuracies in analysis.
Make sure data types for each column match the requirements of IAF CertSearch. For example, data values should be in the text format.
Thoroughly understanding the IAF CertSearch requirements and the characteristics of your data will help ensure a successful data import process.
File Format
File format should be .xlsx only
Column Header Names
Keep the column names the same as the template.
If changed, the system requires field mapping to recognise the data.
Column Sequence
Keep the order of the columns the same as in the template.
If changed, the data processing may be disrupted and cause data errors.
Sheet Tab Sequence
Keep the order of the sheet tabs the same as in the template.
If changed, the data processing may be disrupted and cause data errors.
The maximum record limit for the certification sheet of the Excel file is 10,000. If the certification sheet in your Excel file has more than 10,000 records, then you need to upload multiple files that are only limited to up to 10,000 records per file.
The maximum file size for Excel files is 50MB. If your Excel file is greater than 50MB then you need to upload multiple files that are all less than 50MB.
IAF CertSearch recommends you name your files as per below:
Single: cb_certs.xlsx
Multiple files: cb_certs_1.xlsx, cb_certs_2.xlsx, cb_certs_3.xlsx