Attachment data extraction

Email Attachment Extractor for PDF and CSV Data in Excel and CSV

Stop opening attachments one by one to copy numbers into a sheet

Point MailParse at a Gmail label, an Outlook folder or a folder of saved messages. It reads the email and the digital PDF or CSV attached to it, and gives you one row per message with the invoice number, total, order reference or whatever fields you asked for.

Attachments listed by name, type and size
Text read from digital PDF and CSV files
Body and attachment fields in one row
Excel, CSV & JSON output
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

An email attachment extractor usually means one of two jobs. Saving the files out of the mailbox is one. Getting the data inside them into a spreadsheet is the other. MailParse does the second job. It lists every attachment by filename, type and size, reads the text inside digital PDF and CSV attachments on the Plus plan and higher, and returns one row per email as Excel, CSV or JSON, with the fields you named taken from the body and the attached file together.

PDF + CSV
Text read inside digital files
One row
Per email, attachment fields included
Any mailbox
Gmail, Outlook, IMAP, EML, MBOX
Up to 5,000
Messages in one batch

People who search for an email attachment extractor often want the files themselves, and for that a mail rule, a Gmail filter or an Outlook macro is enough. The harder and more expensive job is what happens next. A supplier sends a PDF invoice every week, a client sends a CSV export every Monday, a carrier emails a rate sheet, and someone has to open each one and copy the figures into a workbook. That copying is where the hours go.

MailParse is built for that second job. It reads the message, finds the attachment, reads the text inside it when it is a digital PDF or a CSV, and puts the fields you named into a single row. A month of attachments becomes one table you can sort, total and import.

What the converter does

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

Lists every attachment

Each message row carries the attachment filenames, content types and sizes, so you can filter for the emails that actually have a PDF and spot the ones that arrived without it.

Reads digital PDF and CSV text

On the Plus plan and higher MailParse reads the text inside digital PDF and CSV attachments and looks for your named fields there as well as in the message body.

Merges body and file

The invoice number may sit in the subject, the total in the PDF and the due date in the body. You get one row with all three, not three exports to join by hand.

Works across a whole folder

Process a label, a folder or a date range in one batch instead of opening messages one at a time. Large uploads run in the background and the results wait for you.

Honest about scans

Scanned PDFs and images carry no text to read, so MailParse flags them in the row instead of returning blanks. Excel and Word attachments are listed but not read.

Excel, CSV or JSON out

Download a workbook for review, a CSV for an import, or JSON for the API. A bills import layout is available for QuickBooks Online, Xero and NetSuite on a paid plan.

How to extract data from email attachments into Excel

Four steps from a mailbox full of attachments to one table.

1

Connect the mailbox or upload files

Connect Gmail or Outlook over IMAP with an app password, or upload EML, MSG or MBOX files you already saved.

2

Choose the folder and dates

Pick the label or folder that collects the attachments, for example Invoices or Reports, and a date range if you want only one month.

3

Name the fields to pull

Write the fields in plain words, such as supplier, invoice number, total and due date. MailParse searches the body and the readable attachment text for them.

4

Download the table

Open the Excel or CSV file, check the rows, and send it to your accounting package, CRM or reporting sheet.

Where reading attachments pays for itself

Jobs where a person currently opens every file.

Vendor invoices sent as PDF

Bookkeepers who receive invoices by email can pull supplier, number, date and total from each PDF into one sheet, then import it as bills instead of keying every line.

Weekly CSV reports from clients or platforms

A report that arrives as a CSV every Monday can be read automatically and stacked into a single history, so trends stop living in forty separate files.

Purchase orders and quotes

Operations teams get orders as PDFs from customers. Extracting the order number, items and delivery date gives you a register without retyping.

Audit and handover

When a mailbox changes hands, a list of every attachment with sender, date and key figures shows what was received without opening thousands of files.

Why a save-attachments tool is not enough

Saving is not extracting

Tools that download attachments into a folder leave you with a folder of PDFs. The numbers inside are still locked in the files.

Rules and macros stop at the file

A Gmail filter or an Outlook macro can move or save the file. Neither reads the amount on it or ties it to the sender and date.

Generic OCR tools ignore the email

Document extraction tools read the PDF but know nothing about the message around it. A row without the sender and received date is hard to reconcile.

Scans need a different tool

MailParse reads text in digital PDFs. For photographed or scanned documents use a dedicated OCR tool and merge its output with the email table.

Ways to handle email attachments compared

Four routes judged on what you end up with. For tools that parse the message itself see the best email parser guide, and for invoices specifically the invoice data extraction page.

Decision point MailParse Save attachments tool Mail rule or macro Standalone OCR service
What you get A table of fields from the email and the attachment A folder of original files Files moved or saved by a trigger Text from the document alone
Reads text inside digital PDF Yes, Plus plan and higher No No Yes
Ties data to sender and date Yes, same row Only through the filename Only through the filename No, unless you build it
Scanned documents Flagged, not read Saved only Saved only Yes, usually
Best for Turning recurring PDF and CSV attachments into a spreadsheet Archiving files One simple saving task Scans and photographed paper

Qualitative comparison of the four routes as they work today. MailParse does not run OCR on scanned PDFs or images, does not read Excel or Word attachments, and does not read the text of attachments inside saved .msg files.

Frequently asked questions

How do I extract data from email attachments into Excel?

Connect your mailbox to MailParse or upload saved messages, pick the folder, and name the fields you want. On the Plus plan and higher it reads the text inside digital PDF and CSV attachments along with the body and returns one row per email that you download as Excel or CSV.

Can it extract attachments from Gmail?

Yes for the data inside them. MailParse connects to Gmail over IMAP with an app password or reads an MBOX file from Google Takeout, lists each attachment, and reads digital PDF and CSV text. It does not copy the original files into a folder.

Does it work with Outlook attachments?

Yes. Connect an Outlook mailbox over IMAP or upload EML files and attachments are listed and read the same way. Attachments inside saved MSG files are listed by name, type and size but their text is not read.

Can it read scanned PDFs?

No. A scan is a picture with no text layer, and MailParse does not run OCR. Those rows are flagged so you know which files need an OCR tool. Digital PDFs exported from accounting or billing software work.

Which attachment types are read?

Digital PDF and CSV files are read on the Plus plan and higher. Every attachment is listed by filename, type and size. Excel workbooks, Word documents and images are listed but their contents are not read.

Can I process hundreds of emails at once?

Yes. A batch takes up to 5,000 messages, and a zip upload can hold more. Large batches run in the background, so you can close the page and download the file when it is ready.

Turn emailed PDF and CSV attachments into one table

Connect a mailbox or upload saved messages, name the fields, and download the results as Excel, CSV or JSON.