Review import

sample_workbook.xlsx

on_dock_2026825 · header row 1 · 54 shipment rows detected
Rows detected
54
54 pass validation
Warnings
4
Defaulted or estimated values
Errors
0
Rows that cannot be routed
Import status
committed
Imported Nov 12, 13:58

Sample rows

First 15 rows after normalization
0 errors
RowPOCustomerAddressCartonsServiceStatus
2 CS673560745 Kurt Selbach
Delivery
305 Johnsville Rd # 4PO box 1133
Blairsden Graeagle, CA 96103
2 Full Service Delivery + Assembly ok
3 CS670609843 Stephen Sear
Pickup
7480 Brothers Lane
Carson City, NV 89704-8501
2 Full Service Delivery + Assembly ok
4 CS670070064 Monica Brombacher
Delivery
1570 South Deer Run Road
Carson City, NV 89701-9326
2 Outside Front Door Drop-Off ok
5 CS675438425 Mountain River
Delivery
2193 Shadow Brook Ct
Carson City, NV 89703
1 Outside Front Door Drop-Off ok
6 CS674417505 Alyson Sharp
Delivery
105 Bronc Court
Dayton, NV 89403-4400
6 Full Service Delivery + Assembly warning
Missing or zero weight; estimated at 100 lb per carton
7 CS673644737 John Quinlen
Delivery
542 Village Dr
Fernley, NV 89408
1 Outside Front Door Drop-Off ok
8 CS673177436 Kelty White
Delivery
12951 Ridge Rd
Grass Valley, CA 95945-4927
2 Inside Home Entrance Drop-Off ok
9 CS669597209 Chuck Meyer
Pickup
143 Village Boulevard9
Incline Village, NV 89451
1 Inside Home Entrance Drop-Off ok
10 CS672301686 Chuck Meyer
Pickup
143 Village Boulevard9
Incline Village, NV 89451
1 Inside Home Entrance Drop-Off ok
11 CS668839578 Jan Hughes
Pickup
811 Southwood Blvd14
Incline Village, NV 89451
2 Inside Home Entrance Drop-Off ok
12 CS675081966 Angela Roberts
Delivery
932 Lakeshore Blvd
Incline Village, NV 89451
1 Inside Home Entrance Drop-Off ok
13 CS673581303 Emilie Arnoldi
Delivery
710 Birdie Way
Incline Village, NV 89451
3 Inside Home Entrance Drop-Off ok
14 CS673674382 Makaela Shively
Delivery
708-105 Pine Street
Janesville, CA 96114-9641
1 Inside Home Entrance Drop-Off ok
15 CS675018623 Suzanne Colonna
Delivery
1616 Shirley St
Minden, NV 89423-8031
1 Full Service Delivery + Assembly ok
16 CS673439779 Monroe King
Delivery
421 Broad Street
Nevada City, CA 95959-2407
1 Inside Home Entrance Drop-Off ok

Detected mapping

PO → PO / Order ID Shipment Type → Shipment type Customer Name → Customer name Customer Address → Address City → City State → State Zip → ZIP Phone# → Phone Carton Count → Carton count Carton Weight → Weight (lb) Miles → Hub miles Service Type → Service type Received Date → Received date

What happens next

  1. Shipments are normalized and grouped by street address.
  2. US Census geocoding runs first; Nominatim and ZIP centroid are fallbacks.
  3. Failed pins can be corrected manually on the shipment page.
  4. Rows with errors stay in the system for correction but are excluded from routes.
Working on it… This can take a few seconds.