Upload File Format (Excel / CSV)
Your upload file may contain additional optional fields to help TrackRoad optimize routing,
dispatching, and delivery scheduling. Headers are optional — column order matters.
Optional Fields (Column Map)🔗
You may include the following optional fields in your file. Each field corresponds to a
column position (A, B, C …).
Important: Please make sure the file does not include additional non-supported columns or unrelated text.
Only valid & geocoded records will be imported.
Supported Optional Fields🔗
- Name - A (unique identifier)
- Street - B
- City - C
- State - D
- Zip - E
- Country - F
- Vehicle - G
- Weight (integer) - H
- Waiting Time (integer) - I
- Boxes (Qty) (integer) - J
- Volume (integer) - K
- Comment (max 1024 chars) - L
- Arrival Time After (military time) - M
- Arrival Time Before (military time) - N (requires M)
- Charge (double) - O
- Phone - P
- CanArriveEarly (0=No, 1=Yes) - Q
- Longitude (decimal) - R
- Latitude (decimal) - S
- ControlNo (max 32 chars) - T
- Arrival Time2 After - U (requires M & N)
- Arrival Time2 Before - V (requires M, N, U)
- SmsOnStatusChange (0=No, 1=Yes) - W
Notes & Requirements🔗
Headers are optional. TrackRoad imports data by column position (A, B, C, etc.).
Please ensure your file contains only supported columns. If the file includes extra columns or
unrelated text, import may fail.
Only geocoded records will be imported.
Are headers required?
No. Headers are optional. TrackRoad reads fields based on column position.
Can I upload Latitude/Longitude instead of an address?
Yes. Longitude and Latitude may be provided when address fields are not present.
Records must still be valid and geocoded.
What happens if my file contains extra fields?
Extra fields or non-supported information may cause import issues.
Keep the file limited to supported columns only.