from xlsx Command Description

--- title: from xlsx categories: | formats version: 0.104.0 formats: | Parse binary Excel(.xlsx) data and create table. usage: | Parse binary Excel(.xlsx) data and create table. editLink: false contributors: false ---  # `from xlsx` for [formats](/commands/categories/formats.md) <div class='command-title'>Parse binary Excel(.xlsx) data and create table.</div> ## Signature ```> from xlsx {flags} ``` ## Flags - `--sheets, -s {list<string>}`: Only convert specified sheets ## Input/output types: | input | output | | ------ | ------ | | binary | table | ## Examples Convert binary .xlsx data to a table ```nu > open --raw test.xlsx | from xlsx ``` Convert binary .xlsx data to a table, specifying the tables ```nu > open --raw test.xlsx | from xlsx --sheets [Spreadsheet1] ```

The `from xlsx` command in Nushell is designed to parse binary data from Excel (.xlsx) files and convert it into a structured table format that can be easily manipulated within Nushell. This command is part of the 'formats' category, indicating its role in handling different data formats. It takes binary data as input, typically from a file opened in raw mode (e.g., using `open --raw`), and outputs a Nushell table. A key feature is the `--sheets` flag, which enables users to selectively convert specific sheets within the Excel file, providing control over the data import process. Without the `--sheets` flag, the command will likely attempt to convert all sheets in the Excel file. This command is useful for extracting and working with data stored in Excel files directly within the Nushell environment, allowing for scripting and automation of data processing tasks. Examples are provided to illustrate basic usage and how to specify sheets for conversion.