CSV Export#

Export results#

Select the documents whose data you want to download by ticking them. If you select multiple documents here, they will be combined into one CSV file. Select the action “Get human revised data as a CSV file” in the action tab and click on “ Go”. The download of the CSV file should start automatically. CSV files can be used with spreadsheet programs such as Microsoft Excel, Google Sheets etc.n die Dokumente aus, deren Daten Sie herunterladen möchten. Wenn Sie hier mehrere Dokumente auswählen, werden diese in einer CSV Datei zusammengefasst. Wählen Sie im Action-Reiter die Aktion “get human revised data as a csv file” und klicken Sie auf “go”. Der Download der CSV Datei sollte automatisch starten. CSV Dateien können Sie mit Tabellenprogrammen wie Microsoft Excel, Google Sheets etc verwenden.

To export results, click DOCUMENTS. Select the documents whose data you want to download by ticking them. If you select multiple documents here, they will be combined into one CSV file. Select the action “get all data as a CSV file” in the action tab and click on “go”. The download of the CSV file should start automatically. CSV files can be used with spreadsheet programs such as Microsoft Excel, Google Sheets, etc.

Export data as CSV

Open CSV file in Excel#

Due to the use of different character sets in Excel and CSV files, formatting may be displayed incorrectly when importing CSV files into Excel. To solve this problem, proceed as follows.

  1. Open Microsoft Excel

  2. Click on the “Data” option in the menu bar.

  3. Then select the “Import from Text/CSV” option.

  4. In the dialog that appears, navigate to the location of the CSV file you want to import. Click on the file name and then click Import

  5. The CSV import can now be configured. Select 65001: Unicode (UTF-8) as the file origin and semicolon as the separator. Then click on Load to display the file correctly.

Sample CSV Output#

Assume the following structure

graph LR subgraph Users in Project User --- Project end subgraph Category Project --- Invoice end subgraph Label Set Invoice --- Info[Invoice] Invoice --- Item[Invoice item] end subgraph Label Info --- Total[Gross amount] Item --- Product[Product Name] Item --- Price[Unit Price] Item --- Subtotal Item --- Quantity end

Assume the AI is trained and you upload the following invoice:

img.png

The header and the first row of the exported CSV looks like the following table.

CSV HEADER

document

document_id

document_category

Label Set

Label Set_number

Invoice item__quantity

Invoice item__product name

Invoice item__unit price

Invoice item__subtotal

Gross amount

FIRST ROW

Sample invoice demo.pdf

108679

Invoice

Invoice item

1

1

B-3025, Farbe Grün Musterartikel

47

47

222,51

Explanation

Name of the file

Unique ID to identify the document

Category of the document recognized by the AI

Defined invoice items

Assignment to an invoice item

Quantity of service in an invoice item

Description of the service in an invoice item

Unit price of the service of an invoice item

Subtotal of an invoice item

Gross amount of the invoice