Extract Tables AI (Excel) Node

E

Data/Excel

Uses AI to locate tables in complex Excel worksheets (unusual layouts, multiple tables, multi-row headers, styling-based hints); extraction itself stays deterministic

data_excel_extract_tables_aidataLong running

Inputs6

Outputs3

Security exposureUnrated

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

SchemaBitBitBit19 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

SchemaFlowPathFlowPathFlowPath3 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', 'Only rows highlighted green matter')

Config

Struct

config

AI extraction configuration

SchemaAIExtractionConfigAIExtractionConfigAIExtractionConfig5 fields

sample_rowsinteger:uint

Maximum rows rendered verbatim in the prompt (boundary rows are prioritized)

format uintdefault 80min 0

sample_colsinteger:uint

Maximum columns rendered per row

format uintdefault 30min 0

include_statisticsboolean

Include per-column type profiles in the prompt

default true

detect_merged_regionsboolean

Include the merged-region list in the prompt

default true

max_tool_turnsinteger:uint

Maximum tool-use turns per sheet before falling back to heuristics

format uintdefault 6min 0

Default {"sample_rows":80,"sample_cols":30,"include_statistics":true,"detect_merged_regions":tr...

Schema enforced

Output Pins

3

Output

Execution

exec_out

Next

Tables

Struct Array

tables

Extracted tables

SchemaCSVTableCSVTableCSVTable6 fields

namestring | null

Optional name/identifier for this table

titlestring | null

Optional title text found above the table in the source sheet

rangestring | null

Optional A1 range the table was extracted from (e.g. "A3:F42")

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

4