Supported formats
File Input nodes accept the extensions below by default. You can limit accepted types in the File Input node settings. Parsed tabular data becomes Apache Arrow datasets on the workflow engine (see Storage and processing).
Extension reference
Section titled “Extension reference”| Extension | Category | Processing |
|---|---|---|
.csv |
Tabular and spreadsheets | Parsed in-browser or on the workflow engine into Arrow datasets. Excel formats use server-side conversion. |
.tsv |
Tabular and spreadsheets | Parsed in-browser or on the workflow engine into Arrow datasets. Excel formats use server-side conversion. |
.psv |
Tabular and spreadsheets | Parsed in-browser or on the workflow engine into Arrow datasets. Excel formats use server-side conversion. |
.xls |
Tabular and spreadsheets | Parsed in-browser or on the workflow engine into Arrow datasets. Excel formats use server-side conversion. |
.xlsx |
Tabular and spreadsheets | Parsed in-browser or on the workflow engine into Arrow datasets. Excel formats use server-side conversion. |
.json |
Structured data | JSON arrays and objects load as structured records for downstream transforms. |
.xml |
Structured data | XML loads as structured records. Repeating sibling elements become one row each with dotted nested paths. |
.fix |
Financial data | FIX, SWIFT MT / MT940, and OFX/QFX parsed via the platform file-parser pipeline. |
.swift |
Financial data | FIX, SWIFT MT / MT940, and OFX/QFX parsed via the platform file-parser pipeline. |
.mt940 |
Financial data | FIX, SWIFT MT / MT940, and OFX/QFX parsed via the platform file-parser pipeline. |
.ofx |
Financial data | FIX, SWIFT MT / MT940, and OFX/QFX parsed via the platform file-parser pipeline. |
.qfx |
Financial data | FIX, SWIFT MT / MT940, and OFX/QFX parsed via the platform file-parser pipeline. |
.pdf |
Office and PDF | PDF and office documents route through Docling on the workflow engine for structure, tables, and text extraction. |
.docx |
Office and PDF | PDF and office documents route through Docling on the workflow engine for structure, tables, and text extraction. |
.pptx |
Office and PDF | PDF and office documents route through Docling on the workflow engine for structure, tables, and text extraction. |
.txt |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.md |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.markdown |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.html |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.htm |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.adoc |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.asciidoc |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.asc |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.tex |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.latex |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.vtt |
Text, markup, and captions | Plain text and markup sources for structured extraction and downstream transforms. |
.png |
Images | Raster images for OCR and document-ingest workflows via Docling. |
.jpg |
Images | Raster images for OCR and document-ingest workflows via Docling. |
.jpeg |
Images | Raster images for OCR and document-ingest workflows via Docling. |
.tif |
Images | Raster images for OCR and document-ingest workflows via Docling. |
.tiff |
Images | Raster images for OCR and document-ingest workflows via Docling. |
.bmp |
Images | Raster images for OCR and document-ingest workflows via Docling. |
.webp |
Images | Raster images for OCR and document-ingest workflows via Docling. |
XML parsing
Section titled “XML parsing”XML uploads on File Input parse to Arrow rows on the same path as JSON and FIX (browser and workflow engine).
- Repeating records: the largest list of sibling objects (length 2 or more) becomes one row per item. Nested ISO 20022 files typically explode on
TxorRcrdSts, not on a shorter nested list. - Nested fields: child elements flatten to dotted column names (for example
New.TxId). Element text sits on the parent key; attributes sit beside it (New.Pric.AmtandNew.Pric.Amt.Ccy). - Single-object documents: a document with no repeating list flattens into one row.
- Invalid XML: File Input rejects the file. It does not treat markup as CSV lines.
Excel workbooks
Section titled “Excel workbooks”Excel uploads (.xls / .xlsx) parse on the same File Input path as CSV and JSON.
- One sheet: you get tabular rows (one workflow row per spreadsheet row). Date-formatted cells import as ISO dates; see File Input (Excel dates).
- Several sheets: you get one workflow row whose keys are the sheet names. Each sheet keeps
_sheetNameand_sheetDatawith that sheet’s columns, so schema inference can describe Sheet 3 independently of Sheet 1. A Schema node item port under_sheetData(path ending in.0) unnests that sheet into tabular rows; the_sheetDatafield port stays one nested-array cell. File Input Data preview shows a tab per sheet; canvas hover includes the sheet count when there is more than one sheet. See File Input (Excel workbooks with several sheets). - Empty sheets: skipped. A workbook with only empty sheets is rejected.
FIX parsing
Section titled “FIX parsing”FIX (Financial Information eXchange) log files load through the same File Input path as other structured imports.
- One row per message - each FIX message becomes one workflow row.
- Delimiters - SOH (ASCII 1), pipe (
|), and escaped\x01field separators are accepted in log files. - Field names - standard FIX tags map to readable column names such as
MsgTypeandSenderCompID. Unknown tags keep the numeric tag; duplicate tags can appear as arrays. - Message boundaries - messages are recognised from
8=FIX.through the10=checksum field. - Structured import - FIX rows are treated as already structured (one row per message). The importer does not suggest subgrid flattening for FIX sources.
Related finance formats on File Input: SWIFT (.swift, .mt940) and OFX/QFX use separate parsers in the same package. FIX round-trip export is supported on Egress via Save File Export.
Related documentation
Section titled “Related documentation”- Ingress - File Input, REST Input, and PyAirbyte connectors
- Egress - Save File Export and FIX round-trip
- Storage and processing - Arrow datasets and the workflow file store