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 specific fields to download?
At the moment, it’s not possible to directly rearrange or customize the fields in the default download file. However, you can help us prioritize this feature by upvoting the following request: Customize the fields/field order in Excel/CSV downloads.
In the meantime, you can manually adjust the field order by downloading the file and creating a new sheet. From there, you can use formulas or a pivot table to reorganize the fields according to your needs.
Alternatively, you can automate the process using platforms like Zapier or Make. These tools allow you to send your data to an online spreadsheet application, such as Google Sheets, Excel Online, or Airtable, where you can customize the field order. For more details, see the information below.
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