Parseur offers various export strategies. The most simple one is to download parsed data to your computer.
How do I download extracted data?
To download data extracted by Parseur:
Open your mailbox
Click on the "Download / Export" section in the left menu
Click on the file format you want to download
The file will be downloaded to your default browser download folder
What download formats are available?
You can download the parsed data in 3 formats:
As an Excel file (.xlsx): choose this if you want to view and reword the data in Excel
As a Comma-Separated Values file (.csv): choose this if you want to import the data into software that can ingest CSV files
As a JSON file (.json): choose this if you want to import the data into software that can ingest JSON objects or if you plan on using webhooks later and want to use a sample payload while developing.
How do I filter downloaded data?
By default, Parseur will generate a download file that includes all parsed data from all documents in your mailbox.
Use the Filter section at the top to filter the data to download.
You can either:
Click "Last document only" to only download the data parsed from the last received document in your mailbox
Select "Specific date range" and then pick a year and, optionally, a month and day to only download data from that specific date.
When selecting the date filter, be mindful that Parseur assumes the date is in the UTC timezone. If you live in another timezone, this can result in different cutoffs.
What is the difference between a table field view export and a document view export?
If you have a field with the table format in your field set, you will see several download icons, like in the screenshot above:
The table-field view download will create one row per table-field row processed. Non-table fields will be repeated on each row. This is usually the preferred option when you have table fields.
The document view download will create one row per document processed. Each cell in a table will be added as a separate column. This is usually not the desired result when having table fields.
Can I change the field order in the downloaded file? Can I select a subset of fields to download?
You cannot directly rearrange the order or list of fields in the default download file.
However, you can download the original file and then create a new sheet where you can reorder the fields as needed, using formulas or a pivot table to fetch and organize the data from the original sheet according to your preferences.
Another method to change the field order is by using automation platforms like Zapier or Make. You can configure these tools to send your data to an online spreadsheet application such as Google Sheets, Excel Online, or Airtable. This allows you to rearrange the fields in your desired order within these platforms. See below for more information.
Can I automate the downloading of the data?
If you're looking into automating data export from Parseur, we recommend that you look at our other export sections, like:
Using Zapier, Make or Power Automate to send data to any cloud application