Data and improvement

CSV delivery import: preparing mission files for route planning

Learn how delivery teams should prepare CSV, XLSX, or JSON mission imports for cleaner route planning, dispatch, and reporting.

Import quality controls route quality. Clean mission files reduce dispatch delays and make optimization more reliable.

Primary keyword: CSV delivery import

Checklist

1

One mission per row or object.

One mission per row or object.

2

Consistent date, time, and timezone assumptions.

Consistent date, time, and timezone assumptions.

3

Complete address or coordinates.

Complete address or coordinates.

4

Valid phone numbers and customer fields.

Valid phone numbers and customer fields.

5

Clear pickup and delivery fields for pickup-delivery jobs.

Clear pickup and delivery fields for pickup-delivery jobs.

6

No sensitive data unless necessary.

No sensitive data unless necessary.

Guide sections

Recommended delivery import fields

Customer or recipient name, phone, address, latitude/longitude where available, date, time window, service duration, demand, priority, and notes. For pickup-delivery work, include pickup address, pickup time window, pickup duration, delivery address, delivery time window, and delivery duration.

CSV vs XLSX vs JSON

CSV works well for simple spreadsheet exports. XLSX helps spreadsheet users who already manage workbooks. JSON is useful for structured operational exports from another system.

Review before routing

Check incomplete rows, wrong branch/date context, missing coordinates, invalid time windows, and fields that do not match vehicle skills or capacity.

Related pages

Guides FAQ

Does Rouptimize support only CSV import?

No. Rouptimize guide copy should mention CSV, XLSX, and JSON mission import.

Does importing missions use scheduled order credits?

Importing mission data prepares work for planning. Credits are used when missions or orders are newly scheduled onto routes.

Ready to optimize delivery operations?

Start with the current Rouptimize workflow and bring your dispatch, drivers, proof, and reporting into one operating system.