Input · Files

Excel Reader

Reads one worksheet of an Excel workbook, the first sheet unless you pick another.

Also known as: XLSX, spreadsheet

How it works

The node reads one worksheet of a workbook (.xlsx, .xlsm, .xls, .xlsb or .ods). Once the workbook is known, Sheet lists its visible sheets; leave it blank and the first visible sheet is read, with a warning naming the sheets that were skipped. Sheet cannot be bound to a loop item; to run once per sheet use the Sheets source instead. File path can be typed or bound to a column of the Loop's Current item, so a loop over several workbooks reads the same sheet from each.

Inputs and outputs

Settings

Example

A budget workbook whose first sheet is a cover page called Summary and whose numbers sit on Data. Pick Data in Sheet; the warning about the skipped sheet disappears and the preview shows the rows you want.

More in Files

• CSV Reader — Reads a CSV or other delimited text file, such as a TSV. Column types are detected for you, and you can override them or read every column as text.
• Fixed-width Reader — Reads a text file whose columns sit at fixed character positions, such as a mainframe export or a legacy feed, slicing each line at the positions you set on a ruler over the file's first lines. Header row, start line, encoding and row limit work as in the CSV Reader.
• JSON Reader — Reads a .json, .jsonl or .ndjson file as a table. A JSON array of objects and one-object-per-line files are both detected automatically.
• Parquet Reader — Reads a Parquet file and keeps the column types stored in it.
• Geo Reader — Reads a map file with its geometry: GeoJSON, Shapefile (also zipped), GeoPackage, GML, KML/KMZ, GPX, FlatGeobuf or MapInfo TAB. For a file with several layers, you pick which layer to read.
• XML Reader — Reads an XML file into a table. It finds the repeating record element for you, so each record becomes a row.
• SQLite Reader — Reads one table from a local SQLite database file (.sqlite, .sqlite3 or .db). You pick the table from the file's list of tables.
• Locra Table Reader — Reads a .ddtable file saved by Write Locra Table, in this project or another one. The column formats come back too, so everything prints as it did.