Messy2Sheet workflow

Bill of lading template for Excel.

Download a bill of lading Excel template, or fill it from BOL PDFs, shipment emails, packing slips, freight notes, screenshots, and pasted shipment text.

Source
BOL/PDF/Text
Result
XLSX
Rows
Freight lines
Try one file

Start with the file you already have.

Upload or paste the source, then check the workbook before export.

Bill of Lading Template Excel

Upload BOL PDFs, shipment emails, packing slips, freight notes, screenshots, or pasted shipment text. The Bill of Lading Template is already attached.

  1. 1Source
  2. 2Instructions
  3. 3Create
Source
Fill a reviewable bill of lading workbook

Keep shipment header fields, freight line rows, totals, and source review notes separate. Do not duplicate repeated copies or guess blank service, charges-to, or signature fields.

Template

Choose one, or upload CSV/XLSX.

Creates an Excel workbook from the Bill of Lading Template.

Source check

BOL source and CSV preview

Use the image on the right to check the source page. The preview below shows how the BOL data is separated into shipment, freight, total, and note rows.

Generated CSV rows

A few rows from the generated CSV, shown here before opening the full file.

row typecontract or bol numberpiecespalletsnote
shipment_info6100053934--Repeated copy not duplicated
freight_line6100053934729SAP Forms
freight_line61000539341095Rock Salt
shipment_total610005393418114Visible total row
Download
Proof from a public BOL sample

A public BOL becomes 11 reviewable CSV rows.

This sample uses a public Pennsylvania sample bill of lading. Messy2Sheet keeps the shipment header, two freight lines, total row, disclaimer, and blank signature fields separate instead of flattening the PDF into one note.

11
CSV rows
28
CSV columns
2
Freight lines
7
Source notes

CSV preview from the public Pennsylvania BOL sample

These rows come from the normalized public BOL CSV. The output uses row_type so shipment info, freight lines, totals, and source notes can be filtered before use.

Download sample CSVDownload blank XLSX
row_typecontract_or_bol_numbercarrier_namepiecespalletsdescriptionweight_lbsnotes
shipment_info6100053934XYZ Transportation, IncRepeated copy on page 1 was treated as the same source document and not duplicated.
freight_line6100053934729SAP Forms1700
freight_line61000539341095Rock Salt2600
shipment_total6100053934181144300Visible total row; description, RSF, and WPO cells are blank.
source_note6100053934Blank signature/date field in source.

Shipment header

Shipment-level details stay in shipment_info so carrier, bill-to, shipper, and consignee fields can be reviewed before freight rows.

contract_or_bol_numbercarrier_nameshipper_nameconsignee_name

Freight line rows

Freight lines keep visible pieces, pallets, description, WPO, and weight fields from the source.

piecespalletsdescriptionwpoweight_lbs

Source review notes

Blank signatures, unselected options, and missing trailer seal values become source notes for human review.

signature_fieldservice_requestedcharges_tonotes
Repeated PDF page vs reviewable BOL rows

Generic extraction

A generic PDF extraction can duplicate the repeated sample copy and mix disclaimer text, blank signature labels, and freight details together.

  • duplicate copied page
  • blank fields mixed into rows
  • shipment and freight fields flattened

BOL template workflow

The BOL workflow separates row_type values so shipment info, freight lines, totals, and source notes can be checked independently.

  • shipment_info rows
  • freight_line rows
  • shipment_total rows
  • source_note rows
Extraction details

What a useful bill of lading workbook needs.

BOL cleanup works when the workbook preserves shipment context, freight lines, totals, and blank fields that require review.

Shipment header

Keep the BOL header separate from freight rows

Use one section for shipment-level fields such as carrier, shipper, consignee, bill-to, shipment date, and service options.

Freight rows

Turn freight lines into checkable rows

Extract one row per visible freight line with pieces, pallets, description, WPO, weight, and source row context.

Do not guess

Use review notes for missing or blank fields

Blank signatures, unselected service boxes, missing trailer seals, and unsupported charge fields stay visible as review notes.

Fit check

Use it when bill of lading details need a reviewable workbook.

BOL extraction works when the shipment source is readable and the final freight fields are clear enough to review.

Best BOL inputs

  • Readable BOL PDFs, shipment emails, packing slips, freight notes, screenshots, or pasted shipment text.
  • Sources with visible carrier, bill-to, shipper, consignee, pieces, pallets, descriptions, WPO, or weights.
  • Shipping or fulfillment review that ends in Excel or CSV.
  • Recurring freight, carrier, vendor, warehouse, or government shipment layouts.

Check BOL outputs when

  • Carrier name, BOL number, shipper, consignee, pieces, pallets, or weight are missing.
  • The same BOL appears more than once and should not become duplicate freight rows.
  • Signature fields, service options, charges-to boxes, trailer seal, or PRO number are blank.
  • The result depends on carrier software, live tracking, compliance rules, or rates outside the upload.
Template and workflow

Start with a BOL layout you can reuse.

For repeat shipment sources, start with BOL header fields and freight line rows, check one result, then reuse the same BOL workflow.

Template

Bill of lading workbook layout

Use a BOL workbook that separates shipment header fields, freight lines, source review, and validation rules.

Bill of Lading: BOL number, carrier, shipment date, bill-to, shipper, consignee
Freight Lines: line number, pieces, pallets, description, WPO, weight
Review: repeated copy, blank signature, missing trailer seal, unselected options
Saved workflow
Reuse

Saved BOL workflow

Save the shipment rules that preserve freight rows, totals, and blank source fields without guessing carrier details.

  1. 01Keep shipment fields separate from freight line rows.
  2. 02Do not duplicate repeated copies of the same BOL.
  3. 03Leave unselected service, charges-to, and signature fields blank for review.
Workflow

From BOL source to shipment review workbook.

Start from the BOL source

Upload BOL PDFs, shipment emails, packing slips, freight notes, screenshots, or pasted shipment text.

Separate header and freight rows

Keep carrier, shipper, consignee, bill-to fields, pieces, pallets, descriptions, WPO, and weight in the right rows.

Review blank fields

Use source notes for repeated copies, unselected options, blank signatures, and unsupported carrier details.

Next paths

Choose the next page by how this job repeats.

Start with this converter for one file. Move to templates or workflows when the final layout or repeat process becomes clear.

Packing slip template

Use the packing slip template when tracking numbers, ship-to fields, SKU rows, and shipped quantities are the main source.

Open packing slip template

Purchase order automation

Use purchase order automation when the source is a buying packet with vendor, item, price, freight, and approval fields.

Automate purchase orders

Sales order automation

Use sales order automation when customer orders need to become line-item spreadsheets before fulfillment.

Automate sales orders
Related workflows

More ways to turn documents into Excel.

If this is not the file on your desk today, start with a nearby workflow and adjust the columns before running it.

Text to CSV converter

For pasted emails, OCR text, supplier notes, lists, and semi-structured business text.

Convert

PDF to CSV converter

For PDF tables, scans, screenshots, price lists, reports, and target CSV fields.

Convert

Image to Excel

Turn a screenshot, scan, or photo into spreadsheet rows. Pick fields for item labels, categories, price columns, review status, and notes, then check the rows before downloading.

Start

Invoice automation

For invoice automation, supplier fields, taxes, totals, and itemized line rows.

Automate

Merge Excel files

For combining Excel or CSV files into one workbook, one sheet, or separate tabs.

Merge

Excel formula generator

For creating formulas, checks, totals, lookups, and workbook calculations from plain English.

Generate
FAQ

Questions before you upload?

What is a bill of lading template?+

A bill of lading template is a spreadsheet layout for shipment fields such as carrier, shipper, consignee, bill-to account, freight lines, pieces, pallets, weight, totals, and review notes.

Can I download this bill of lading template as Excel?+

Yes. The built-in XLSX template includes Bill of Lading, Freight Lines, Source Review, and Validation Rules sheets.

Can Messy2Sheet fill it from a BOL PDF?+

Yes. Upload a BOL PDF, shipment email, packing slip, screenshot, or pasted shipment text, then review the extracted rows before using the workbook.

Will it guess missing carrier or signature fields?+

No. Fields such as PRO number, NMFC class, hazmat status, signatures, selected service options, and freight charges should stay blank or become review notes unless they are visible in the source.

Is this legal shipping advice?+

No. Messy2Sheet helps clean source data into a spreadsheet for review. It does not provide legal advice, shipping compliance advice, or carrier documentation approval.

Try it on one real file.

Upload the document, keep or edit the template instructions, and check the workbook before you download it.

Start