Carrier and trucking TMS · Loads
How to import loads from a CSV or Excel file
On Load Tracking, use Import and upload a CSV or Excel file. Map the columns, run it, and read which rows went in and which failed.
- Open Loads (Load Tracking) and choose Import.
- Pick a CSV or Excel file. The first 1,000 rows are used.
- Check how the columns were matched. Columns Tezify does not know are flagged and ignored.
- Run the import.
- Read the result. Each failed row says why, such as a duplicate order number or a delivery before pickup.
Columns you can import
Load number, status, shipper, consignee, origin, destination, pickup and delivery times, driver, driver code, truck, trailer, commodity, weight, miles, invoice amount, rate, driver pay, PO number, order number, notes, reefer temperature, posted rate and fuel surcharge. The import reads the same columns the Export CSV writes.
History rows
Rows with a status of Delivered, Billed, Cancelled or TONU come in as records only. Drivers are not texted and today's compliance block does not apply. A row marked Dispatched with a driver does notify that driver.
Common questions
Do origin and destination create stops?
Yes. A pickup and a delivery stop are created from them.
Ready to do it? This lives at /admin/loads in Tezify.
Related articles
- Carrier and trucking TMSHow to create a load in Tezify
- Carrier and trucking TMSHow to import your drivers, trucks and customers
- Carrier and trucking TMSHow to find, filter and edit loads on Load Tracking
- Carrier and trucking TMSRate confirmation to load: upload a broker rate con
- Carrier and trucking TMSHow to add stops and appointments to a load
- Carrier and trucking TMSHow to repeat a load or save it as a template