How can I extract data from CSV or Excel email attachments?
Parsing email data from attached CSV or Excel files is a simple task with Mailparser. All you need to do is to set the source of your parsing rule to "Attachments" and then choose "Text content (Table Cells)" in the first filter.
This will give you all the table rows and columns of the attached spreadsheet. You can then add different cell filters to select, crop, search, and split cells. For example, you can add a filter "Only keep rows having a number in the first column".
To read more our "Read and Parse email attachments" article will help too.