How to capture data from a weather report email and save it to an Excel file

See also:
Exporting email contents to an Excel file
Capturing text with the’starts after… continues until’ parsing method

Download this example

exporting email to a spreadsheet file

This example shows how Email Parser can capture a list of temperature and pressure values that is sent by email. You can apply this example to any other type of data that appear multiple times in an email. Addresses, phone numbers, names etc.

The configuration shown above takes all the emails containing “weather report” in the email subject and captures from the email body the temperatures and atmospheric pressure values. After that, it creates new rows in an excel file using temperature and pressure as columns. This is done using the loop action and the save to Excel action.

The email we receive is like this:

From: test@example.com
To: example@example.com
Subject: Weather report
Temperature: 22.1
Pressure: 1032.6 hPa

Temperature: 22.3
Pressure: 1032.9 hPa

Temperature: 21.7
Pressure: 1033.1 hPa

Temperature: 20.8
Pressure: 1033.4 hPa

The key to capture a field that is shown multiple times is to activate the checkbox “The field appears multiple times“:

capture multiple values from an email
exporting a table in an email

If we receive an email with a weather report Email Parser produces the following output:

saving to excel full output

© 2008-2022 FrozenFrog Software  ·  Privacy Policy & Terms of Use
PAD file  ·  Old email parsing forums (now read only)