Which air-cargo file do you have?
General AWBs, scans, HAWBs, MAWBs, manifests, and mixed document packets need different schemas. Choose the matching workflow to keep identifiers, relationships, totals, and exceptions reviewable.
Air cargo workflow finder
Which air-cargo file do you have?
Choose from the file in front of you and the output you need.01A regular AWBStart with airway bill number, route, pieces and weight.02A stamped or image-only AWBUse OCR and keep source-page exceptions visible.03A forwarder-issued house billPreserve the house shipment and its master reference.04A carrier-level master billCapture carrier, flight, consolidated weight and charges.05A flight manifest with many AWBsSeparate the flight header from one row per airway bill.06A mixed air-freight packetClassify documents before linking fields across them.
What makes this document hard
These are the real formatting and workflow issues teams usually run into.
01
The same AWB Excel search can mean a blank form, an operations ledger, or extracted PDF data. One visual copy of a carrier form does not solve all three jobs.
02
Carrier and forwarder layouts move AWB numbers, parties, routing, flight, weight, and charge fields, so generic PDF tables often shift values into the wrong columns.
03
AWB, MAWB, HAWB, and manifests represent different document levels, while rating details can repeat across rows. Flattening them without review makes reconciliation and import harder.
How FOVATA handles it
The goal is not just conversion. The goal is structured output your team can use immediately.
Download an editable workbook with one-row-per-AWB ledger fields, repeating rating lines, and a field guide with source and review notes.
Extract identifiers, parties, airports, flights, pieces, weights, rates, and charges by business field instead of copying the page layout.
Keep source file, page, and review status columns, then map the result to a confirmed TMS or ERP import specification.
Use the dedicated HAWB, MAWB, and air cargo manifest pages when the document level or master-house relationship needs its own workflow.
AI Smart Extraction
Best when the source layout is inconsistent and the target output needs to follow business logic.
Excel-ready output
The point is not to mirror the source page. It is to create an output file that saves follow-up work.
Scenario walkthrough visuals
These visuals use synthetic examples to show the source document, extraction setup and output structure.
Fields teams usually extract
AWB / MAWB / HAWB No.Execution DateShipperConsigneeIssuing CarrierAgent / IATA CodeOriginDestinationRouting / ViaFlight No. / DatePiecesGross WeightChargeable WeightNature of GoodsCurrencyPrepaid / CollectWeight ChargeOther ChargesSource File / PageReview Status
Teams that benefit most
Air export operations
Air import operations
Freight documentation teams
Logistics data-entry teams
TMS and ERP import owners
Recommended workflow
A practical three-step path from source file to usable Excel output.
1
Upload the air waybill PDF, scan, or image and confirm the document type and readability.
2
Define identifiers, parties, routing, pieces, weights, charges, and source-page fields; keep repeating charges on separate rows.
3
Review critical numbers, dates, weights, charges, and document level before adapting the workbook to a confirmed TMS or ERP import format.
FAQ
Should I use a blank template, an operations ledger, or PDF extraction?
It commonly describes three jobs: a downloadable Excel template, a one-row-per-shipment operations ledger, or structured data extracted from PDFs and scans. The workbook covers the first two; the extraction workflow handles the third.
Is this an official IATA air waybill?
No. It is an operational workbook for data entry, review, and mapping. It does not issue, validate, sign, or replace an IATA or carrier air waybill or a contract of carriage.
Can AWB, MAWB, HAWB, and air cargo manifests use the same template?
The ledger can label AWB, MAWB, and HAWB rows, but extraction should respect document level. MAWB focuses on carrier routing and totals, HAWB on the house shipment and linked master, and a manifest on multiple consignments for a flight.
Can the workbook import directly into CargoWise or another TMS?
It can be a mapping and CSV or XLSX preparation layer, but required columns, codes, and allowed values vary by system, tenant, and workflow. Confirm the destination import specification before renaming or reordering fields. This page does not claim a direct integration.
Is this an airway bill generator in Excel?
No. The workbook helps prepare and organize values, but it does not assign a valid carrier AWB number, validate a transport contract, issue a document, or submit data to an airline.
Use this page as your first test scenario
Start with the free AWB format in Excel to agree on the columns your team needs, then test a small batch from one carrier or forwarder before reusing the extraction setup.