Export Emails to Excel, CSV, or Google Sheets has a powerful editor which allows you to define your own custom parsing rules.

You can access the editor by clicking on “Add or edit parsing” rules in the export dialog:

Here is a short movie showing how to use the editor:

Overview

The editor is devided into 3 sections:

Here the overview of the operations you can perform

  1. Add a new custom column:
    There are two ways to add new column:

    1. You can add a new custom column highlight the text on the left side. After you highlight the text you will be prompted to enter the name of the column.
    2. You can also click on Add rule manually (in left pannel in upper right corner)
  2. Delete custom column:
    To delete a custom column, click on the “X” button next to the column name on the right panel.
  3. Modify parse rules:
    To modify a parse rule, click on “wrench” icon next to rule.
  4. Modify column names:
    To modify the name of the column, click on the column name and enter the new name.

Rule types

  1. Text after: the value of spreadsheet column will be text after the text pattern.
  2. Text before: the value of spreadsheet column will be text before the text pattern.
  3. Text between: the value of spreadsheet column will be text between text patterns.
  4. Lines between: the value of spreadsheet column will be all lines between lines matching patters.

The parse rules are saved per Gmail label: each Gmail label can have one set of parsing rules.