Skip to main content
All CollectionsExporting data
Manually download extracted data
Manually download extracted data

Download extract data from your documents as Excel, CSV or JSON

Updated over a week ago

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

Screenshot showing the Download Export section
  • Click on the file format you want to download

screenshot showing the file icons 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:

Did this answer your question?