Skip to content
  • There are no suggestions because the search field is empty.

How to Import Vendors in Bulk (Article)

Upload one spreadsheet to create multiple pre-registration vendor profiles and send each vendor a registration email.

 Before You Begin

  • Confirm you have the Allowed to add a new vendor permission. If you don’t see the Import option, ask your agency administrator to confirm your permissions.
  • Save your spreadsheet as an .xls, .xlsx, or .csv file.
  • Enter one vendor per row, and include every required column listed below.

 

Required Columns

Optional Columns

Company Name

Principal Owner/CEO

FEI/SSN

Doing Business As

Phone

Contact Name

Address

EXT

Email

Fax

City

Address 2

Zip

State

 

Country

 

Commodity categories: Leave commodity categories out of your file. Vendors choose their categories when they claim their profile and finish registering.

Duplicate vendors: The import compares each email to existing vendors using an exact match and skips any row whose email already exists. PlanetBids treats different spellings of an address, such as jane@acme.com and jane.doe@acme.com, as different vendors.

 

 Import Vendor Records

Go to the Vendors page:

Click Import:

Import Vendors by dragging and dropping your file (.xls, .xlsx, or .csv ):

Once you have loaded your spreadsheet, click Finish. To close the window without importing, click Cancel:

Review the import summary for total rows processed, profiles created, and rows with errors:

PlanetBids creates a pre-registration profile for each valid row and sends each vendor the same registration email as a vendor you create by hand. If the summary lists any rows with errors, follow the steps below.

Fix Rows That Didn’t Import

The import saves every valid row and skips any row with a problem. It never partly saves a row. The error file uses the same layout as your upload and lists the reason each row failed.

Click the error file download in the import summary:

If every row imported, a success message displays instead.

Read the reason listed for each row in the error file:

Correct the data in the error file, then save it.

Upload the corrected error file by repeating the import steps above.

Note: Upload only the corrected error file. If you re-upload your original file, Agency Hub processes the rows that already imported again.

Reason

How to Fix It

Missing required field

Fill in the field named in the error.

Email already exists

The vendor already exists in Agency Hub. Remove the row.

Protect Vendor Data

Vendor spreadsheets and error files can contain FEI/SSN numbers, phone numbers, emails, and addresses. Upload files directly in PlanetBids, and avoid sending them by email. Store and delete error files the same way you handle the original file.

Vendor Import Template