Load list spreadsheet template
One row is one load: where it picks up, where it delivers, and what it pays. Shippers, brokers, and dispatchers, as a daily or weekly spreadsheet laid out differently by every one of them.
| Field | Type | Rules | Note |
|---|---|---|---|
| Load number | text | RequiredUnique | |
| Pickup city | text | Required | |
| Pickup state | text | Required | |
| Pickup date | date | Required | |
| Delivery city | text | Required | |
| Delivery state | text | Required | |
| Delivery date | date | Required | |
| Equipment | enumDry van · Reefer · Flatbed · Step deck · Power only · Other | Required | |
| Weight (lbs) | number | Optional | |
| Rate (USD) | number | Required | |
| Carrier MC | text | Optional | |
| Notes | text | Optional |
What this sheet refuses to accept
A rate written “$1,850.00” or “1850” arrives as the number 1850, and a rate value reading “TBD” is refused rather than becoming zero.
The same load number twice in one file is caught by the unique rule, so a re-sent list does not book a load twice.
An equipment type outside your list, like “53 dry?”, is refused at the door instead of turning up on a dispatch board.
A weight over 80,000 lbs, or a state that is not two letters, is flagged on its own value before anyone dispatches against it.
Other collections people start from
Sales pipelineOne row is one company you are selling to.CompanytextContact emailemailStageone ofSeatsnumberand 4 morePrice watchOne row is one product page you are watching.Product URLurlProducttextRetailertextPricenumberand 3 moreVendor price listOne row is one product a supplier sells us, at a price.SKUtextProduct nametextUnit pricenumberCurrencyone ofand 4 more