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
Click People → Subcontractors.
Click Upload at the top of the list.
Drag your CSV onto Drag & drop a file to import, or click Choose from Files or Add from Device and pick the file.
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.


