# xan from ```txt Convert a variety of data formats to CSV. Usage: xan from [options] [] xan from --help Supported formats: - ods: OpenOffice spreadsheet - xls, xlsb, xlsx: Excel spreadsheet - json: JSON array or object - ndjson, jsonl: newline-delimited JSON data - txt: text lines - npy: numpy array - tar: tarball archive - md, markdown: Markdown table Some formats can be streamed, some others require the full file to be loaded into memory. The streamable formats are `ndjson`, `jsonl`, `tar`, `txt` and `npy`. Some formats will handle gzip decompression on the fly if the filename ends in `.gz`: `json`, `ndjson`, `jsonl`, `tar` and `txt`. Tarball extraction was designed for utf8-encoded text files. Expect weird or broken results with other encodings or binary files. from options: -f, --format Format to convert from. Will be inferred from file extension if not given. Must be specified when reading from stdin, since we don't have a file extension to work with. Excel/OpenOffice-related options: --sheet-index 0-based index of the sheet to convert. Defaults to converting the first sheet. Use -s/--sheet alternatively to select a sheet by name. [default: 0] --sheet-name Name of the sheet to convert. --list-sheets Print sheet names instead of converting file. JSON options: --sample-size Number of records to sample before emitting headers. [default: 64] --key-column Name for the key column when parsing a JSON map. [default: key] --value-column Name for the value column when parsing a JSON map. [default: value] Text lines options: -c, --column Name of the column to create. [default: value] Markdown options: -n, --nth-table Select nth table in document, starting at 0. Negative index can be used to select from the end. [default: 0] Common options: -h, --help Display this message -o, --output Write output to instead of stdout. ```