Skip to content
Open workspace
Home/Customs Declaration PDF to Excel
Trade / Customs / Documentation

Customs Declaration PDF to Excel

The hard part of customs forms is not reading text. It is turning dense, multi-line declaration bodies into clean Excel rows that can be used for ledgers, reconciliation, and filing.

Multi-line row splitField-directed extractionLedger-ready outputScanned PDFs supported

What makes this document hard

These are the real formatting and workflow issues teams usually run into.

01

A single line item often contains unit price, total amount, and currency packed into stacked rows inside the same visual cell.

02

The column order your team needs for reporting is usually different from the order shown in the source document.

03

Manual retyping slows down customs, trade, and finance teams and increases the risk of amount and currency errors.

How FOVATA handles it

The goal is not just conversion. The goal is structured output your team can use immediately.

Tell FOVATA which fields you need and how you want them arranged in the output file.

Multi-line declaration bodies can be expanded into separate Excel columns instead of staying trapped inside one cell.

Reusable templates help teams process recurring declaration layouts faster.

The exported sheet can be shaped for real operational use instead of mirroring the source layout.

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.

Source
Redrawn customs document
Source structure
Customs Form
IMPORT CUSTOMS DECLARATION
Item
HS Code
Product & Spec.
Qty
Unit
Amount
Curr.
Origin
Dest.
CUSTOMS
Complex bodyMulti-line cellsStamped scan
Setup
Field setup and guidance
Extraction setup
AI Extraction
FOVATA workflow preview
Live
Pages parsed
1 / 1
Field count
12
Multi-value
4
Upload declaration file
PDF, images, and scans
customs-declaration.jpg269.96 KB
Scans supportedKeep source meaningLedger ready
Field setup
Structured mode
Consignee code
Text · Single value
Item No.
Number · Multi-value
Product name
Text · Multi-value
Specification
Text · Multi-value
Take the second line inside "Product & Spec."
Result
Ledger-ready Excel result
Structured output
Declaration ledger is ready
Split fields are arranged for immediate export
Ready to export
Sheets
2
Item rows
6
Exceptions
0
HEADER SHEET
Header fields arranged for reporting
Consignee
Transport
Packages
Gross Wt
Net Wt
Terms
91330326MABYJK313X
Sea freight
60000
1871.24
1842.00
CIF
ITEM SHEET
Multi-line body split into reviewable rows
Item
HS Code
Product
Spec.
Qty
Amount
1
3307300000
Bath salt
Brand: Meiyousen
520.00
HKD 280,000
2
3402509000
Laundry pods
Spec: 272g
272.00
HKD 40,000

Fields teams usually extract

Declaration No.Item No.Product NameProduct CodeQty / UnitUnit PriceTotal AmountCurrencyDeclaration NotesRemarks

Teams that benefit most

Trade documentation teams
Customs operators
Logistics operations
Finance reconciliation staff
Back-office ledger teams

Recommended workflow

A practical three-step path from source file to usable Excel output.

1

Upload the customs declaration PDF, scan, or image and choose AI extraction.

2

Describe the fields you need and any formatting or splitting rules.

3

Export a structured Excel file ready for ledgers, review, and filing.

FAQ

Can it split multi-line values inside a single declaration row?

Yes. That is one of the main reasons to use AI extraction for customs declarations instead of generic table conversion.

Can we reuse the same setup for recurring layouts?

Yes. Once you define the fields and output structure, you can save a template and reuse it for similar declarations.

Will scanned customs forms work?

Yes. As long as the scan is readable, the system can recognize the content and export it to Excel.

Use this page as your first test scenario

If your team still splits customs declaration cells by hand, this is one of the highest-value scenarios to test first.