Skip to content

Extract Tables AI (Excel) Node

Data/Excel

Extract Tables AI (Excel)

Uses AI to intelligently extract tables from complex Excel worksheets with unusual layouts

data_excel_extract_tables_aidataLong running
Inputs6
Outputs3
Security exposure10/10
Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

6

Input

Execution
exec_in

Trigger

Model

Struct
model

AI model for analysis

BitBit19 fields
idstring
default ""
typeBitTypes
enum "Llm", "Vlm", "Tts", "Stt"...default "Other"
metaMap<string, Metadata>
default {}
*Metadatamap value
namestringrequired
descriptionstringrequired
long_descriptionstring | null
release_notesstring | null
tagsArray<string>required
itemsstringarray item
+11 more fields
authorsArray<string>
default []
itemsstringarray item
repositorystring | null
default null
download_linkstring | null
default null
file_namestring | null
default null
hashstring
default ""
sizeinteger | null
format uint64default nullmin 0
hubstring
default ""
parametersvalue
default null
versionstring | null
default null
licensestring | null
default null
dependenciesArray<string>
default []
itemsstringarray item
dependency_tree_hashstring
default ""
createdstring
default ""
updatedstring
default ""
model_slugstring | null
default null
+1 more fields
Schema enforced

File

Struct
file

Excel file

FlowPathFlowPath3 fields
pathstringrequired
store_refstringrequired
cache_store_refstring | null
Schema enforced

Sheet

String
sheet

Worksheet name (optional - if empty, extracts from all sheets)

User Hint

String
user_hint

Optional guidance for the AI (e.g., 'The table starts at row 5', 'Skip rows with TOTAL')

Config

Struct
config

AI extraction configuration

AIExtractionConfigAIExtractionConfig4 fields
sample_rowsinteger:uintrequired
format uintmin 0
sample_colsinteger:uintrequired
format uintmin 0
include_statisticsbooleanrequired
detect_merged_regionsbooleanrequired
Default {"sample_rows":15,"sample_cols":20,"include_statistics":true,"detect_merged_regions":true}
Schema enforced

Output Pins

3

Output

Execution
exec_out

Next

Tables

Struct Array
tables

Extracted tables

CSVTableCSVTable4 fields
namestring | null

Optional name/identifier for this table

headersArray<string>required
itemsstringarray item
rowsArray<Array<Cell>>required
itemsArray<Cell>array item
itemsCellarray item
variant 1nullvariant
variant 2booleanvariant
variant 3integer:int64variant
format int64
variant 4number:doublevariant
format double
variant 5stringvariant
+1 more fields
sourceanyOf (2)
variant 1FlowPathvariant
pathstringrequired
store_refstringrequired
cache_store_refstring | null
variant 2nullvariant

Reasoning

String
reasoning

AI's explanation of extraction strategy

Node Info

Internal name
data_excel_extract_tables_ai
Category
Data/Excel
Version
3