How to Convert Many .eml Files to One CSV

To convert .eml files to a CSV, choose all the files in a converter and download one spreadsheet with a row per message. The EML to CSV tool writes the file name, date, sender name and address, To, Cc, Reply-To, subject, attachment count and names, Message-ID and, optionally, the plain-text body. It runs in your browser, so the messages are never uploaded.

Each file can be up to 50 MB, and dates are converted to UTC from each message's Date header.

Why do this

A folder of saved messages is hard to search, sort or hand to a colleague, and the people in it are often customers, suppliers or applicants you have dealt with before. A CSV lets you log the messages and collect the addresses. For a whole mailbox export instead, see converting MBOX to CSV.

The by-hand way

1. Open each message and copy the sender, date and subject into a sheet.
2. Or write a script that parses the headers of every .eml and decodes encoded names and subjects.
3. Collect the From, To and Cc addresses into one column and remove repeats.

Copying by hand does not survive a few hundred files.

Step 1: save the messages as .eml

Use Save As in your mail app, or More actions, Download in Outlook on the web.

Step 2: choose the files

Select all the .eml files at once. Tick Add a body column if you want the message text.

Step 3: convert and download

Press Convert to CSV, check the preview, then Download CSV. Several recipients in one cell are separated with a semicolon. Copy addresses gives you every From, To and Cc address for the next step; to read one message, use the EML viewer.

What this check cannot do

• It reads .eml only; .msg, .pst and .olm files are skipped.
• The body is plain text cut at 5,000 characters; formatting, images and the attachments themselves are not included.
• A message with a missing or broken Date header has an empty date.
• It lists addresses as they appear in the headers and cannot tell whether a mailbox still exists.
• Very large folders are limited by your browser's memory, so split thousands of large messages into a few runs.

Having an address in your mail is not consent to market to it, so check the rules that apply to you before a campaign.

Next: check which of those addresses still exist

Saved mail is often old. Run the collected addresses through the verify page: the first 100 email checks are free with a Google sign-in, no card. Each comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger lists, see bulk email verification, list cleaning and pricing.

Try it now

Open the EML to CSV tool.