For freight brokers and forwarders

Freight Quote Email Parser to Excel for Freight Brokers and Forwarders

Every rate request in the inbox, one row per lane

Parse the shared quotes mailbox and get origin, destination, equipment, weight, pickup date and contact for each request in one sheet. Upload .eml or .msg files, a .zip, or connect the mailbox over IMAP. Export to Excel, CSV or JSON, or send each parsed request to your own system by webhook.

Reads the email body and HTML tables
Excel, CSV or JSON out
IMAP, forwarding address or bulk upload
Up to 5,000 emails per file
Convert your email files
No install

Connect a Gmail or IMAP mailbox to parse new mail automatically, or paste an email below to test the converter now.

or paste an email to test
Output format
Columns to extract
Extract your own custom fields
Popular:

Create a free account to download. No credit card required.

Quick answer

A freight quote email parser reads each rate request in your inbox and writes the lane details to a row: origin, destination, equipment, weight, commodity, pickup date and the requester. MailParse reads those fields from the subject, body and HTML tables of the email, so a day of quote requests becomes one Excel, CSV or JSON file you can sort by lane and price from, instead of a stack of messages to retype.

8+ fields
Lane, equipment, weight, dates and contact
5,000
Quote emails per downloaded file
10,000
Emails in one .zip upload
3 parses
On your own emails before you sign up

Freight quote requests rarely arrive in one shape. A shipper writes "Need a 53 ft dry van, Dallas TX to Atlanta GA, 38,000 lbs, picks up Thursday" in a sentence. A regular customer pastes a table. A carrier sheet comes in as a CSV. Someone on the desk opens each message, copies the lane into the TMS or a rate sheet, and answers. At 80 requests a day the typing is the job, and the slowest part is the half hour before anyone has even priced the first lane.

MailParse does the reading. You name the fields once (origin, destination, equipment, weight, commodity, pickup date) and it pulls them out of every request, keeping the sender and timestamp so you know who asked first. The result is a sheet your pricers can work down, or a JSON record sent to your own system. For the same approach on purchase orders and quote requests outside freight, see how to parse RFQ and quote request emails.

What the converter does

Everything you need to turn the email your team receives into a spreadsheet it can actually use.

Lane fields you define

Save fields such as origin, destination, equipment, weight, commodity, pickup_date and requester. Labels written the usual way ("Pickup:", "Equipment:", "Weight:") are found without setup, and your saved fields win when a customer words things differently.

Requests written as sentences or tables

Values come from the subject, the plain-text body and HTML tables, which covers both the shipper who types a line and the regular who pastes a rate-request grid.

Digital attachments on Plus and higher

MailParse also reads the text inside vendor-generated PDF and CSV attachments up to 8 MB, so a request with an attached lane list lands in the same file. Scanned paper is not read.

Sender and time kept on every row

The requester email and received time sit beside the lane, so you can answer in order, match a reply to the right contact and spot repeat customers.

A whole mailbox in one pass

Connect the quotes address over IMAP, forward requests to your MailParse address so each is parsed within minutes, or drop a folder or .zip of saved messages for a backlog.

Hand-off to your own system

Send each parsed request as JSON to a webhook of yours, so a rating tool or internal queue gets structured lanes. MailParse does not quote rates or book loads for you.

How to parse freight quote emails to Excel

Four steps from a crowded quotes inbox to a sheet your desk can price from.

1

Bring the requests in

Upload saved .eml or .msg files, a folder or a .zip of up to 10,000 messages, or connect the shared quotes mailbox over IMAP.

2

Name the lane fields

Save origin, destination, equipment, weight, commodity and pickup date once. Add accessorials or hazmat flags if your customers include them.

3

Check the first batch

Open the parsed rows next to the original emails. Fix a field name that missed a customer's wording once and the correction applies to the rest.

4

Download or push the data

Export one Excel or CSV file per day or week, or send each request as JSON to your webhook for the next system to pick up.

Who parses freight quote emails this way

Desks where the same few fields are retyped from email all day.

Freight brokerages

Reps share a quotes inbox and every request needs the lane in a rate sheet before a carrier is called. A parsed sheet gets pricers to work in minutes.

Freight forwarders

Import and export inquiries carry ports, incoterms, container type and cargo details in free text. Pull them into columns and sort by mode or origin.

3PLs and dispatch teams

Customer load requests arrive in several formats. One file per shift shows what is asked, from whom and for when.

Carriers taking spot requests

Brokers email lanes all day. Keep a searchable log of every lane and ask so you can see which corridors repeat before you price them.

Why parse the quote emails instead of retyping them

Price sooner

Lanes already in columns mean the pricer starts on the rate, not on copying a city name from a paragraph.

Fewer wrong-lane quotes

Origin and destination are copied from the email text, so a transposed ZIP or swapped city stops reaching the quote.

A record of every ask

Each request keeps sender and time, which makes lane history and response-time reporting a sort, not an archaeology project.

No software to replace

MailParse sits beside the TMS. It prepares structured data, and your team keeps quoting and booking where they do today.

Ways to get freight quote emails into a sheet compared

The right route depends on how many requests you handle and how many different formats customers use.

Decision point MailParse Freight workflow platforms Copy and paste by hand
What it does Turns quote request emails into rows of fields you name Often adds quoting, carrier outreach and booking on top of extraction A person reads each email and types the lane
Requests written as free text Yes, from labels in the body, plus fields you save Yes, typically AI extraction, check with a sample of your own emails Yes, slowly
Backlog of saved emails Yes, a .zip of up to 10,000 emails in one upload Usually only new mail from the connected inbox One at a time
Quoting and booking No, it prepares the data only Some include it Manual
Setup Upload files, or connect the mailbox over IMAP Usually a sales conversation and an implementation None
Best for Desks that want lanes in a sheet or JSON feed, quickly Teams that want the whole quote workflow automated A handful of requests a day

Freight workflow platforms described in general terms from their public pages; capabilities and pricing vary by vendor, so check with a sample of your own emails. MailParse reads digital text only and does not rate, quote or book loads.

Frequently asked questions

Can I parse freight quote request emails into Excel?

Yes. Upload the saved emails or connect the shared mailbox, name fields such as origin, destination, equipment and pickup date, and download one Excel or CSV file with a row per request. MailParse reads the subject, body and HTML tables, so both typed sentences and pasted tables are covered.

What fields can it pull from a freight rate request?

Any value written in the email that you name: origin, destination, equipment type, weight, commodity, pickup and delivery dates, hazmat or accessorial notes and the requester. Common labels are found without setup. Anything unusual you save once as a custom field and it applies to every later email.

Does it work on requests with an attached lane list?

On Plus and higher MailParse reads the text of digital PDF and CSV attachments up to 8 MB, so an attached lane list lands in the same file as the email body. Scanned or photographed documents are not read, because there is no OCR.

Can it parse a shared quotes inbox automatically?

Yes. Connect the mailbox over IMAP with an app password, or forward requests to your MailParse address and each message is parsed within minutes. You can also send every parsed request as JSON to a webhook of your own.

Does MailParse quote rates or book loads?

No. It extracts the request data and hands it to you as a sheet or JSON. Pricing, carrier outreach and booking stay in your TMS or your team's process. That keeps it simple to add beside what you already run.

How many quote emails can I process at once?

A single upload can be a .zip of up to 10,000 emails, and one downloaded file holds up to 5,000 parsed rows. For daily use, connect the mailbox or forwarding address so requests are parsed as they come in.

Can I try it on my own freight emails first?

Yes. You can parse 3 of your own emails before creating an account to see which fields it finds. Paid plans add bulk upload, mailbox connection, attachment text, webhooks and larger files.

Turn today's rate requests into a sheet your desk can price from

Upload the quote emails or connect the shared mailbox, name the lane fields once, and download Excel, CSV or JSON.