In the KCM GRC Vendor Risk Management module, you can add vendor details to create "vendor profiles" for each vendor or third-party organization that your organization works with. You also have the option to use a CSV file to import multiple vendor profiles at once. After creating vendor profiles, you can assess your vendors by sending them questionnaires. For more information about creating vendor profiles, see our How to Create and Manage Vendor Profiles article.
The sections below contain the requirements and instructions for using a CSV file to import vendors into your account.
Jump to:How to Format a Vendor CSV FileHow to Import VendorsHow to Complete Vendor Setup
How to Format a Vendor CSV File
Before you import vendors to your KCM GRC platform, you need to create a spreadsheet that contains information about each vendor. There is no limit to the number of vendors that you can import with a spreadsheet.
When you create your spreadsheet, please follow the formatting guidelines below.
- Use the header line below, and remove any optional headers that you do not want to include.
name,primary_contact_name,primary_contact_email,mail_address,city,state,postal_code,country,phone,status
Important:Headers must follow the exact format as the header line above. Headers are case-sensitive and must include the underscore when applicable. The name, primary_contact_name, and primary_contact_email headers are required. The mail_address, city, state, postal_code, country, phone, and status headers are optional. - Follow the guidelines in the table below when you enter information into each field.
Note:We recommend that you avoid including the < and > special characters in your spreadsheet. When you import the CSV file into your platform, these special characters can cause fields to import unsuccessfully.
- Save the spreadsheet as a CSV file.
Important: If you are using Microsoft Excel, you must save the file in the "CSV UTF-8 (Comma delimited)" format.
How to Import Vendors
After you save your CSV file, follow the steps below to import vendors to your KCM GRC platform.
- Navigate to Vendor Management > Vendors from the navigation panel.
- Click the Import Vendor CSV button in the top-right corner.
- Click the Click to Upload button in the top-left corner of the Import Vendors CSV window.
- Select the CSV file that contains your vendor information.
- Click Save Imported Vendors.
How to Complete Vendor Setup
After you import vendors to your account, follow the steps below to finish creating their vendor profiles. You must complete these steps before you can send questionnaire assessments to vendors.
- Navigate to Vendor Management > Vendors from the navigation panel.
- Click the name of a vendor under the Name column.
- Click the Update button in the top-right corner.
- Under Organization Details, change the Vendor Status from Incomplete to either Pending Approval or Active.
- (Optional) Under Organization Details, select an Organization Industry.
- (Optional) Under Qualifying Questions, answer the questions. See the Qualifying Questions section of our How to Create and Manage Vendor Profiles article for more information.
- Under the Contacts tab, add a user account for the vendor contact. We recommend that you read the Adding User Accounts for Vendor Contacts section of our How to Create and Manage Vendor Profiles article before you complete this step.