Shipper load sheet email best practices for broker desks
How shippers can send daily load sheets that brokers post faster and cover sooner, from columns and dates to re-sends and cancellations, and how broker desks can import whatever arrives.
The load sheets that get covered fastest are consistent. They use one sheet or list per ship date, the same columns every day (pickup city and state, destination, ship date, equipment, weight, commodity, rate), one row per truck, and a clear way to show changes and cancellations. Brokers using SmartLoads can import any consistent format automatically, including email text, Excel, PDFs and Google Sheets, so shippers don't have to change tools, just stay consistent.
Broker desks lose hours when every shipper sends loads in a different shape: an Excel sheet with merged cells, a PDF table, a list typed into the body of an email. The format itself matters less than one thing: doing it the same way every day. Consistency is what lets a broker's software read the sheet automatically and post the loads within minutes.
What a good load sheet includes
One row per truck, with these columns in the same order every day:
| Column | Why it matters |
|---|---|
| Pickup city and state | Carriers search by origin; misspelled cities slow posting |
| Destination city and state | Needed for mileage and rate checks |
| Ship date | Separates today's loads from tomorrow's |
| Equipment | Flatbed, van, reefer, step deck; plus tarps if needed |
| Weight and commodity | Carriers need both to accept a load |
| Rate | Flat or per ton, stated the same way every time |
| Notes | Pickup hours, appointment, closures |
If several trucks run the same lane, either list one row per truck or put the count at the start of the line ("5 - Opa Locka, FL - Jackson, TN"). Pick one convention and keep it.
Sending and re-sending
- One sheet or list per ship date. Mixing days in one file is the most common cause of loads posted for the wrong day.
- Re-send the whole list when something changes. A broker's import can tell what's new, what changed and what disappeared. Partial updates ("also add this one") are easy to miss.
- Remove cancelled loads from the list rather than striking them through. A missing row is unambiguous.
- Say it in the notes when a plant is closed, for example "CLOSED FRI", so loads aren't offered for a day nobody can load.
- Use a named distribution list for broker contacts, so the right desk always gets the sheet.
Formats that work well
Any of these work if they're consistent: an Excel attachment with a header row, a Google Sheet shared with the broker, or a plain-text list in the email body. PDFs are fine too, but a PDF exported from a spreadsheet reads more reliably than a scan.
What broker desks can do on their side
A broker shouldn't have to ask every shipper to change tools. SmartLoads reads each shipper's existing format with a reader built for it, including scanned PDFs, and turns every load into the same clean record on one live board. Re-sent sheets update loads instead of duplicating them. At one agency, 16 shipper feeds in five formats flow in automatically. Here's how that pipeline works.
Frequently asked questions
What's the best file format for a load sheet?
The one you can send the same way every day. An Excel sheet with a fixed header row, or a shared Google Sheet, is easiest for brokers to automate.
Should shippers include rates on the sheet?
If the rate is set, yes, and state whether it's flat or per ton the same way on every row. It lets brokers post immediately instead of calling to confirm.