Read XLSX

Controlled node

Overview

The Read XLSX node reads Excel spreadsheet files (.xlsx) from the Intellectible library and parses their contents into structured data. It processes all tabs/sheets within the spreadsheet and returns the data as a list of records (objects) where possible, making it easy to work with tabular data in your workflows.

This node is useful for importing data from Excel files, processing spreadsheet contents, or converting Excel data into formats that can be used by other nodes in your workflow.

Inputs

Input	Type	Description	Default
Run	Event	Fires when the node starts running	-
File	Data	The XLSX file to read from the library. Accepts a file object with id and mimeType properties.	-

Outputs

Output	Type	Description
Done	Event	Fires when the node has finished reading and parsing the file
Output	Data	Contains the parsed data from the XLSX file. Returns a list of records/objects representing the data from each tab in the spreadsheet. Returns an error object if parsing fails.

Runtime Behavior and Defaults

File Validation

The node performs strict validation on the input file:

• Mime Type Check: The file must have the mime type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet (standard XLSX format)
• Project Context: Requires a valid project ID from the runtime context
• File Selection: If an array of files is provided, only the first file is processed

Data Processing

• Multi-tab Support: Processes all tabs/sheets within the XLSX file
• Record Conversion: Attempts to convert tabular data into structured records/objects where possible
• Error Handling: Returns an error object with descriptive messages if:
  • No project ID is found
  • Invalid file input is provided
  • The file is not a valid XLSX format
  • Parsing fails for any reason

Output Format

The output is typically an array of objects representing rows from the spreadsheet, with column headers mapped to object keys. When multiple tabs are present, the structure may vary based on the specific parsing implementation.

Example Usage

Basic File Reading

Connect a file picker or library file node to the File input, then trigger the Run event to read the spreadsheet:

1. Add a Read XLSX node to your workflow
2. Connect a file source (from the library or a file picker) to the File input
3. Connect the Run input to a trigger event (like a Start node or button click)
4. Connect the Output to a Show node to inspect the data, or to processing nodes like InsertIntoDatabase to store the records

Processing Excel Data

After reading an XLSX file, you can:

• Use For Each nodes to iterate through the records
• Connect to database nodes to import data into project databases
• Use AI Write nodes to generate summaries or reports from the spreadsheet data
• Transform the data using Data or Formula nodes before further processing

File Selection

Use the file picker in the node's panel UI to select an XLSX file from your library, or connect the output of a Get Library Files or Find Library Files node to dynamically select files.