Extract Excel97 Shipping Document to Fixed Width

Extract line items from Excel97 bills of lading, packing slips, and delivery notes into Fixed Width. Get SKUs, quantities, weights, and freight classes as clean rows.

Drop your Excel 97-2003 (.xls) file here (or click to browse).
(50 MB or less file)
0%
Uploading...
Loading...
Sign-up to upload larger files

Turn bills of lading, packing slips, and delivery notes into structured Fixed Width data

Upload packing slips, bills of lading, or delivery notes as a Excel97 file. Extract line items with original headers into structured rows for fast reconciliation.

3 document types1 row per line item0 manual entries
NORTHWIND OUTFITTERS1420 Commerce Way, Reno NV 89502
PACKING SLIP
Order #SO-20931
Ship date09/24/2026
Customer POPO-4471
CarrierSierra Freightways
PRO #448-201977
BOL #BOL-77310428
SHIP TOHarbor Supply Co.
Receiving Dock 3, Oakland CA
BILL TOHarbor Supply Co.
Accounts Payable
Line items: extracted as rows
LineSKUDescriptionOrderedShippedBackorderedUOM
1TNT-2P-GRNTrailhead 2-Person Tent, Green12120EA
2SB-20F-REGSummit Sleeping Bag 20F, Regular24186EA
3HL-300Ridge Headlamp 300 lm48480EA
4WB-1L-BLUInsulated Water Bottle 1L, Blue36306EA
5CS-4PKCamp Stove Fuel Canister, 4-pack10100CS
6TP-8X10Ultralight Tarp 8x10 ft15015EA
Total units ordered: 145 · Total units shipped: 118 · Backordered: 27
Fixed Width packing-slip.txt 7 columns · 6 rows
LineSKUDescriptionOrderedShippedBackorderedUOM
1 TNT-2P-GRN Trailhead 2-Person Tent, Green 12 12 0 EA
2 SB-20F-REG Summit Sleeping Bag 20F, Regular 24 18 6 EA
3 HL-300 Ridge Headlamp 300 lm 48 48 0 EA
4 WB-1L-BLU Insulated Water Bottle 1L, Blue 36 30 6 EA
5 CS-4PK Camp Stove Fuel Canister, 4-pack 10 10 0 CS
6 TP-8X10 Ultralight Tarp 8x10 ft 15 0 15 EA

Audit freight bills, benchmark carriers, and track backorders

Audit invoices, compare carrier performance, and track unfulfilled orders using built-in dataset tools.

Freight bill audit

Verify freight invoices before payment.

Join bills of lading with carrier invoices by NMFC number to spot freight class discrepancies before paying.

Bill of lading · BOL-77310428Fuel canisters · NMFC 041440
410 lb · Class 70
Carrier invoice · PRO 448-201977Fuel canisters · NMFC 041440
410 lb · Class 85
Billed one class higher than shipped
Carrier scorecard

Track carrier reliability and delivery exceptions.

Merge monthly delivery notes and count exception lines per carrier to score delivery accuracy without manual entry.

4
Sierra Freightways exceptions in 121 lines
9
Bayline Express exceptions in 86 lines
2
Coastal LTL exceptions in 64 lines
Backorders

Identify unfulfilled items across shipments.

Merge packing slips for an order and sort by the Backordered column. Lines with units still owed rise above the ones that shipped in full.

PO-4471 · still to shipBackordered
SB-20F-REGSummit Sleeping Bag 20F, Regular6
WB-1L-BLUInsulated Water Bottle 1L, Blue6
TP-8X10Ultralight Tarp 8x10 ft15
AUTOMATED EXTRACTION

Automate shipping document extraction via API

Submit packing slips, bills of lading, or delivery notes to the API and receive structured line items as Excel, CSV, or JSON.

Explore the API
extract-shipping-data.sh
curl -X POST "https://dataconverter.io/api/v1/convert/xls-to-fixed-width" \  -H "Authorization: Bearer YOUR_TOKEN_HERE" \  -F "file=@bol-77310428.xls" \  --output bol-77310428.txt✓ 200 OK · bol-77310428.txt · 5 rows

Frequently asked questions

How do I convert a bill of lading to Fixed Width?

Upload the document above and download the result. The commodity table extracts into rows using original headers like units, packages, weight, NMFC, and freight class.

Which shipping documents can it read?

Packing slips, bills of lading (BOL), delivery notes, proof of delivery (POD) forms, and carrier manifests. Any document with a table layout works regardless of carrier.

Does it extract the tracking number, carrier and ship-to address?

It extracts line-item tables. Header details like PRO numbers, carriers, and addresses stay on the document. Add any missing fields using the Add Columns tool.

Can I compare a packing slip with a delivery note?

Yes. Save both as datasets, then use Join Data to match the packing slip's SKU column to the delivery note's Item column. Shipped and received counts align on the same row, highlighting shortages or damage before payment.

Can I upload a photo or scan of a signed delivery note?

Yes. Select JPEG, PNG, or WebP as the source format. Scans and photos parse the same way as digital PDFs.