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.

Updated Open this in Tezify
  1. Open Loads (Load Tracking) and choose Import.
  2. Pick a CSV or Excel file. The first 1,000 rows are used.
  3. Check how the columns were matched. Columns Tezify does not know are flagged and ignored.
  4. Run the import.
  5. 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.

Open this in Tezify

Still stuck?

Inside Tezify, press the ? at the top of any page to file a ticket with that page attached. Not a customer yet? Ask us anything.