How do freight forwarders compare carrier rates from Excel, PDF and email?

Carrier rates rarely arrive in one clean, consistent format. One carrier sends a detailed Excel file, another attaches a PDF, and a third puts the whole quote inside an email body. The real work is not just copying numbers. It is making sure every rate, surcharge, condition, and validity date means the same thing before comparing options.

All rates and amounts below are invented examples.

Why does each format cause different mistakes?

Each format hides information in a different place. Knowing where to look is half the work.

Excel files usually look easiest at first. You may receive a workbook with separate tabs for origins, destinations, commodities, equipment types, or surcharge schedules. The problem is that key information may be hidden in another tab, rows may be grouped, cells may be merged, or formulas may reference a sheet nobody notices. A base ocean freight rate can look attractive until you find the local charges or peak-season surcharge elsewhere in the workbook.

PDF rate sheets are often clean to read but difficult to work with. Tables may not copy properly, columns can shift when pasted into another file, and charges may be split across multiple pages. A PDF may show freight on page one, then list destination charges, equipment imbalance surcharges, or exclusions on page two or in a footnote.

Email quotes are usually the fastest for a carrier to send and the hardest to standardize. Rates may be written in a few short lines, mixed with operational comments, or buried below a long email thread. Sometimes the validity, routing, transit time, or "subject to" language is tucked into the signature or below the sender's name.

Why does one small line change the comparison?

The most important part of a rate sheet is often one sentence, not the table.

For example, a carrier may quote:

Newark to Jebel Ali, 40HC: USD 1,900

That looks straightforward until a note at the bottom says:

All rates are subject to USD 150 per container EBS effective November 1.

EBS is an emergency bunker surcharge. That single line changes the real comparison. The effective freight cost is USD 2,050 before other applicable charges. If that note is missed, the quote may look cheaper than another carrier's when it is not.

Here is the same lane from two carriers, put into one layout:

On the headline number, Carrier A looks USD 80 cheaper. Once the EBS line is counted, Carrier B is USD 70 cheaper.

How do you normalize rates from different formats?

To compare rates properly, I put every format into the same layout. The goal is to make an Excel row, a PDF table, and an email quote look identical once they are entered.

The fields I normally extract are:

• Carrier and service name
• Origin and destination
• Port pair or door-to-door routing
• Equipment type, such as 20GP, 40GP, 40HC, LCL, or air freight weight break
• Base freight rate
• Currency
• Included charges
• Additional surcharges
• Origin and destination local charges
• Validity dates
• Transit time or sailing schedule, if provided
• Commodity, weight, or hazardous restrictions
• Routing and transshipment details
• Notes, exclusions, and rate conditions
• Source document or email reference

My working layout is usually simple: one row per carrier and equipment type, with the base rate separated from each surcharge. I avoid putting everything into one "all-in" number too early, because the customer or operations team may need to see exactly what is included, excluded, or still pending.

What gets missed most often?

The biggest mistakes are usually not in the visible base rate. They are in the conditions around it.

• Validity dates buried at the bottom of an email or inside an attachment note
• A different currency used for one surcharge than the main freight rate
• A surcharge listed on page two of a PDF
• A new effective date that applies only to a specific charge
• "Subject to" wording that means a cost is not yet included
• Equipment-specific pricing, such as a 40HC rate being different from a 40GP rate
• Commodity restrictions, especially for hazardous cargo, reefer cargo, overweight shipments, or named-account rates
• Inland, chassis, documentation, AMS, ISPS, terminal, peak-season, equipment imbalance, or emergency bunker charges
• Routing changes that affect transit time or transshipment risk
• A quote marked "indicative," "for guidance only," or "subject to space and equipment"

A rate is only comparable when the scope is comparable. The cheapest base rate may not be the lowest total landed cost.

What should you check before trusting a copied rate?

Before trusting a rate copied from any format, I check:

• Is the origin, destination, and routing exactly correct?
• Is the rate for the correct equipment type, commodity, and shipment mode?
• What currency is each charge in?
• Are all surcharges included, separated, or still subject to change?
• Are origin and destination local charges included or excluded?
• What are the exact validity dates?
• Is there an effective date for any new surcharge?
• Are there footnotes, email comments, hidden tabs, or additional PDF pages?
• Does the quote have restrictions for cargo type, weight, dimensions, or named accounts?
• What type of quote is this: contract, spot, indicative, or subject to confirmation?
• Does the total reflect the same scope as the competing carrier quote?
• Can someone else review the source and understand how the total was built?