If your roster already lives in a spreadsheet, put the file in rather than retyping it. Columns are detected automatically, and nothing is created until you've seen exactly what will be.
-
Open the import dialog
Contractors → Import at the top right.
-
Pick the spreadsheet option
Choose Contractors — the other option is for a folder of certificates.
CSV and Excel (.xlsx) both work.
-
Upload the file
Drop the file in. Columns are matched by their headers — a column called
Name,CompanyorContractorall land in the right place, and so doEmail,PhoneandLicense Number. -
Review the preview, then import
You get a preview of every row before anything is written. Read it. This is where you catch a header row imported as a contractor called "Name", or a column that landed one across because of an empty cell.
Untick anything you don't want, then click Import Selected.
What the file needs
One contractor per row, and a header row naming the columns. A name column is the only thing that's really required; everything else is a bonus.
| Column | Used for |
|---|---|
| Name / Company / Contractor | The contractor record. Required. |
| Where document requests and reminders go. Worth including — it saves typing it later for every contractor. | |
| Phone | Reference only. |
| License Number | Gives license search something to match on. |
Tip
Careful
What happens next
Your roster is in but empty of documents, so everyone shows as No Documents. Two good next moves: run them through license search, and start requesting certificates.