Skip to main content

Importing Subcontractors & Vendors from a CSV (with Trades)

How to bulk-upload your subcontractor and vendor list from a CSV, add a Trade column so each sub's trade saves automatically, and how multiple trades in one cell are handled.

Overview

Instead of adding subs one at a time, upload a CSV and KonstructIQ creates every Subcontractor/Vendor in one pass. Add a Trade column and each vendor's trade is saved too, so you can see it in the Trades column on your list.

Where to find it: People → Subcontractors → Upload.


Step 1: Prepare your CSV

Start from the sub_vendors.csv template in the Upload window. It has 12 columns, in this order:

  • Business Name (required) — the only required column.

  • Primary Contact Name, Primary Email, Additional Email

  • Mobile Phone, Additional Phone

  • Address, Address 2, City, State, Zip

  • Notes

To import trades, add a 13th column at the end and name the header Trade. If your template already has a Trade column, you're set.

Here is a complete example you can copy into a file and save as a .csv:

Business Name (required),Primary Contact Name,Primary Email,Additional Email,Mobile Phone,Additional Phone,Address,Address 2,City,State,Zip,Notes,Trade

ABC Plumbing,Pat Reed,[email protected],,5550100101,,100 Main St,,Austin,TX,78701,Prefers email,Plumbing

Delta Electric,Dana Lee,[email protected],,5550100102,,200 Oak Ave,,Austin,TX,78702,,Electrical

Summit Mechanical,Sam Cruz,[email protected],,5550100103,,300 Pine Rd,,Austin,TX,78703,,"Plumbing, HVAC"

Tip: keep one value in each cell — one email, one phone number. Leave a cell empty if you don't have the information.


Step 2: Upload the file

  1. Click People → Subcontractors.

  2. Click Upload at the top of the list.

  3. Drag your CSV onto Drag & drop a file to import, or click Choose from Files or Add from Device and pick the file.

  4. Wait for the message Successfully uploaded followed by the number of subcontractors.

Limits: the upload window accepts CSV files only.


Step 3: Check your vendors and their Trades

Reload the Subcontractors/Vendors list. Each imported vendor appears with its trade as a tag in the Trades column. Open a vendor to see the same tags in the Trades field on the vendor's edit page.

A vendor with an empty Trade cell is still imported — it just has no trade tag.


How multiple trades in one cell work

A vendor can have more than one trade. Put them in the same Trade cell, separated by a comma or a semicolon:

  • Comma: "Plumbing, HVAC" — put the cell in quotation marks so the comma isn't read as a new column. This saves two tags: Plumbing and HVAC.

  • Semicolon: Plumbing;HVAC — also saves two tags: Plumbing and HVAC.

  • Anything else: a pipe, as in Plumbing|HVAC, is not a separator. It saves as one tag named Plumbing|HVAC.


Troubleshooting & FAQs

  • Trades are empty after the import. Check that the column header is exactly Trade, and that the file you uploaded is the one with that column.

  • A vendor has one odd-looking trade like "Plumbing|HVAC". Only commas and semicolons separate trades. Use a comma (in quotation marks) or a semicolon in your file for future imports, and check the vendor's Trades field for the tag already saved.

  • Is the Trade column required? No. Only Business Name (required) is required.

  • Can one vendor have several trades? Yes. Separate them with a comma or a semicolon in the same cell.

  • Do I still have to paste the trade into Notes? No. The trade is saved as a tag in Trades, so Notes can hold other information.


Quick Reference

Path: Home → People → Subcontractors → Upload → drop in your CSV → check the Trades column.

Columns: the 12 template columns plus a final Trade column. Only Business Name (required) is required.

Multiple trades: separate with a comma (cell in quotation marks) or a semicolon.

Did this answer your question?