PDF to Excel for Logistics: Convert Freight Invoices, Rate Confirmations, and Bills of Lading
Carriers bill in whatever format they feel like, and most of it lands as a PDF in somebody's inbox. PDFXLSX reads the charge lines off the page and hands back clean Excel, with linehaul, fuel surcharge, accessorials, and totals kept numeric so you can actually audit what you were billed. Drop an invoice on the right to see it work.
Your first conversion is free, and files are deleted after processing.
Drop your PDF here or click to browse
PDF files up to 50MB
First conversion is free. Nothing to install.
The short answer
To convert a freight invoice or carrier bill to Excel, upload the PDF to a converter that detects the charge line table and exports a spreadsheet, instead of rekeying each shipment into your audit workbook. You get one row per shipment or charge line with the pro number, ship date, origin and destination, weight, class or NMFC, linehaul, fuel surcharge, each accessorial, and the invoice total, all kept numeric. That is what turns a freight bill audit into a formula: compare billed against your contracted tariff, flag duplicate pro numbers, and total accessorials by carrier. Logistics teams reach for this on the carriers and brokers that never send EDI 210 invoices, which is most of the small and regional ones.
Last updated July 2026
Charges
Stay numeric
Scans
OCR for faxed bills
Batch
A whole carrier run
XLSX + CSV
Ready for your audit sheet
Why freight bills still get keyed by hand
EDI solved this for the big carriers and then stopped. A national LTL carrier sends a clean 210 that drops straight into your system, and for those the work is already done. The rest is where the labor sits: regional carriers, owner operators, freight brokers, drayage and final mile providers, parcel consolidators, and anybody you moved a single load with last quarter. They email a PDF, and somebody reads it into a spreadsheet line by line.
The cost is not just the typing. It is that the charges never become data you can question. Freight audit, as the industry defines it, means checking each bill for validity, mileage, duplicate payment, accessorial charges, and whether the correct tariff was applied. Every one of those checks is a comparison, and you cannot compare anything against a PDF. So the invoice gets approved because it looks about right, and the detention charge nobody authorized gets paid along with it.
Converting turns the stack into rows. The engine reads each charge line, keeps the dollar columns as real numbers, and returns a sheet where linehaul plus fuel plus accessorials ties to the invoice total. From there you can look up each lane against your rate agreement, sort accessorials by type to see what is really driving spend, or filter for a pro number that appears twice. Try it on an invoice at the top.
| Pro number | Weight | Linehaul | Fuel | Total |
|---|---|---|---|---|
| 041826337 | 1,240 | 418.60 | 121.39 | 539.99 |
| 041826341 | 6,880 | 1,142.00 | 331.18 | 1,548.18 |
| 041826355 | 920 | 386.25 | 112.01 | 573.26 |
| 041826362 | 14,300 | 2,067.40 | 599.55 | 2,666.95 |
| 041826370 | 3,415 | 744.80 | 216.00 | 1,035.80 |
Charge columns come back as numbers, so billed against contracted rate is a subtraction rather than a read through. The third line carries a 75.00 residential delivery fee inside the total.
Logistics documents you can convert
Anything with a table on the page. These are the ones freight, brokerage, and supply chain teams send through most often.
| Document | What comes back | What it is for |
|---|---|---|
| Carrier invoice or freight bill | One row per shipment with pro number, lane, weight, linehaul, fuel, accessorials, total | Freight bill audit before you approve payment |
| Rate confirmation | Load number, lane, pickup and delivery dates, agreed rate, accessorial terms | Checking the invoice against what was actually agreed |
| Bill of lading | Shipper, consignee, piece count, weight, class or NMFC, freight terms | Verifying billed weight and class against what shipped |
| Carrier rate sheet or tariff | Lane or zone against rate, with fuel and accessorial schedules | Loading contracted rates so billed can be compared to them |
| Parcel and small package statements | Tracking number, service level, zone, billed weight, surcharges | Finding dimensional weight and residential surcharges |
| Packing lists and manifests | Line items, SKUs, quantities, and case counts | Receiving reconciliation and shortage claims |
| 3PL and warehouse billing statements | Storage, handling, and pick and pack charges by period | Checking a monthly statement against the storage agreement |
The rate sheet is the quiet win here. Carriers publish tariffs and fuel schedules as PDFs, and until that PDF is a spreadsheet you cannot put the billed rate next to the contracted rate and see the gap. Procurement teams comparing carrier bids work the same way, which our PDF to Excel for procurement page covers.
Built for the way freight teams work
The details that decide whether a converted invoice is usable or just a picture of one.
Charge columns stay numeric
Linehaul, fuel surcharge, accessorials, and invoice total come back as numbers, not text. A charge column that looks right but sums to zero is the single most common conversion failure, and it is the one we care most about avoiding.
Pro numbers keep their leading zeros
Pro numbers, PO numbers, and tracking numbers stay exactly as printed instead of being helpfully turned into numbers. A pro number that loses a leading zero stops matching your TMS export, which is how duplicate payments get missed.
OCR for faxed and scanned bills
Plenty of freight paperwork still arrives as a fax or a photo of a signed delivery receipt. Built in OCR reads image only PDFs, so a scanned bill of lading converts the same way a clean digital invoice does.
Multi page carrier runs
A weekly carrier statement that runs forty pages with the charge table continuing across each one comes back as a single continuous sheet, rather than forty fragments you stitch together by hand.
Batch a whole week of invoices
Upload the stack rather than one file at a time and download the spreadsheets together. Practical when Friday invoice approval is the bottleneck. See the batch PDF to Excel converter.
XLSX or CSV
Take the spreadsheet into your own audit workbook, or use CSV where a TMS or ERP import template expects it. The output is an ordinary file you own, with no format lock in.
How to convert a freight invoice to Excel
Upload the PDF
Drop the carrier invoice, rate confirmation, or rate sheet into the converter at the top of this page. Scanned and faxed pages are fine.
The charge table is detected
The engine finds the shipment and charge line table, maps its columns, and carries the table across page breaks so a long carrier run stays one sheet.
Download and audit
Open the XLSX and check that the charge columns total to the invoice amount the carrier states before you work from it. That one tie out catches nearly everything.
Who this helps
The common thread is a pile of carrier paperwork standing between someone and a number they need in a spreadsheet.
Transportation and logistics managers
You are asked what freight cost last quarter and why it moved, and the honest answer is buried across a few hundred PDFs. Converting a quarter of invoices gives you spend by lane, by carrier, and by accessorial type, which is the analysis that supports a rate negotiation.
Accounts payable teams paying carriers
Approving a freight invoice means confirming the load happened, the rate matches the confirmation, and you have not already paid that pro number. In a spreadsheet those are three formulas. In a PDF inbox they are a judgment call.
Freight brokers and 3PLs
You sit between the carrier bill and the customer invoice, so margin per load is the whole business. Getting both sides into one sheet is how you see which lanes are quietly running thin.
Small shippers without a freight audit provider
Third party audit firms are worth it at volume. Below that threshold the practical alternative is a spreadsheet you maintain yourself, and the only hard part is getting the invoices into it. Teams handling the purchasing side of the same relationship use our purchase order to Excel converter.
Freight questions
Upload the PDF into the converter at the top of this page, let it detect the charge line table and run OCR if the bill is a scan, then check the preview and download a spreadsheet that opens in Excel. It takes a few seconds and nothing installs. One row comes back per shipment or charge line, with the pro number, lane, weight, and each dollar column kept numeric so the audit formulas work immediately.
No, and the difference matters. Freight audit and payment providers ingest your bills, apply your contracted tariffs, dispute the exceptions, and pay carriers on your behalf. We do one part of that: turning the PDF into a spreadsheet you can work in. If you ship enough volume to justify an audit provider, use one. If you are auditing in Excel because your volume does not justify the fee, or you want to spot check what a provider passed through, this is the step that gets the data in front of you.
The standard freight audit checks are bill validity, mileage, duplicate payment, accessorial charges, and whether the right tariff was applied. In practice the recurring ones are reweighs and reclasses that move a shipment into a higher bracket, accessorials nobody authorized such as detention, liftgate, or residential delivery, fuel surcharge calculated off the wrong index date, and the same pro number billed twice by a carrier and a broker. Each of those is easy to catch once the charges are columns and hard to catch while they are paragraphs on a PDF.
Convert both documents, put them in two sheets of one workbook, then look up each load or pro number from the invoice against the confirmation and subtract the rates. Anything with a difference is worth a question. A lookup formula is the whole job, and our guide to using VLOOKUP in Excel covers the matching, including why a pro number stored as text refuses to match one stored as a number. To flag a pro number billed twice, our guide to comparing two columns in Excel is the faster route.
Yes. Built in OCR handles image only PDFs, which is what a scanned or faxed page is. Scan quality drives accuracy more than anything else, so 300 DPI and a straight page make a real difference, and a signed delivery receipt photographed on a phone in a dark dock is the hardest case. Whatever the source, check the totals against the stated invoice amount before working from the sheet. See the OCR PDF to Excel converter for how the scanned path works.
Treat it as a working file rather than the record. The carrier's invoice is the source document and belongs in the file exactly as received, because that is what a dispute, a claim, or an audit will be judged against. Before you approve or report from the sheet, confirm the charge columns total to the invoice amount the carrier states. If it ties, the extraction is sound. If it does not, you have found either a page the converter missed or a line you would have keyed wrong by hand.
More ways to convert PDF to Excel
PDF to Excel for Real Estate: Convert Rent Rolls, T12s, and Operating Statements
Convert real estate PDFs to Excel and CSV. Rent rolls, T12 operating statements, and closing statements become clean spreadsheet rows you can underwrite in minutes.
AudiencesPDF to Excel for Accountants: Convert Client Statements and Reports
Convert client bank statements, financial reports, and scanned PDFs to Excel. Numbers stay numeric for reconciliation, month-end close, and QuickBooks import.
AudiencesPDF to Excel for Bookkeepers: Convert Statements and Receipts
Convert client bank statements and receipts from PDF to Excel and CSV. Numbers stay numeric for monthly bookkeeping, categorizing, and QuickBooks or Xero import.
AudiencesPDF to Excel for Finance Teams: Convert Financial Statements and Reports
Convert PDF financial statements and reports to Excel and CSV for your finance team. Numbers stay numeric and drop into models without broken cells or retyping.
Stop keying in carrier invoices
Drop a freight bill at the top of the page and download a clean Excel or CSV in seconds. Your first conversion is free. For everyday work, start with the PDF to Excel converter, or pull just the grids with the PDF table extractor.