Upload Customer Data File
CSV or Excel (.xlsx) — TMS exports, freight invoices, carrier reports
Drop file here or click to browse
Supported: .csv, .xlsx, .xls
ℹ
The tool reads column headers only — your data is processed locally in the browser and never uploaded anywhere.
ScaleBridge Required Fields
Fields your data must cover for best analysis results in both tools.
Critical Required
ship_date
carrier_name
total_charges
origin_state
dest_state
Important High Value
weight_lbs
origin_zip
dest_zip
mode
base_rate
fuel_surcharge
Useful Optional
shipment_id
delivery_date
equipment_type
freight_class
distance_miles
carrier_scac
on_time
business_unit
--
Select a source column, then click a ScaleBridge field to map it.
0 mapped
0 auto
0 unmapped
Active Sheet:
Join Key:
📄 YOUR FILE COLUMNS
🎯 SCALEBRIDGE FIELDS
★ required ◆ important
ℹ
Switch between sheet tabs to map columns from different sheets. Set a Join Key (e.g. PRO#) that appears in each sheet — this is used to merge them into one CSV on export.
ℹ
These assumptions fill gaps in your data. They're applied during analysis — not written back to your file. Adjust any that don't fit your customer's data.
Customer Profile
Customer Name
Who is this data for?
Analysis Period
Date range covered
Missing Field Defaults
Default Mode
When mode column is missing or blank
Default Equipment Type
When equipment field is missing or blank
Default Country
When origin/dest country is missing
Fuel Surcharge Treatment
When FSC column is absent
Freight Direction
Primary Direction
Default shipment direction when origin/dest names unclear
Bundled Fuel Carriers
Carriers in this data that bundle fuel into line haul
Quality & Filtering
Exclude Zero-Charge Records
Remove rows where total_charges = $0
Flag and exclude $0 charge records
Carrier Alias Resolution
Consolidate carrier name variations
Auto-normalize carrier names (e.g. "XPO Logistics Inc" → "XPO Logistics")
Date Header Row
If your file's header isn't on row 1
Leave as 0 for auto-detection. Enter 1-5 if headers are on a specific row.
Notes
Any data caveats for this customer
ZIP Code Enrichment
Auto-fill Missing ZIPs
Fill origin_zip and dest_zip from city + state when ZIP is blank
Uses a built-in lookup of 600+ US cities. Requires origin_city + origin_state (or dest_city + dest_state) to be mapped in Step 2.
Fills ZIP data in-memory before export — your original file is unchanged
Mapping Summary
—
Quality Score Estimate
—
Missing Critical Fields
—
Assumptions Applied
—
Generated Python Snippet
Copy this into your ScaleBridge ingestion pipeline or run it directly on the server to test the mapping.
—
Export
Export your merged, canonical data file for uploading directly to ScaleBridge tools — or download the mapping config for the ingestion engine.
📦 Export Data File (for uploading to ScaleBridge tools)
XLSX includes a Column Mapping tab and Assumptions tab alongside the data. CSV is UTF-8 with BOM for Excel compatibility.
🔧 Mapping Configuration