Paste carton details from Excel, turn them into an editable table, and calculate air freight and express chargeable weight instantly
Accepts Excel cells, comma- or space-separated values, English or Chinese headers, combined dimensions such as 60×50×40, and lines like "8ctns 65*58*32". Parsing starts automatically when you paste.
Without headers: ① Pieces L W H Weight; ② L W H Weight (one piece); ③ Pieces L×W×H Weight; ④ 8ctns 65*58*32 (weight can be omitted and filled in the table later).
Express only — the rules below never affect air freight chargeable weight
Two different rules: air freight compares total actual weight against total volumetric weight for the whole shipment. Express carriers compare each piece separately, round each piece up, then add them together — matching DHL / FedEx / UPS invoices. Cargo type, the oversize threshold, the carton overweight threshold and the pallet minimum chargeable weight are express-only rules: they affect express chargeable weight and surcharge notes, and never change air freight chargeable weight. Loose cartons are flagged when per-piece actual weight reaches the threshold; palletised cargo has a carrier minimum chargeable weight (default 68 kg per pallet), so anything below 68 kg is billed at 68 kg — this is normal rating, not an overweight surcharge. Divisors can be edited to match your service rules (commonly 6000 for air, 5000 for express).
Edit any number in the table and results update instantly. Dimensions are in cm and weight in kg.
| # | Total pieces | L (cm) | W (cm) | H (cm) | kg | Total actual weight | Air Freight · Volumetric weight | International Express · Volumetric weight |
|---|
Volumetric weight = L × W × H × pieces ÷ air divisor
Air freight always uses the whole-shipment rule and is not affected by cargo type, oversize/overweight thresholds or the minimum chargeable weight.
Volumetric weight = L × W × H × pieces ÷ express divisor
Results are an estimate of chargeable weight only. Air freight always uses the whole-shipment rule (greater of total actual and total volumetric weight) and is never affected by cargo type, oversize/overweight thresholds or the pallet minimum. Cargo type, the 24 kg carton overweight check (per-piece actual weight), the 68 kg/piece pallet minimum and the 120 cm oversize note apply to international express only. Fuel, remote-area and other surcharges are not included. Final billing is subject to carrier measurement, service rules and invoice. Your data is processed locally in your browser and is not uploaded.