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 cell 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 cell before anyone dispatches against it.