Excel General Rules

General Rules

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.

Record limit

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.

File size

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.

File name(s)

IAF CertSearch recommends you name your files as per below:

Single: ab_certs.xlsx

Multiple files: ab_certs_1.xlsx, ab_certs_2.xlsx, ab_certs_3.xlsx

DOs

  1. Keep data format consistent

  2. Format data into the provided IAF CertSearch template

  3. Enter single data value entry per cell

DONTs

  1. Do not upload other formats supported in Excel, such as .xls, .xlsm, .xlsb, .xlr

  2. Do not delete any columns from the template. If deleted, the system will throw a missing field error.

  3. Do not skip field mapping. If skipped, data is not processed and imported.

  4. Do not merge columns. If merged, the system throws a data field error.

  5. Do not leave the required fields empty

  6. Do not format data values as formulas.

Tips

  • 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.

Last updated

Copyright © 2023 IAF CertSearch. All Right Reserved