1CSVLOOK(1)                          csvkit                          CSVLOOK(1)
2
3
4

NAME

6       csvlook - csvlook Documentation
7

DESCRIPTION

9       Renders a CSV to the command line in a Markdown-compatible, fixed-width
10       format:
11
12          usage: csvlook [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]
13                         [-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-L LOCALE]
14                         [-S] [--blanks] [--date-format DATE_FORMAT]
15                         [--datetime-format DATETIME_FORMAT] [-H] [-K SKIP_LINES] [-v]
16                         [-l] [--zero] [-V] [--max-rows MAX_ROWS]
17                         [--max-columns MAX_COLUMNS]
18                         [--max-column-width MAX_COLUMN_WIDTH] [-y SNIFF_LIMIT] [-I]
19                         [FILE]
20
21          Render a CSV file in the console as a Markdown-compatible, fixed-width table.
22
23          positional arguments:
24            FILE                  The CSV file to operate on. If omitted, will accept
25                                  input as piped data via STDIN.
26
27          optional arguments:
28            -h, --help            show this help message and exit
29            --max-rows MAX_ROWS   The maximum number of rows to display before
30                                  truncating the data.
31            --max-columns MAX_COLUMNS
32                                  The maximum number of columns to display before
33                                  truncating the data.
34            --max-column-width MAX_COLUMN_WIDTH
35                                  Truncate all columns to at most this width. The
36                                  remainder will be replaced with ellipsis.
37            -y SNIFF_LIMIT, --snifflimit SNIFF_LIMIT
38                                  Limit CSV dialect sniffing to the specified number of
39                                  bytes. Specify "0" to disable sniffing.
40            -I, --no-inference    Disable type inference when parsing the input.
41
42       If a table is too wide to display properly try  piping  the  output  to
43       less -S or truncating it using csvcut.
44
45       If the table is too long, try filtering it down with grep or piping the
46       output to less.
47
48       See also: Arguments common to all tools.
49
50       NOTE:
51          The fractional part of a decimal numberal is  always  truncated.  To
52          control  this  truncation,  use --no-inference along with --max-col‐
53          umn-width.
54

EXAMPLES

56       Basic use:
57
58          csvlook examples/testfixed_converted.csv
59
60       This tool is especially useful as a final operation when piping through
61       other tools:
62
63          csvcut -c 9,1 examples/realdata/FY09_EDU_Recipients_by_State.csv | csvlook
64

AUTHOR

66       Christopher Groskopf
67

69       2023, Christopher Groskopf
70
71
72
73
741.1.0                            Jan 20, 2023                       CSVLOOK(1)
Impressum