Upload Trip Data
Instructions:
  1. Download the Excel template using the button below
  2. Fill in your trip, stop, order, and item data in the Trip_Data sheet, following the template structure
  3. All mandatory fields are marked with red headers
  4. Optional fields are marked with blue headers
  5. Each row represents a combination of Trip → Stop → Order → Item
  6. Repeat trip and stop details for each order/item at that stop
  7. If a stop has no orders (e.g., fuel/service stop), leave order and item columns empty
  8. Remove the sample data before uploading
  9. Upload your completed file using the form below
Download Excel Template
Maximum file size: 10MB. Only .xlsx format is supported.
Help & Tips
Template Structure:
  • Trip_Data: All trip, stop, order, and item information (single sheet)
  • Instructions: Detailed guidelines
Data Relationships:
  • LoadId groups all stops for a trip
  • StopSequence determines the order of stops (1, 2, 3, ...)
  • OrderNumber groups all items for an order
  • ItemLineNumber sequences items within an order
Required Formats:
  • Dates: YYYY-MM-DD HH:MM
  • Booleans: TRUE/FALSE
  • Numbers: Decimal format
Examples:
  • Trip with 1 pickup and 2 stops, 1 order each, 2 items per order = 5 rows
  • Trip with 1 pickup stop (no orders) + 1 delivery stop (1 order, 2 items) = 3 rows
  • Service stop with no orders = 1 row with order/item columns empty
Common Issues
  • Ensure all mandatory fields are filled
  • Use correct date format (YYYY-MM-DD HH:MM)
  • Check that LoadId values match for all rows of the same trip
  • Ensure StopSequence is sequential for each trip
  • Verify OrderNumber and ItemLineNumber consistency
  • Remove sample data before upload
  • Save file in .xlsx format only