.\" DO NOT MODIFY THIS FILE!  It was generated by help2man 1.49.1.
.TH CSVJSON "1" "March 2022" "csvjson 1.0.7" "User Commands"
.SH NAME
csvjson \- manual page for csvjson 1.0.7
.SH DESCRIPTION
usage: csvjson [\-h] [\-d DELIMITER] [\-t] [\-q QUOTECHAR] [\-u {0,1,2,3}] [\-b]
.IP
[\-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]
.PP
Convert a CSV file into JSON (or GeoJSON).
.SS "positional arguments:"
.TP
FILE
The CSV file to operate on. If omitted, will accept
input as piped data via STDIN.
.SS "optional arguments:"
.TP
\fB\-h\fR, \fB\-\-help\fR
show this help message and exit
.TP
\fB\-d\fR DELIMITER, \fB\-\-delimiter\fR DELIMITER
Delimiting character of the input CSV file.
.TP
\fB\-t\fR, \fB\-\-tabs\fR
Specify that the input CSV file is delimited with
tabs. Overrides "\-d".
.TP
\fB\-q\fR QUOTECHAR, \fB\-\-quotechar\fR QUOTECHAR
Character used to quote strings in the input CSV file.
.TP
\fB\-u\fR {0,1,2,3}, \fB\-\-quoting\fR {0,1,2,3}
Quoting style used in the input CSV file. 0 = Quote
Minimal, 1 = Quote All, 2 = Quote Non\-numeric, 3 =
Quote None.
.TP
\fB\-b\fR, \fB\-\-no\-doublequote\fR
Whether or not double quotes are doubled in the input
CSV file.
.TP
\fB\-p\fR ESCAPECHAR, \fB\-\-escapechar\fR ESCAPECHAR
Character used to escape the delimiter if \fB\-\-quoting\fR 3
("Quote None") is specified and to escape the
QUOTECHAR if \fB\-\-no\-doublequote\fR is specified.
.TP
\fB\-z\fR FIELD_SIZE_LIMIT, \fB\-\-maxfieldsize\fR FIELD_SIZE_LIMIT
Maximum length of a single field in the input CSV
file.
.TP
\fB\-e\fR ENCODING, \fB\-\-encoding\fR ENCODING
Specify the encoding of the input CSV file.
.TP
\fB\-L\fR LOCALE, \fB\-\-locale\fR LOCALE
Specify the locale (en_US) of any formatted numbers.
.TP
\fB\-S\fR, \fB\-\-skipinitialspace\fR
Ignore whitespace immediately following the delimiter.
.TP
\fB\-\-blanks\fR
Do not convert "", "na", "n/a", "none", "null", "." to
NULL.
.TP
\fB\-\-date\-format\fR DATE_FORMAT
Specify a strptime date format string like "%m/%d/%Y".
.TP
\fB\-\-datetime\-format\fR DATETIME_FORMAT
Specify a strptime datetime format string like
"%m/%d/%Y %I:%M %p".
.TP
\fB\-H\fR, \fB\-\-no\-header\-row\fR
Specify that the input CSV file has no header row.
Will create default headers (a,b,c,...).
.TP
\fB\-K\fR SKIP_LINES, \fB\-\-skip\-lines\fR SKIP_LINES
Specify the number of initial lines to skip before the
header row (e.g. comments, copyright notices, empty
rows).
.TP
\fB\-v\fR, \fB\-\-verbose\fR
Print detailed tracebacks when errors occur.
.TP
\fB\-l\fR, \fB\-\-linenumbers\fR
Insert a column of line numbers at the front of the
output. Useful when piping to grep or as a simple
primary key.
.TP
\fB\-\-zero\fR
When interpreting or displaying column numbers, use
zero\-based numbering instead of the default 1\-based
numbering.
.TP
\fB\-V\fR, \fB\-\-version\fR
Display version information and exit.
.TP
\fB\-i\fR INDENT, \fB\-\-indent\fR INDENT
Indent the output JSON this many spaces. Disabled by
default.
.TP
\fB\-k\fR KEY, \fB\-\-key\fR KEY
Output JSON as an object keyed by a given column, KEY,
rather than as an array. All column values must be
unique. If \fB\-\-lat\fR and \fB\-\-lon\fR are specified, this column
is used as the GeoJSON Feature ID.
.TP
\fB\-\-lat\fR LAT
A column index or name containing a latitude. Output
will be GeoJSON instead of JSON. Requires \fB\-\-lon\fR.
.TP
\fB\-\-lon\fR LON
A column index or name containing a longitude. Output
will be GeoJSON instead of JSON. Requires \fB\-\-lat\fR.
.TP
\fB\-\-type\fR TYPE
A column index or name containing a GeoJSON type.
Output will be GeoJSON instead of JSON. Requires \fB\-\-lat\fR
and \fB\-\-lon\fR.
.TP
\fB\-\-geometry\fR GEOMETRY
A column index or name containing a GeoJSON geometry.
Output will be GeoJSON instead of JSON. Requires \fB\-\-lat\fR
and \fB\-\-lon\fR.
.TP
\fB\-\-crs\fR CRS
A coordinate reference system string to be included
with GeoJSON output. Requires \fB\-\-lat\fR and \fB\-\-lon\fR.
.TP
\fB\-\-no\-bbox\fR
Disable the calculation of a bounding box.
.TP
\fB\-\-stream\fR
Output JSON as a stream of newline\-separated objects,
rather than an as an array.
.TP
\fB\-y\fR SNIFF_LIMIT, \fB\-\-snifflimit\fR SNIFF_LIMIT
Limit CSV dialect sniffing to the specified number of
bytes. Specify "0" to disable sniffing entirely, or
"\-1" to sniff the entire file.
.TP
\fB\-I\fR, \fB\-\-no\-inference\fR
Disable type inference (and \fB\-\-locale\fR, \fB\-\-date\-format\fR,
\fB\-\-datetime\-format\fR) when parsing CSV input.
.SH "SEE ALSO"
The full documentation for
.B csvjson
is maintained as a Texinfo manual.  If the
.B info
and
.B csvjson
programs are properly installed at your site, the command
.IP
.B info csvjson
.PP
should give you access to the complete manual.