Scroll to navigation

CSVJSON(1) User Commands CSVJSON(1)

NAME

csvjson - manual page for csvjson 1.1.1

DESCRIPTION

usage: csvjson [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]

[-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-L LOCALE] [-S] [--blanks] [--date-format DATE_FORMAT] [--datetime-format DATETIME_FORMAT] [-H] [-K SKIP_LINES] [-v] [-l] [--zero] [-V] [-i INDENT] [-k KEY] [--lat LAT] [--lon LON] [--type TYPE] [--geometry GEOMETRY] [--crs CRS] [--no-bbox] [--stream] [-y SNIFF_LIMIT] [-I] [FILE]

Convert a CSV file into JSON (or GeoJSON).

positional arguments:

The CSV file to operate on. If omitted, will accept input as piped data via STDIN.

options:

show this help message and exit
Delimiting character of the input CSV file.
Specify that the input CSV file is delimited with tabs. Overrides "-d".
Character used to quote strings in the input CSV file.
Quoting style used in the input CSV file. 0 = Quote Minimal, 1 = Quote All, 2 = Quote Non-numeric, 3 = Quote None.
Whether or not double quotes are doubled in the input CSV file.
Character used to escape the delimiter if --quoting 3 ("Quote None") is specified and to escape the QUOTECHAR if --no-doublequote is specified.
Maximum length of a single field in the input CSV file.
Specify the encoding of the input CSV file.
Specify the locale (en_US) of any formatted numbers.
Ignore whitespace immediately following the delimiter.
Do not convert "", "na", "n/a", "none", "null", "." to NULL.
Specify a strptime date format string like "%m/%d/%Y".
Specify a strptime datetime format string like "%m/%d/%Y %I:%M %p".
Specify that the input CSV file has no header row. Will create default headers (a,b,c,...).
Specify the number of initial lines to skip before the header row (e.g. comments, copyright notices, empty rows).
Print detailed tracebacks when errors occur.
Insert a column of line numbers at the front of the output. Useful when piping to grep or as a simple primary key.
When interpreting or displaying column numbers, use zero-based numbering instead of the default 1-based numbering.
Display version information and exit.
Indent the output JSON this many spaces. Disabled by default.
Output JSON as an object keyed by a given column, KEY, rather than as an array. All column values must be unique. If --lat and --lon are specified, this column is used as the GeoJSON Feature ID.
A column index or name containing a latitude. Output will be GeoJSON instead of JSON. Requires --lon.
A column index or name containing a longitude. Output will be GeoJSON instead of JSON. Requires --lat.
A column index or name containing a GeoJSON type. Output will be GeoJSON instead of JSON. Requires --lat and --lon.
A column index or name containing a GeoJSON geometry. Output will be GeoJSON instead of JSON. Requires --lat and --lon.
A coordinate reference system string to be included with GeoJSON output. Requires --lat and --lon.
Disable the calculation of a bounding box.
Output JSON as a stream of newline-separated objects, rather than an as an array.
Limit CSV dialect sniffing to the specified number of bytes. Specify "0" to disable sniffing entirely, or "-1" to sniff the entire file.
Disable type inference (and --locale, --date-format, --datetime-format) when parsing CSV input.

SEE ALSO

The full documentation for csvjson is maintained as a Texinfo manual. If the info and csvjson programs are properly installed at your site, the command

info csvjson

should give you access to the complete manual.

March 2023 csvjson 1.1.1