Convert a variety of data formats to CSV.
Usage:
xan from [options] [<input>]
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> 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 <i> 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> Name of the sheet to convert.
--list-sheets Print sheet names instead of converting file.
JSON options:
--sample-size <n> Number of records to sample before emitting headers.
Set to -1 to sample ALL records before emitting headers.
This may cost a lot of memory but will ensure all possible
keys have been observed and no data is lost when converting.
[default: 64]
--sort-keys Sort JSON keys lexicographically to emit columns accordingly.
This can be useful to harmonize different JSON sources with
no consistent key ordering.
--key-column <name> Name for the key column when parsing a JSON map.
[default: key]
--value-column <name> Name for the value column when parsing a JSON map.
[default: value]
--single-object Use if JSON only represents a single object that you want
to map to a single CSV row, instead of mapping to key,value columns.
Text lines options:
-c, --column <name> Name of the column to create.
[default: value]
Markdown options:
-n, --nth-table <n> 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 <file> Write output to <file> instead of stdout.