FTA Product Records - Spreadsheet Upload for Qualifying Records
Spreadsheet upload for qualifying records allows you to mass create such records that may solicited/analyzed outside of the system. When accessing Product Records, you have the ability to download a template to use.

Clicking the link with start the download of the following Excel file.
The template (ProductRecordsTemplate.xlsx) color-codes its DataSheet and Sample columns: required columns (CertType, ProductNum, Supplier, CertificateStartDate, CertificateEndDate) are shown in red, and optional columns (NetCost, Producer, PreferenceCriterion, CountryOfOrigin, Qualifying (Y/N)) are shown in gold. The template also includes an “Instructions (EN)” tab defining each column, whether it is required, its maximum length, and a sample value; a “Sample” tab showing a fully filled-out example row; and a “Country Code” tab listing the valid country codes for the CountryOfOrigin column. All 10 columns must be present in the DataSheet for the upload to process, and a blank Qualifying (Y/N) value defaults to No.

After you have successfully completed the spreadsheet, you can click the “Upload Spreadsheet” link.

The following modal will appear that allows you to browse for the completed Excel file.

After you have located the file, a message will appear and you can apply the data.


Click the 'X' icon and the modal closes.
